Oracle 12c DBMS_PRVT

Oracle DBMS_PRVT_TRACE Version 12.1.0.2

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. 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.

Interested in Oracle GoldenGate? Check out the IGGOUG,

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

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;