Oracle Data Dictionary

V$DATAFILE

Columns
   ___________________________
 
   PLUGGED_IN
   OFFLINE_CHANGE#
   ONLINE_CHANGE#
   ONLINE_TIME
   BYTES
   BLOCKS
   CREATE_BYTES
   LAST_TIME
   NAME
   ENABLED
   BLOCK_SIZE
   LAST_CHANGE#
   UNRECOVERABLE_TIME
   UNRECOVERABLE_CHANGE#
   CHECKPOINT_CHANGE#
   STATUS
   RFILE#
   TS#
   CREATION_TIME
   CREATION_CHANGE#
   FILE#
   CHECKPOINT_TIME

Related DBA Views:

dba_data_files - (describes database files)

Related V$ Views:

V$ACTIVE_INSTANCES 
V$BGPROCESS 
V$BH 
V$COMPATIBILITY 
V$COMPATSEG 
V$COPY_CORRUPTION 
V$DATABASE 
V$DATAFILE_COPY 
V$DATAFILE_HEADER 
V$DBFILE 
V$DBLINK 
V$DB_PIPES 
V$INSTANCE 
V$LICENSE 
V$OFFLINE_RANGE 
V$OPTION 
V$SGA 
V$SGASTAT 
V$TABLESPACE 
V$VERSION




Back to the Top

Simon Sheppard
SS64.com