Calls Page
The Calls table displays information about procedure calls for the selected SQL statement.
To open the Calls page
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
Click SQL & Application Workload | Analyze Trace | Trace Files.
- Select a Trace File.
- If the trace file has not been analyzed yet, right-click its row in the Trace File Details table and select Analyze Trace File. Analyze Trace Settings Dialog
- Click SQL Statements Page and select a SQL statement.
- Click SQL Statement Details Page | Calls.
Call Statistics Grid
| Column | Description |
|---|---|
|
Call |
Each row in the table represents a particular type of procedure call (parse, execute or fetch). |
|
Count |
The number of times the type of call was executed for the selected statement. |
|
CPU (ms) |
The CPU time spent executing the type of call. |
|
Elapsed (ms) |
The total elapsed time spent executing the type of call. |
|
Disk |
The number of physical reads from disk for the type of call. |
|
Query |
The number of buffers retrieved in consistent mode for queries. |
|
Current |
The number of buffers retrieved in current mode for updates. |
|
Rows |
The number of rows processed for the type of call. |
|
CPU/call |
The average time spent on a call of this type. |
|
Elapsed/call |
The average elapsed time spent executing a call of this type. |
|
Rows/call |
The average number of rows processed for a call of this type. |
|
Disk/call |
The average number of physical reads from disk for a call of this type. |
|
Logical IO/call |
The average number of logical reads for a call of this type. |