Oracle | DBMS_APP_CONT

Oracle DBMS_APP_CONT_REPORT Version 23c

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 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

CDB_ACCHK_EVENTS	DBMS_OUTPUT	PLITBLM
CDB_ACCHK_STATISTICS	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

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.