SQL> select*from v$archived_log;
SQL> select *fromv$backup;
SQL> select*from v$database;
SQL> select*from v$datafile;
SQL> select*from v$log;
SQL> select*from v$logfile;
SQL> select*from v$loghist;
SQL> select*from v$tablespace;
SQL> select*from v$tempfile;
SQL> select * fromv$tempfile;
SQL> select type,record_size,records_total,records_used from v$controlfile_record_sectionwhere rownum<5;
TYPE RECORD_SIZE RECORDS_TOTALRECORDS_USED
------------------------------- ------------- ------------
DATABASE 316 1 1
CKPT PROGRESS 8180 11 0
REDO THREAD 256 8 1
REDO LOG 72 16 16
SQL> select type,record_size,records_total,records_used from v$controlfile_record_sectionwhere type in ('DATABASE','TABLESPACE');
TYPE RECORD_SIZE RECORDS_TOTALRECORDS_USED
------------------------------- ------------- ------------
DATABASE 316 1 1
TABLESPACE 68 1000 6