Table 45. List of Siebel 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 the sum of the connector prepare logic time plus the network time plus the database SQL parse time. NOTE: It is recommended that you seek the assistance of your database administrator when optimizing the performance of SQL statements.
|