Oracle | DBMS_PRVT

Oracle DBMS_PRVT_TRACE Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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

AUTHID DEFINER

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;