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 No
First Available 10.1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthdbu.plb
Subprograms
 
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;

Related Topics
Autotrace
DBMS_MONITOR
DBMS_SUPPORT
DBMS_SYSTEM
DBMS_TRACE
DBMS_UTILITY
Packages
TKPROF

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved