Oracle 12cR2 DBMS_PRVT

Oracle DBMS_PRVT_TRACE Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.

Purpose Undocumented internal tracing package used to support several OEM Grid packages

AUTHID CURRENT_USER

Dependencies

DBMS_HA_ALERTS_PRVT	DBMS_SYSTEM	PLITBLM
DBMS_SERVER_ALERT_PRVT	DBMS_UTILITY

Documented No

First Available 10.1

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvthdbu.plb

Subprograms

FORCE_VERBOSE	TRACE_EXIT_PROCEDURE	TRACE_PRINT_EXCEPTION
SET_TRACE_EVENT	TRACE_EXPRESSION	TRACE_RAISE_EXCEPTION
TRACE	TRACE_LONG_EXPRESSION	UNFORCE_VERBOSE
TRACE_ENTER_PROCEDURE

FORCE_VERBOSE

Undocumented dbms_prvt_trace.force_verbose(verbose_bit IN NUMBER);

exec dbms_prvt_trace.force_verbose(0);

      exec dbms_prvt_trace.force_verbose(1);

SET_TRACE_EVENT

This does not error but I suspect this is an invalid usage none the less dbms_prvt_trace.set_trace_event( init_ora_event IN NUMBER, verbose_bit IN NUMBER);

See TRACE_ENTER_PROCEDURE Demo Below

TRACE

Undocumented dbms_prvt_trace.trace(trace_string IN VARCHAR2, trace_level IN BINARY_INTEGER);

TBD

TRACE_ENTER_PROCEDURE

Undocumented dbms_prvt_trace.trace_enter_procedure( procedure_name IN VARCHAR2, trace_level IN BINARY_INTEGER);

BEGIN

        dbms_prvt_trace.force_verbose(1);

        dbms_prvt_trace.set_trace_event(10053, 1);

        dbms_prvt_trace.trace_enter_procedure('TEST', 1);

        dbms_prvt_trace.trace_exit_procedure(1);

      END;

      /

TRACE_EXIT_PROCEDURE

Stop tracing dbms_prvt_trace.trace_exit_procedure(trace_level IN BINARY_INTEGER);

See TRACE_ENTER_PROCEDURE Demo Above

TRACE_EXPRESSION

Undocumented

Overload 1 dbms_prvt_trace.trace_expression( expression_name IN VARCHAR2, expression_value IN VARCHAR2, trace_level IN BINARY_INTEGER);

TBD

Overload 2 dbms_prvt_trace.trace_expression( expression_name IN VARCHAR2, expression_value IN BOOLEAN, trace_level IN BINARY_INTEGER);

TBD

Overload 3 dbms_prvt_trace.trace_expression( expression_name IN VARCHAR2, expression_value IN NUMBER, trace_level IN BINARY_INTEGER);

TBD

Overload 4 dbms_prvt_trace.trace_expression( expression_name IN VARCHAR2, expression_value IN DATE, format IN VARCHAR2, trace_level IN BINARY_INTEGER);

TBD

Overload 5 dbms_prvt_trace.trace_expression( expression_name IN VARCHAR2, expression_value IN dbms_utility.dblink_array, trace_level IN BINARY_INTEGER);

TBD

Overload 6 dbms_prvt_trace.trace_expression( expression_name IN VARCHAR2, expression_value IN dbms_utility.number_array, trace_level IN BINARY_INTEGER);

TBD

TRACE_LONG_EXPRESSION

Undocumented dbms_prvt_trace.trace_long_expression( expression_name IN VARCHAR2, expression_value IN VARCHAR2, trace_level IN BINARY_INTEGER);

TBD

TRACE_PRINT_EXCEPTION

Undocumented dbms_prvt_trace.trace_print_exception( location IN VARCHAR2, trace_level IN BINARY_INTEGER);

TBD

TRACE_RAISE_EXCEPTION

Undocumented dbms_prvt_trace.trace_raise_exception( location IN VARCHAR2, trace_level IN BINARY_INTEGER);

TBD

UNFORCE_VERBOSE

Undocumented dbms_prvt_trace.unforce_verbose;

exec dbms_prvt_trace.force_verbose;