You can disable procedure profiling and clear existing data from Interactive SQL using the sa_server_option system procedure.
You must have the DIAGNOSTICS system role, and the MANAGE PROFILING system privilege.
Context and remarks
Once you are finished with the profiling information, you can either disable profiling or you can clear profiling. If you disable profiling, the database stops collecting profiling information and the information that it has collected to that point remains on the Profile tab in Sybase Central. If you clear profiling, the database turns profiling off and clears all the profiling data from the Profile tab in Sybase Central.
Call the sa_server_option system procedure and set the ProcedureProfiling option to either OFF or CLEAR.
For example, execute the following CALL statement to turn profiling off:
CALL sa_server_option( 'ProcedureProfiling' , 'OFF' );
Or execute the following CALL statement to clear profiling:
CALL sa_server_option( 'ProcedureProfiling' , 'CLEAR' );
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|