Open the performance page of a database, here in the Average Active Session chart, click on the CPU block on the chart of its corresponding wait class. The Active Sessions Working page appears. And when we click on the dark area which is pointed out here with arrow, then we can see the 'Detail for select 5 minute interval' page. Here we can see the 'Top Working session' table.
Under the 'top working session' table, click on the SESSION ID link of the most active session link. The session details page appears.
This page contains information such as session activity, session statistics, open cursors, blocking sessions, wait events, and parallel SQL for the selected session.
In this example user SYS is consuming 100% of database activity and should be investigated.
Because the session is consuming 100 percent of database activity, consider ending the session by clicking Kill Session, and proceeding to tune the SQL statement that this session is running.
This page contains information such as session activity, session statistics, open cursors, blocking sessions, wait events, and parallel SQL for the selected session.
In this example user SYS is consuming 100% of database activity and should be investigated.
Because the session is consuming 100 percent of database activity, consider ending the session by clicking Kill Session, and proceeding to tune the SQL statement that this session is running.
No comments:
Post a Comment