/* ************************************************ */
/*                                                  */
/* Script: Determine if the database data files are */
/*         experienceing I/O contention             */
/*                                                  */
/* name:    @c:\oracle\sql\v$datafi.sql             */
/* date:    24-AUG-95                               */
/* creator: Rick Kupcunas                           */
/*                                                  */
/* ************************************************ */

set pagesize 65;
set linesize 80;

select substr(name, 1, 8)   "NAME",
     created,
     log_mode,
     checkpoint_change# "CHK_POINT",
     archive_change#    "ARCH_CHG#"
from v$database;

commit;

