Oracle DBMS_LOG 

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Undocumented but appears to be an attempt to move the four named PL/SQL objects out of DBMS_SYSTEM.
Documented No
First Available 12.1.0
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtlog.plb
Prints the date stamp to the target file (alert log and/or trace file) dbms_log.ksdddt;
exec dbms_log.ksdddt;
Flushes any pending output to the target alert log or trace file dbms_log.ksdfls;
exec dbms_log.ksdfls;
Indents before the next write (ksdwrt) by printing that many colons (:) before the next write dbms_log.ksdind(lvl IN BINARY_INTEGER);

Range of valid values from 0 to 30.
exec dbms_log.ksdind(5);
exec dbms_log.ksdwrt(3, 'Test Message');
Prints a message to the target file (alert log and/or trace file) dbms_log.ksdwrt (dest IN BINARY_INTEGER, tst IN VARCHAR2);

1: Write to the standard trace file
2: Write to the alert log
3: Write to both files at once
exec dbms_system.ksdwrt(3, '-- Start Message --');
exec dbms_system.ksdwrt(3, 'Test Message');
exec dbms_system.ksdwrt(dbms_system.alert_file, '-- End Message --');

Related Topics
What's New In 12cR1
What's New In 12cR2

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