Chat now with support
Chat with Support

Spotlight on Oracle 10.5 - Release Notes

Binds Page

The Binds sub-page displays information about bind variables for the selected SQL statement.

The use of bind variables allows SQL statements to be re-executed without re-parsing the SQL statement.

To open the Binds 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 | Binds.

Binds Grid

Column Description

Bind Variable Combination

Each row in the table represents a unique combination of the literal values used within bind variables in the selected SQL statement.

Count

The number of times the SQL statement was executed with the specified combination of literal values.

Elapsed (s)

The total elapsed time taken to execute the SQL statement with the specified combination of literal values.

Pct Elapsed

The elapsed time taken to execute the SQL statement with the specified combination of values, as a percentage of the time taken to execute the SQL statement for ALL combinations of bind variables.

CPU (s)

The amount of CPU time spent executing the SQL statement with the specified combination of values.

Disk

The number of physical reads from disk performed while executing the SQL statement with the specified combination of values.

Elapsed/Count

The average amount of elapsed time taken to execute the SQL statement once with the specified combination of values.

CPU/Count

The average amount of CPU time taken to execute the SQL statement once with the specified combination of values.

Disk/Count

The average number of physical reads from disk performed while executing the SQL statement once with the specified combination of values.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating