Chat now with support
Chat mit Support

Spotlight on Oracle 10.5 - Release Notes

Calls Page

The Calls table displays information about procedure calls for the selected SQL statement.

To open the Calls page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. Click SQL & Application Workload | Analyze Trace | Trace Files.

  3. Select a Trace File.
  4. 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
  5. Click SQL Statements Page and select a SQL statement.
  6. 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.

 

Related Topics

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen