Sunday, October 12, 2008

Service-related statistics

V$SERVICE_WAIT_CLASS: aggregated wait counts and wait times for each service on a wait class basis, shows all wait statistics for each service, broken down by wait class.
V$SERVICE_EVENT: aggregated wait counts and wait times for each service on a per wait class basis, shows the same information as V$SERVICE_WAIT_CLASS, except that it is further broken down by event ID.

Oracle data dictionary views
Oracle dynamic performance views

No comments:

Post a Comment