5.13.2 Accessing Session Page Reports
A session is the connection of a user to an Oracle database instance.
A session lasts from the time the user connects until the time the user disconnects or exits the database application.
- Accessing Reports on the Session Page
You must have database administrator privileges to access the Sessions page. - Creating Sessions Reports
The Sessions Report displays information about the current sessions in the database. - Controlling the Number of Rows for Locks Reports
The Locks report displays a report of sessions which have locks that are blocking other session(s). - Creating Waits Reports
The Waits report displays the wait events for each session. - Creating I/O Reports
The I/0 report displays details about the I/O for each session. - Creating SQL Reports
The SQL report displays details about the current or last SQL statement executed for each session. - Creating Open Cursors Report
The Open Cursors report displays details about the number of open cursors for each session.
Parent topic: Monitoring the Database
5.13.2.1 Accessing Reports on the Session Page
You must have database administrator privileges to access the Sessions page.
A session is the connection of a user to an Oracle database instance. A session lasts from the time the user connects until the time the user disconnects or exits the database application.
To access reports on the Sessions page:
Parent topic: Accessing Session Page Reports
5.13.2.2 Creating Sessions Reports
The Sessions Report displays information about the current sessions in the database.
Use the controls at the top of page to narrow the view:
-
Search. Enter search criteria and click Go. For search details, click the Search label.
-
Status. Select a status and click Go.
-
Show. Select how many columns to display and click Go.
-
Rows. Select the number of rows to appear in the report and click Go.
To view session details, click the Session ID (SID). The Session Details page appears. To remove the current session, navigate to the Session Details page and click Kill Session.
Parent topic: Accessing Session Page Reports
5.13.2.3 Controlling the Number of Rows for Locks Reports
The Locks report displays a report of sessions which have locks that are blocking other session(s).
To control the number of rows that appear, make a selection from the Rows list and click Go.
Parent topic: Accessing Session Page Reports
5.13.2.4 Creating Waits Reports
The Waits report displays the wait events for each session.
Use the controls at the top of page to narrow the view:
-
Search. Enter search criteria and click Go. For search details, click the Search label.
-
Status. Select a status and click Go.
-
Show. Select how many columns to display and click Go.
-
Rows. Select the number of rows to appear in the report and click Go.
To view session details, click the Session ID (SID). The Session Details page appears. To remove the current session, click Kill Session.
Parent topic: Accessing Session Page Reports
5.13.2.5 Creating I/O Reports
The I/0 report displays details about the I/O for each session.
Use the controls at the top of page to narrow the view:
-
Search. Enter search criteria and click Go. For search details, click the Search label.
-
Rows. Select the number of rows to appear in the report and click Go.
To view session details, click the Session ID (SID). The Session Details page appears. To remove the current session, click Kill Session.
Parent topic: Accessing Session Page Reports
5.13.2.6 Creating SQL Reports
The SQL report displays details about the current or last SQL statement executed for each session.
Use the controls at the top of page to narrow the view:
-
Search. Enter search criteria and click Go. For search details, click the Search label.
-
Status. Select a status and click Go.
-
Show. Select how many columns to display and click Go.
-
Rows. Select the number of rows to appear in the report and click Go.
To view session details, click the Session ID (SID). The Session Details page appears. To remove the current session, click Kill Session.
Parent topic: Accessing Session Page Reports
5.13.2.7 Creating Open Cursors Report
The Open Cursors report displays details about the number of open cursors for each session.
Use the controls at the top of page to narrow the view:
-
Search. Enter search criteria and click Go. For search details, click the Search label.
-
Status. Select a status and click Go.
-
Rows. Select the number of rows to appear in the report and click Go.
To view details about a specific open cursor count, click the numeric link under the Open Cursor Count column.
To view session details, click the Session ID (SID). The Session Details page appears. To remove the current session, click Kill Session.
Parent topic: Accessing Session Page Reports