Table 65. List of Database Infrastructure Statistics
|
|
|
Avg SQL Execute Time |
AvgSQLExecTime |
Average time for SQL execute operations (in seconds) |
Avg SQL Fetch Time |
AvgSQLFetchTime |
Average time for SQL fetch operations (in seconds) |
Avg SQL Parse Time |
AvgSQLParseTime |
Average time for SQL parse operations (in seconds) |
SQL Execute Time |
SQLExecTime |
Total elapsed time for SQL execute operations (in seconds) |
Number of SQL Executes |
SQLExecs |
Total number of SQL execute operations |
SQL Fetch Time |
SQLFetchTime |
Total elapsed time for SQL fetch operations (in seconds) |
Number of SQL Fetches |
SQLFetches |
Total number of SQL fetch operations |
SQL Parse Time |
SQLParseTime |
Total elapsed time for SQL parse operations (in seconds) |
Number of SQL Parses |
SQLParses |
Total number of SQL parse operations |
SQL Statement Prepare Time |
OM SQL Prepare Time |
Total elapsed time for SQL preparation operations. This statistic is used to optimize performance of SQL statements. Time is calculated as follows: sum of connector prepare logic time + network time + database SQL parse time NOTE: It is recommended that you seek the assistance of your database administrator when optimizing the performance of SQL statements.
|