I/O Segment Details
View more detailed information on the segment selected in the Segment Page.
To open I/O Segment Details
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
Click I/O | Segment Page.
- Select a row from the Segments Grid.
Sessions Using Segment Grid
This grid shows the sessions that are now using the segment selected in the Segment Page.
Notes:
- The grid shows data only if:
- The Oracle statistics_level parameter is set to ALL. I/O Segment Details - Prerequisite Steps
- There is a session currently executing a query on the selected segment. The grid will be empty once the query completes, and will not be re-populated until another query begins on the selected object.
- Oracle reports Cost-Based Optimizer queries only in related views such as v$sql_plan_statistics_all, v$segment_statistics, and so on.
| Column | Description |
|---|---|
|
SID |
The session ID. |
|
User name |
The user name of the session. |
|
Step |
The execution step in the plan of the SQL. |
|
Operation |
How the session is using the segment. It consists of the concatenation of the SQL operation and its options. |
|
CPU |
The cost of the SQL operation in CPU usage. |
|
IO |
The cost of the operation in I/O usage. |
|
Read |
The number of physical reads performed by the operation. |
|
SQL address |
The address of the SQL statement. |
|
SQL hash |
The hash value of the SQL statement. |
|
SQL text |
The source text for the SQL statement. |
SQL that used segment Grid
The SQL That Used Segment contains the text of the SQL queries in the Shared Pool that have used the segment selected in the Segment Page.