List of Siebel Database Infrastructure Statistics

The following table describes the statistics specific to the Siebel database infrastructure. For background information about Siebel application statistics, see About Siebel Application Statistics.

Statistic Name	Alias	Description
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.