Friday, February 5, 2010

Get Oracle system events

SELECT EVENT,
TOTAL_WAITS,
TOTAL_TIMEOUTS,
TIME_WAITED,
ROUND(AVERAGE_WAIT,2) AVAREAGE_WAIT
FROM v$system_event
ORDER BY TOTAL_WAITS

No comments:

Post a Comment

Oracle Query