select * from v$event_name

select * from v$system_event ---例項啟動以來，所有會話發生的等待事件的累積資訊

select * from v$session_event ---表示當前已連線的各會話的等待時間的累積資訊

select * from v$session_wait ---表示當前各會話正等待時間的資訊

select * from v$session_wait_history ---將v$session_wait資訊按會話分類，最多提供10個

select * from v$system_wait_class ---在v$system_event基礎上，按照wait_class進行分類

select * from v$session_wait_class ---在v$session_event基礎上，按照wait_class進行分類

select * from v$event_histogram ---對各等待事件，按照等待時間表示等待次數

-======================================================

select * from v$active_session_history

select * from v$session

select * from v$process

select * from v$transaction

select * from v$latch,v$latch_parent,v$latch_children,v$latch_misses

select * from v$sql

select * from v$lock,v$locked_object,v$enqueue_lock

select * from v$librarycache,x$kgllk,x$kglpn

select * from v$rowcache,v$rowcache_parent

select * from v$sgastat,v$sesstat

select * from v$segment_statistics

select * from v$bh,xbh

select * from v$sess_time_model,v$sys_time_model

[@more@]

oracle wait event的一些動態效能檢視

相關文章