Oracle | DBMS_APP_CONT

Oracle DBMS_APP_CONT_REPORT 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 Utilities for developer and DBA Application Continuity reports

AUTHID DEFINER

Constants

Name	Data Type	Value
Report Types
SUMMARY	NUMBER	1
WARNING	NUMBER	2
FULL	NUMBER	3

Dependencies

DBMS_OUTPUT

DBMS_STANDARD

Documented Yes: Packages and Types Reference

First Available 20c

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(DEFAULT, READ_ONLY);

Security Model Owned by SYS with EXECUTE granted to the DBA and ACCHK_READ roles.

Source {ORACLE_HOME}/rdbms/admin/dbmsappcont.sql

ACCHK_REPORT (new 21c)

Provides a report of ACCHK trace collected while ACCHK_SET(TRUE) dbms_app_cont_report.acchk_report( level IN NUMBER DEFAULT SUMMARY, service_name IN VARCHAR2 DEFAULT NULL);

exec dbms_app_cont_report.acchk_report(dbms_app_cont_report.full);

      

      --------------------------------------

      ------------ ACCHK Report ------------

      --------------------------------------

      Nothing to report.

      

      PL/SQL procedure successfully completed.