Oracle | DBMS

Oracle DBMS_LOG Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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	KSDIND	KSDWRT
KSDFLS

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 --');