| General Information |
| Library Note |
Morgan's Library Page Header
|
| 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);
PL/SQL procedure successfully completed.
exec dbms_prvt_trace.force_verbose(1);
PL/SQL procedure successfully completed. |
| |
| 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;
/
PL/SQL procedure successfully completed. |
| |
| 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;
PL/SQL procedure successfully completed. |