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
- 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 | 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. |