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