1.v$sysstat
2.v$bh+x$bh
3.v$session+v$session_wait
4.v$process
5.v$sql
6.v$sqltext
7.v$lock
8.v$latch_children
9.v$system_event
1.system 的over view
v$sysstat,v$sysstat_event,v$parameter
2.某个session的当前情况
v$process,v$session,v$session_wait,v$session_event,v$sesstat
3.sql的情况
v$sql,v$sqlarea,v$sql_plan_statistics,v$sqltext_with_newlines
4.latch/lock/enqueue
v$latch,v$latch_children,v$latch_holder,v$lock,v$enqueue_stat,v$enqueue_lock
5.i/o方面
v$segstat,v$filestat,v$tempstat,v$datafile,v$tempfile
6.shared pool/library cache
v$librarycache,v$rowcache,x$ksmsp
7.其他
v$db_cache_advice,v$pga_target_advice,v$shared_pool_advice
