Oracle | DBMS_PRVT

Oracle DBMS_PRVT_TRACE Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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;