Resetting procedure profiling (SQL)

When you reset profiling, the database clears the old information and immediately starts collecting new information about procedures, functions, events, and triggers. You can reset procedure profiling from Interactive SQL using the sa_server_option system procedure.

Prerequisites

DBA or PROFILE authority.

Ensure that procedure profiling is enabled.

Context and remarks

Many.

 Reset procedure profiling

  • Call the sa_server_option system procedure, setting the ProcedureProfiling option to RESET.

    For example, enter:

    CALL sa_server_option( 'ProcedureProfiling' , 'RESET' );

Results

Procedure profiling is reset.

Next

None.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1