oracle wait event的一些动态性能视图

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@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24237320/viewspace-1059543/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24237320/viewspace-1059543/