Viewing Session Activity

The Activity subpage contains a graphical representation of the session activity.

To view session activity for the SQL statement: 

1. On the SQL Details page, under Details, click Activity.

   The SQL Details page appears, showing the Activity subpage.

   The Activity subpage displays details of various sessions executing the SQL statement. The Active Sessions chart profiles the average number of active sessions over time.

2. Optionally, drag the shaded box to select a 5-minute interval.

   The Detail for Selected 5 Minute Interval section lists the sessions that executed the SQL statement during the selected 5-minute interval. The multicolored bar in the Activity % column depicts how the database time is divided for each session while executing the SQL statement.

3. Optionally, click the link in the SID column of the session you want to view to display the Session Details page.