When you reset profiling, the database clears the old information and immediately starts collecting new information about procedures, functions, events, and triggers. This section explains how to reset procedure profiling from Interactive SQL using the sa_server_option system procedure.
For more information on the syntax of, and results returned by, this system procedure, see sa_server_option system procedure.
The following sections assume that you are already connected to your database as the DBA and that procedure profiling is enabled.
Call the sa_server_option system procedure, setting the ProcedureProfiling option to RESET.
For example, enter:
CALL sa_server_option( 'ProcedureProfiling' , 'RESET' );