v$system_event解析

lfree發表於2007-05-12
原文網址 : http://blog.itpub.net/267265/viewspace-83028/

v$system_event

This view displays the count (total_waits) of all since of the .
If is set to true, the sum of the for all are also displayed in the column time_waited.
The unit of time_waited is one hundreth of a second. Since 10g, an additional column (time_waited_micro) measures wait times in millionth of a second.
total_waits where event='' is equal the sum of count in .
can be used to break down waits on the wait event.
While this view totals all events in an instance, breaks it down to all currently connected .

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/267265/viewspace-83028/，如需轉載，請註明出處，否則將追究法律責任。

相關文章