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.