10.6 The Sessions Page
Note:
Available only if you signed in as a database user with DBA and PDB_DBA roles.To navigate to the Sessions page, do either of the following:
-
In the Launchpad page, click Sessions.
-
Click Selector
to display the navigation menu. Under Monitoring, select Sessions.
The data is automatically refreshed at intervals ranging from 10 seconds to 2
minutes. You can also refresh the data by clicking Refresh at the top right of the screen.
The table shows summarized data about each open session. Select a session in the table to see more detailed data in the Session Details table below, such as the last SQL statement, explain plan, waits, contention, and so on. You can use the Column, Operator and Value fields to search for the required sessions.
In the display table, if you right-click the header row, you see:
Columns: Enables you to select columns to show or hide.
Sort: Displays a dialog box for selecting columns to sort by. For each column, you can specify ascending or descending order, and you can specify that null values be displayed first.
If you right-click any other part of the display table, you see:
Count Rows: Displays the number of rows in the table.
Single Record View: Enables you to view data for a table or view, one record at a time.
Copy: Enables you to copy data from a cell or a row or a range of rows. To copy from more than one row, select the rows you want to copy by pressing the SHIFT or CTRL key, right-click and select Copy.