DBMS_APP_CONT_REPORT

This procedure generates a report of ACCHK trace collected while ACCHK_SET(TRUE).

DBMS_APP_CONT_REPORT Security Model

Applications must have the EXECUTE privilege on the DBMS_APP_CONT_REPORT package.

Summary of DBMS_APP_CONT_REPORT Subprograms

This topic lists the DBMS_APP_CONT_REPORT subprograms in alphabetical order and briefly describes them.

Table 1 DBMS_APP_CONT_REPORT Package

Subprogram Description
ACCHK_REPORT Procedure This procedure provides a report of your run. The data is derived from the `acchk` views.

ACCHK_REPORT Procedure

This procedure generates a report of your run. The data is derived from the acchk views.

Syntax

DBMS_APP_CONT_REPORT.ACCHK_REPORT (
   level                    IN VARCHAR2,
   service_name             IN VARCHAR2);

Parameters

Table 2 ACCHK_REPORT Procedure Parameters

Parameter Description
level

These are constants.

  • SUMMARY-summary report only (default)
  • WARNING-summary and warnings
  • FULL-summary and all workload capture, including where there are no warnings

service_name

The service name qualifier (Optional).

The value NULL applies to all service_names.

Procedure Exceptions

The exceptions of DBMS_APP_CONT_REPORT.ACCHK_REPORT procedure are as follows:

Example

SET SERVEROUTPUT ON FORMAT WRAPPED

SET LINESIZE 180
DBMS_APP_CONT_REPORT.ACCHK_REPORT(DBMS_APP_CONT_REPORT.FULL);

SET SERVEROUTPUT ON FORMAT WRAPPED

SET LINESIZE 180
DBMS_APP_CONT_REPORT.ACCHK_REPORT(DBMS_APP_CONT_REPORT.WARNING);

SET SERVEROUTPUT ON FORMAT WRAPPED

SET LINESIZE 180
DBMS_APP_CONT_REPORT.ACCHK_REPORT(DBMS_APP_CONT_REPORT.SUMMARY);