Oracle DBMS_SUMREF_UTIL
Version 11.2.0.2
 
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');
 
 
Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: © 2012 Daniel A. Morgan All Rights Reserved