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
Click SQL & Application Workload | Analyze Trace | Trace Files.
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. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center