Oracle DBMS_PRVT_TRACE
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
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
Built-in Functions
Built-in Packages
DBMS_MONITOR
DBMS_SUPPORT
DBMS_SYSTEM
DBMS_TRACE
DBMS_UTILITY
TKPROF
What's New In 18cR3
What's New In 19cR2

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