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
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 ;