Enabling procedure profiling (SQL)

You can enable procedure profiling in Interactive SQL using the sa_server_option system procedure.

Prerequisites

DBA or PROFILE authority.

Context and remarks

Many.

 Enable procedure profiling

  1. Connect to the database.

  2. Call the sa_server_option system procedure, setting the ProcedureProfiling option to ON.

    For example, enter:

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

Results

Procedure profiling is enabled.

Next

None.

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