1、可以通过v$fixed_table 或dictionary来得到oracle中所有的数据字典
2、v$database
SQL> select name,created,log_mode,open_mode from v$database;NAME CREATED LOG_MODE OPEN_MODE ------------------------------ --------- ------------ -------------------- ORCL 29-NOV-23 ARCHIVELOG READ WRITE
3、v$instance
SQL> select host_name,version,status,blocked,instance_name from v$instance ;HOST_NAME ---------------------------------------------------------------- VERSION STATUS BLO INSTANCE_NAME ----------------- ------------ --- ---------------- localhost.localdomain 11.2.0.1.0 OPEN NO orcl
4、v$version
SQL> select * from v$version;BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS for Linux: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production
5、V$controlfile;
SQL> select * from v$controlfile;STATUS NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS ------- ------------------------------ --- ---------- --------------/u01/app/oracle/oradata/orcl/c NO 16384 600ontrol01.ctl/u01/app/oracle/flash_recovery NO 16384 600_area/orcl/control02.ctl
6、v$log
SQL> select * from v$log;GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC ---------- ---------- ---------- ---------- ---------- ---------- --- STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME ---------------- ------------- --------- ------------ ---------1 1 190 52428800 512 1 YES INACTIVE 3469063 11-MAR-24 3514833 24-OCT-252 1 189 52428800 512 1 YES INACTIVE 3454354 11-MAR-24 3469063 11-MAR-243 1 191 52428800 512 1 NO CURRENT 3514833 24-OCT-25 2.8147E+14
7,v$logfile
SQL> select group#,type,member from v$logfile;GROUP# TYPE MEMBER ------ ------- ------------------------------------------------------------1 ONLINE /u01/app/oracle/oradata/orcl/redo01.log2 ONLINE /u01/app/oracle/oradata/orcl/redo02.log3 ONLINE /u01/app/oracle/oradata/orcl/redo03.log