DBMS_SUPPORT.START_TRACE ()

Oracle dbms_support to trace level conversion

Using this procedure is fairly simple. An example follows:

SQL> execute sys.dbms_support.start_trace (true,true);

PL/SQL procedure successfully completed
 

After tracing is completed, either exit the session, or use the stop_trace procedure as follows:

SQL> execute sys.dbms_support.stop_trace;

PL/SQL procedure successfully completed.

Be aware that the Oracle dbms_support package is not always installed by default. However, it can be installed, by running $ORACLE_HOME/rdbms/admin/dbmssupp.sql.

SQL> conn kevin/kevin

Connected.

SQL> execute sys.dbms_support.start_trace (true,true);

BEGIN sys.dbms_support.start_trace (true,true); END;

*

ERROR at line 1:

ORA-06550: line 1, column 7:

PLS-00201: identifier 'SYS.DBMS_SUPPORT' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

SQL> conn / as sysdba

Connected.

SQL> grant execute on dbms_support to kevin;

Grant succeeded.

SQL> conn kevin/kevin

Connected.

SQL> execute sys.dbms_support.start_trace (true,true);

PL/SQL procedure successfully completed.