Oracle | DBMS

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