Once procedure profiling is enabled, the database server gathers profiling information until you disable profiling or until the database server is shut down.
Connect to your database as the DBA.
Choose Mode > Application Profiling.
If the Application Profiling wizard appears, follow the wizard instructions.
If the wizard does not appear, choose Application Profiling > Open Application Profiling wizard, and then follow the wizard instructions.
On the Profiling Options page of the Application Profiling wizard, select Stored Procedure, Function, Trigger or Event Execution Time. Do not select any of the other options.
The database server begins procedure profiling. If you attempt to switch to another mode, the database server asks whether you want to continue procedure profiling. Select No to continue working in other modes while profiling continues.