Oracle 12cR2 DBMS_PRVT

Oracle DBMS_PRVT_TRACE Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.

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;