--数据字典表
select * from v$fixed_table;
select * from v$fixed_view_definition;
select * from dictionary;
--基础信息
select * from v$version;
select * from v$license;
select * from v$database;
select * from v$instance;
select * from v$sga;
select * from v$spparameter
select * from v$parameter;
select * from v$sysstat;
--进程会话
select * from v$thread;
select * from v$process;
select * from v$session;
--文件信息
select * from v$controlfile;
select * from v$datafile;
select * from v$logfile;
select * from v$archived_log;
--数据库对象
select * from v$tablespace;
select * from v$transaction
--IO stat
select * from v$segstat;
select * from v$filestat;
select * from v$tempstat;
--Event
select * from V$EVENT_NAME;
select * from v$system_event;
select * from V$SERVICE_EVENT;
select * from V$SESSION_EVENT;
--OWI
select * from V$WAITSTAT;
select * from V$WAIT_CHAINS;
select * from V$SYSTEM_WAIT_CLASS;
select * from V$SERVICE_WAIT_CLASS;
select * from V$SESSION_WAIT_CLASS;
select * from V$SESSION_WAIT;
select * from V$SESSION_WAIT_HISTORY;
select * from V$CHANNEL_WAITS;
--sql信息
select * from v$sql;
select * from v$sqltext;
select * from v$sqlarea;
--lock,latch
select * from v$lock;
select * from v$latch;
--advice
select * from v$db_cache_advice;
select * from v$PGA_TARGET_ADVICE;
select * from v$SHARED_POOL_ADVICE;
--ADR自动诊断库
select * from v$diag_info;
--审计信息
select * from sys.aud$