| General Information |
| Note: None of the demos below generate an exception, however, no actual work seems to take place.
If anyone can help sort this out please send me an email. Thank you. |
| Source |
{ORACLE_HOME}/rdbms/admin/prvtsum.plb |
| First Available |
8i |
| Dependencies |
| DBMS_SESSION |
DBMS_UTILITY |
| DBMS_SUMMARY |
UTL_FILE |
|
| Security Model |
Owned by SYS with no granted privileges |
| |
| SET_LOGFILE_NAME |
| Presumably sets a trace or log file name |
dbms_sumref_util.set_logfile_name(filename IN VARCHAR2); |
| exec dbms_sumref_util.set_logfile_name('testplan_1'); |
| |
| TRACE |
| Presumably writes a message to the current trace file |
dbms_sumref_util.trace(msg IN VARCHAR2); |
| exec dbms_sumref_util.trace('testplan_message'); |
| |
| TRACE_FINISH |
| Presumably flushes the buffer of any unwritten messages |
dbms_sumref_util.trace_finish; |
| exec dbms_sumref_util.trace_finish; |
| |
| TRACE_INIT |
| Presumably initializes a trace |
dbms_sumref_util.trace_init(filenum IN NUMBER); |
| exec dbms_sumref_util.trace_init(1); |
| |
| TRACE_OFF |
| Presumably stops tracing |
dbms_sumref_util.trace_off(password IN VARCHAR2); |
| exec dbms_sumref_util.trace_off('whatever'); |
| |
| TRACE_ON |
| Presumably starts tracing |
dbms_sumref_util.trace_on(password IN VARCHAR2); |
| exec dbms_sumref_util.trace_on('whatever'); |