Oracle DBMS_PRVT_TRACE
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved