Oracle DBMS_LOG 
Version 21c

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 but appears to be an attempt to move the four named PL/SQL objects out of DBMS_SYSTEM.
AUTHID DEFINER
Dependencies
DBMS_DBFS_CONTENT DBMS_SYSTEM  
Documented No
First Available 12.1
Security Model Owned by SYS with EXECUTE granted to the DBFS_ROLE role.
Source {ORACLE_HOME}/rdbms/admin/prvtlog.plb
Subprograms
 
KSDDDT
Prints the date stamp to the target file (alert log and/or trace file) dbms_log.ksdddt;
exec dbms_log.ksdddt;
 
KSDFLS
Flushes any pending output to the target alert log or trace file dbms_log.ksdfls;
exec dbms_log.ksdfls;
 
KSDIND
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');
 
KSDWRT
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
Built-in Functions
Built-in Packages
Database Security
DBMS_SYSTEM
What's New In 19c
What's New In 20c-21c

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