ASA SQL User's Guide
Monitoring and Improving Performance
Profiling database procedures
Viewing procedure profiling information in Interactive SQL
The sa_procedure_profile stored procedure provides information about individual lines within specific procedures. The result set includes the line number, execution time, and percentage of total execution time for lines within procedures. You can use the following parameters to restrict the rows the procedure returns:
p_object_name specify the name of an object to profile.
p_owner_name specify the owner whose objects you want to profile.
p_table_name specify which table you want to profile triggers for.
If you do not include any parameters in your query, the procedure returns profiling information for all the procedures that have been called.
To view profiling information for specific lines within procedures
Execute the sa_procedure_profile stored procedure.
For example, enter:
CALL sa_procedure_profile
From the SQL menu, choose Execute.
A result set with profiling information for individual procedure lines appears on the Results tab in the Results pane.
For more information about the sa_procedure_profile stored procedure, see sa_procedure_profile system procedure.