ASA SQL Reference
System Procedures and Functions
System and catalog stored procedures
Analyses the request-level log to determine the execution times of similar statements.
sa_get_request_profile ( [ request-log-filename [, connection-id ] ] )
DBA authority required.
Automatic commit.
sa_get_request_times system procedure
sa_statement_text system procedure
sa_server_option system procedure
This procedure calls sa_get_request_times to process a log file, and then summarizes the results into the global temporary table satmp_request_profile. This table contains the statements from the log along with how many times each was executed, and their total, average, and maximum execution times. The table can be sorted in various ways to identify targets for performance optimization efforts.
If you do not specify a log file, the default is the current log file that is specified at the command prompt with -zo, or that has been specified by
sa_server_option( 'request_level_log_file', filename )
If a connection id is specified, it is used to filter information from the log so that only requests for that connection are retrieved.