16 Using Procedural Replication

Learn what procedural replication is and how you can configure it.

For procedural replication concepts, see About Procedural Replication.

Topics:

16.1 About Procedural Replication

Oracle GoldenGate procedural replication allows you to replicate Oracle Database supplied PL/SQL procedures avoiding the shipping and applying or high volume records usually generated by these operations. Procedural replication implements dictionary changes that control user and session behavior and the swapping of objects in dictionary.

Procedural replication is not related to the replication of the CREATE, ALTER, and DROP statements (or DDL), rather it is the replication of the procedure call like:

CALL procedure_name(arg1, arg2, ...);

As opposed to:

exec procedure_name(arg1, arg2, ...)

After you enable procedural replication, calls to procedures in Oracle Database supplied packages at one database are replicated to one or more other databases and then executed at those databases. For example, a call to subprograms in the DBMS_REDEFINITION package can perform an online redefinition of a table. If the table is replicated at several databases, and if you want the same online redefinition to be performed on the table at each database, then you can make the calls to the subprograms in the DBMS_REDEFINITION package at one database, and Oracle GoldenGate can replicate those calls to the other databases.

To support procedural replication, your Oracle Database should be configured to identify procedures that are enabled for this optimization.

To use procedural replication, the following prerequisites must be met:

  • Oracle GoldenGate 12.3 with integrated Extract and Replicat.

  • System supplied packages are only working in combination with DML and DDL.

16.2 Procedural Replication Process Overview

Procedural replication uses a trail record to ensure that sufficient information is encapsulated with the record.

To use Oracle GoldenGate procedural replication, you need to enable it. Your Oracle Database must have a built in mechanism to identify the procedures that are enabled for this optimization.

PL/SQL pragmas are used to indicate which procedures can be replicated. When the pragma is specified, a callback is made to Logminer on entry and exit from the routine. The callback provides the name of the procedure call and arguments and indicates if the procedure exited successfully or with an error. Logminer augments the redo stream with the information from the callbacks. For supported procedures, the normal redo generated by the procedure is suppressed, and only the procedure call is replicated.

A new trail record is generated to identify procedural replication. This trail record leverages existing trail column data format for arguments passed to PL/SQL procedures. For LOBs, data is passed in chunks similar to existing trail format for LOBs. This trail record has sufficient information to replay the procedure as-is on the target.

When you enable procedural replication, it prevents writing of individual records impacted by the procedure to the trail file.

If an error is encountered when applying a PL/SQL procedure, the Replicat can replay the entire PL/SQL procedure.

16.3 Enabling Procedural Replication

Procedural replication is disabled by default. You can enable it by setting the TRANLOGOPTIONS option, ENABLE_PROCEDURAL_REPLICATION, to yes.

Once you enable the procedural option for one Extract, it remains on and can not be disabled.
If you want to use Oracle GoldenGate in an Oracle Database Vault environment with procedural replication, then you must set the appropriate privileges. See Oracle Database Vault Administrator’s Guide.
To enable procedural replication:
  1. Ensure that you are in triggerless mode, see Prerequisites for Configuring DDL.
  2. Connect to the source database as an Oracle GoldenGate administrator with dblogin.
  3. Set the TRANLOGOPTIONS parameter option to yes.

    TRANLOGOPTIONS INTEGRATEDPARAMS (ENABLE_PROCEDURAL_REPLICATION Y)

Procedural replication is enabled for Extract.

16.4 Determining Whether Procedural Replication Is On

Use the GG_PROCEDURE_REPLICATION_ON function in the DBMS_GOLDENGATE_ADM package to determine whether Oracle GoldenGate procedural replication is on or off.

If you want to use Oracle GoldenGate in an Oracle Database Vault environment with procedural replication, then you must set the appropriate privileges. See Oracle Database Vault Administrator’s Guide.
To enable procedural replication:
  1. Connect to the database as sys (sqlplus, sqlcl, sqldeveloper) not as an Oracle GoldenGate administrator.
  2. Run the GG_PROCEDURE_REPLICATION_ON function.

Example 16-1 Running the GG_PROCEDURE_REPLICATION_ON Function

SET SERVEROUTPUT ON
DECLARE
  on_or_off   NUMBER;
BEGIN
  on_or_off := DBMS_GOLDENGATE_ADM.GG_PROCEDURE_REPLICATION_ON;
  IF on_or_off=1 THEN
    DBMS_OUTPUT.PUT_LINE('Oracle GoldenGate procedural replication is ON.');
  ELSE
    DBMS_OUTPUT.PUT_LINE('Oracle GoldenGate procedural replication is OFF.');
  END IF;
END;
/

16.5 Enabling and Disabling Supplemental Logging

Oracle GoldenGate provides GGSCI commands to allow you to enable or disable procedural supplemental logging.

To enable supplemental logging:

  1. Connect to the source database as the Oracle GoldenGate administrator with dblogin.

    CONNECT https://localhost:9000 DEPLOYMENT demo AS admin PASSWORD adminpw

    DBLOGIN USERIDALIAS admin_dba DOMAIN OracleGoldenGate

  2. Add supplemental logging for procedural replication.

    ADD PROCEDURETRANDATA

    INFO OGG-13005 PROCEDURETRANDATA supplemental logging has been enabled.

Supplemental logging is enabled for procedure replication.

To disable supplemental logging:

  1. Connect to the source database as the Oracle GoldenGate administrator with dblogin.

    CONNECT https://localhost:9000 DEPLOYMENT demo AS admin PASSWORD adminpw

    DBLOGIN USERIDALIAS admin_dba DOMAIN OracleGoldenGate

  2. Remove supplemental logging for procedure replication.

    DELETE PROCEDURETRANDATA

Supplemental logging is disabled for procedure replication.

To view information about supplemental logging:

  1. Connect to the source database as the Oracle GoldenGate administrator with dblogin.

    CONNECT https://localhost:9000 DEPLOYMENT demo AS admin PASSWORD adminpw

    DBLOGIN USERIDALIAS admin_dba DOMAIN OracleGoldenGate

  2. Display supplemental logging information for procedure replication.

    INFO PROCEDURETRANDATA

Supplemental logging information for procedure replication is displayed.

16.6 Filtering Features for Procedural Replication

You can specify which procedures and packages you want to include or exclude for procedure replication.

You group supported packages and procedures using feature groups. You use the procedure parameter with the INCLUDE or EXCLUDE keyword to filter features for procedure replication.

In the procedure parameter, INCLUDE or EXCLUDE specify the beginning of a filtering clause. They specify the procedures to replicate (INCLUDE) or filter out (EXCLUDE). The filtering clause must consist of the INCLUDE ALL_SUPPORTED or EXCLUDE ALL_SUPPORTED keyword followed by any valid combination of the other filtering options of the procedure parameter. The EXCLUDE filter takes precedence over any INCLUDE filters that contain the same criteria.

Note:

When replicating Oracle Streams Advanced Queuing (AQ) procedures, you must use the RULE option in your parameter file as follows:

PROCEDURE INCLUDE FEATURE ALL_SUPPORTED

or

PROCEDURE INCLUDE FEATURE AQ, RULE

Do not use PROCEDURE INCLUDE FEATURE AQ without the RULE option. See Advanced Queue Concepts.

Including all system supplied packages at Extract:

  1. Connect to Extract in the source database.

    EXTRACT edba

    USERIDALIAS admin_dbA DOMAIN ORADEV

  2. Create a new trail file.

    EXTTRAIL ea

  3. Enable procedure replication, if not already done.

    TRANLOGOPTIONS INTEGRATEDPARAMS (ENABLE_PROCEDURAL_REPLICATION Y)

  4. Include filter for procedure replication.

    PROCEDURE INCLUDE FEATURE ALL_SUPPORTED

You have successfully included all system supplied packages for procedure replication.

Excluding specific packages at Replicat:

  1. Connect to Replicat in the target database.

    REPLICAT rdba

    USERIDALIAS admin_dbBDOMAIN ORADEV

  2. Include filter for procedure replication.

    PROCEDURE EXCLUDE FEATURE RLS

You have successfully excluded specific packages for procedure replication.

16.7 Handling Procedural Replication Errors

Procedural replication uses REPERROR parameter to configure the behavior of Replicat when an procedural error occurs.

By default, Replicat will abend when a procedural replication occurs so using the following steps sets up error handling:

  1. Connect to Replicat in the target database.

    REPLICAT rdba

    USERIDALIAS admin_dbBDOMAIN ORADEV

  2. Include filter for procedure replication.

    PROCEDURE EXCLUDE FEATURE RLS

  3. Specify error handling parameter, see REPERROR in Reference for Oracle GoldenGate for other options.

    REPERROR (PROCEDURE, DISCARD)

You have successfully handled errors for procedural replication.

16.8 Procedural Replication Pragma Options

There are four pragma options for procedures: AUTO, MANUAL, UNSUPPORTED, and NONE.

PL/SQL enter and exit markers are logged for procedures with pragmas AUTO, MANUAL, and UNSUPPORTED. The redo logs generated between the enter and exit markers are grouped and discarded.

Following is a list of the packages and procedures that are pragma constructs for replication. Any package or procedure not in this list is not considered a pragma construct for PL/SQL replication and is equivalent to pragma NONE.

PL/SQL Procedures with Pragma are UNSUPPORTED

Procedures and packages with the pragma UNSUPPORTED stop apply at the point of procedure invocation so that manual intervention can be taken. The following procedures are pragma and UNSUPPORTED.

Schema Package Procedure Pragma
SYS DBMS_REDEFINITION ABORT_UPDATE PRAGMA UNSUPPORTED
SYS DBMS_REDEFINITION EXECUTE_UPDATE PRAGMA UNSUPPORTED
XDB DBMS_XDBZ ADD_APPLICATION_PRINCIPAL PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDBZ CHANGE_APPLICATION_MEMBERSHIP PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDBZ DELETE_APPLICATION_PRINCIPAL PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDBZ SET_APPLICATION_PRINCIPAL PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_ADMIN CREATENONCEKEY PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_ADMIN INSTALLDEFAULTWALLET PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_ADMIN MOVEXDB_TABLESPACE PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_ADMIN REBUILDHIERARCHICALINDEX PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_CONFIG ADDAUTHENTICATIONMAPPING PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_CONFIG ADDAUTHENTICATIONMETHOD PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_CONFIG ADDTRUSTMAPPING PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_CONFIG ADDTRUSTSCHEME PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_CONFIG CLEARHTTPDIGESTS PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_CONFIG DELETEAUTHENTICATIONMAPPING PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_CONFIG DELETEAUTHENTICATIONMETHOD PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_CONFIG DELETETRUSTMAPPING PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_CONFIG DELETETRUSTSCHEME PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_CONFIG ENABLECUSTOMAUTHENTICATION PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_CONFIG ENABLECUSTOMTRUST PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_CONFIG ENABLEDIGESTAUTHENTICATION PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_CONFIG ISGLOBALPORTENABLED PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_CONFIG SETDYNAMICGROUPSTORE PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_CONFIG SETGLOBALPORTENABLED PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XDB_CONFIG SETHTTPCONFIGREALM PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XMLINDEX DROPPARAMETER PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XMLINDEX MODIFYPARAMETER PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XMLINDEX REGISTERPARAMETER PRAGMA UNSUPPORTED with COMMIT
XDB DBMS_XMLSCHEMA COPYEVOLVE PRAGMA UNSUPPORTED with COMMIT

PL/SQL Procedures with Pragma AUTO

For the procedures and packages with the pragma AUTO, the top-level PL/SQL API is called during apply.

Schema Package Procedure Pragma
DVSYS DBMS_MACADM ADD_AUTH_TO_REALM PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM ADD_CMD_RULE_TO_POLICY PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM ADD_FACTOR_LINK PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM ADD_INDEX_FUNCTION PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM ADD_NLS_DATA PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM ADD_OBJECT_TO_REALM PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM ADD_OWNER_TO_POLICY PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM ADD_POLICY_FACTOR PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM ADD_REALM_TO_POLICY PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM ADD_RULE_TO_RULE_SET PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM AUTHORIZE_DATAPUMP_USER PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM AUTHORIZE_DDL PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM AUTHORIZE_DIAGNOSTIC_ADMIN PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM AUTHORIZE_MAINTENANCE_USER PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM AUTHORIZE_PREPROCESSOR PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM AUTHORIZE_PROXY_USER PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM AUTHORIZE_SCHEDULER_USER PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM AUTHORIZE_TTS_USER PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CHANGE_IDENTITY_FACTOR PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CHANGE_IDENTITY_VALUE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CREATE_COMMAND_RULE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CREATE_CONNECT_COMMAND_RULE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CREATE_DOMAIN_IDENTITY PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CREATE_FACTOR PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CREATE_FACTOR_TYPE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CREATE_IDENTITY PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CREATE_IDENTITY_MAP PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CREATE_MAC_POLICY PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CREATE_POLICY PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CREATE_POLICY_LABEL PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CREATE_REALM PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CREATE_ROLE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CREATE_RULE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CREATE_RULE_SET PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CREATE_SESSION_EVENT_CMD_RULE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CREATE_SESSION_EVENT_CMD_RULE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_AUTH_FROM_REALM PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_CMD_RULE_FROM_POLICY PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_COMMAND_RULE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_CONNECT_COMMAND_RULE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_FACTOR PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_FACTOR_LINK PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_FACTOR_TYPE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_IDENTITY PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_IDENTITY_MAP PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_INDEX_FUNCTION PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_MAC_POLICY_CASCADE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_OBJECT_FROM_REALM PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_OWNER_FROM_POLICY PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_POLICY_FACTOR PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_POLICY_LABEL PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_REALM PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_REALM_CASCADE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_REALM_FROM_POLICY PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_ROLE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_RULE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_RULE_FROM_RULE_SET PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_RULE_SET PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_SESSION_EVENT_CMD_RULE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DELETE_SYSTEM_EVENT_CMD_RULE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DISABLE_DV PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DISABLE_DV_DICTIONARY_ACCTS PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DISABLE_DV_PATCH_ADMIN_AUDIT PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DISABLE_ORADEBUG PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DROP_DOMAIN_IDENTITY PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DROP_POLICY PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM ENABLE_DV PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM ENABLE_DV_DICTIONARY_ACCTS PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM ENABLE_DV_PATCH_ADMIN_AUDIT PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM ENABLE_ORADEBUG PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM RENAME_FACTOR PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM RENAME_FACTOR_TYPE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM RENAME_POLICY PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM RENAME_REALM PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM RENAME_ROLE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM RENAME_RULE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM RENAME_RULE_SET PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UNAUTHORIZE_DATAPUMP_USER PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UNAUTHORIZE_DDL PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UNAUTHORIZE_DIAGNOSTIC_ADMIN PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UNAUTHORIZE_MAINTENANCE_USER PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UNAUTHORIZE_PREPROCESSOR PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UNAUTHORIZE_PROXY_USER PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UNAUTHORIZE_SCHEDULER_USER PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UNAUTHORIZE_TTS_USER PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UPDATE_COMMAND_RULE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UPDATE_CONNECT_COMMAND_RULE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UPDATE_FACTOR PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UPDATE_FACTOR_TYPE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UPDATE_IDENTITY PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UPDATE_MAC_POLICY PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UPDATE_POLICY_DESCRIPTION PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UPDATE_POLICY_STATE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UPDATE_REALM PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UPDATE_REALM_AUTH PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UPDATE_ROLE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UPDATE_RULE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UPDATE_RULE_SET PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UPDATE_SESSION_EVENT_CMD_RULE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM UPDATE_SYSTEM_EVENT_CMD_RULE PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM CREATE_ADMIN_AUDIT PRAGMA AUTO
DVSYS DBMS_MACADM CREATE_MACOLS_CONTEXTS PRAGMA AUTO with COMMIT
DVSYS DBMS_MACADM DROP_MACOLS_CONTEXTS PRAGMA AUTO with COMMIT
LBACSYS LBAC_EVENTS AFTER_CREATE PRAGMA AUTO with COMMIT
LBACSYS LBAC_EVENTS AFTER_DROP PRAGMA AUTO with COMMIT
LBACSYS LBAC_EVENTS BEFORE_ALTER PRAGMA AUTO with COMMIT
LBACSYS LBAC_LGSTNDBY_UTIL ADD_COMPARTMENTS PRAGMA AUTO
LBACSYS LBAC_LGSTNDBY_UTIL ADD_GROUPS PRAGMA AUTO
LBACSYS LBAC_LGSTNDBY_UTIL ALTER_COMPARTMENTS PRAGMA AUTO
LBACSYS LBAC_LGSTNDBY_UTIL ALTER_GROUPS PRAGMA AUTO
LBACSYS LBAC_LGSTNDBY_UTIL CONFIGURE_OLS PRAGMA AUTO with COMMIT
LBACSYS LBAC_LGSTNDBY_UTIL CREATE_POLICY PRAGMA AUTO with COMMIT
LBACSYS LBAC_LGSTNDBY_UTIL DISABLE_OLS PRAGMA AUTO with COMMIT
LBACSYS LBAC_LGSTNDBY_UTIL DROP_ALL_COMPARTMENTS PRAGMA AUTO
LBACSYS LBAC_LGSTNDBY_UTIL DROP_ALL_GROUPS PRAGMA AUTO
LBACSYS LBAC_LGSTNDBY_UTIL DROP_COMPARTMENTS PRAGMA AUTO
LBACSYS LBAC_LGSTNDBY_UTIL DROP_GROUPS PRAGMA AUTO
LBACSYS LBAC_LGSTNDBY_UTIL ENABLE_OLS PRAGMA AUTO with COMMIT
LBACSYS LBAC_LGSTNDBY_UTIL INSERT_LABEL PRAGMA AUTO
LBACSYS LBAC_LGSTNDBY_UTIL SAVE_DEFAULT_LABELS PRAGMA AUTO with COMMIT
LBACSYS LBAC_LGSTNDBY_UTIL SET_COMPARTMENTS PRAGMA AUTO
LBACSYS LBAC_LGSTNDBY_UTIL SET_DEFAULT_LABEL PRAGMA AUTO
LBACSYS LBAC_LGSTNDBY_UTIL SET_GROUPS PRAGMA AUTO
LBACSYS LBAC_LGSTNDBY_UTIL SET_LEVELS PRAGMA AUTO
LBACSYS LBAC_LGSTNDBY_UTIL SET_ROW_LABEL PRAGMA AUTO
LBACSYS LBAC_LGSTNDBY_UTIL SET_USER_LABELS PRAGMA AUTO with COMMIT
LBACSYS LBAC_LGSTNDBY_UTIL STORE_LABEL_LIST PRAGMA AUTO
LBACSYS LBAC_POLICY_ADMIN ALTER_SCHEMA_POLICY PRAGMA AUTO with COMMIT
LBACSYS LBAC_POLICY_ADMIN APPLY_SCHEMA_POLICY PRAGMA AUTO with COMMIT
LBACSYS LBAC_POLICY_ADMIN APPLY_TABLE_POLICY PRAGMA AUTO with COMMIT
LBACSYS LBAC_POLICY_ADMIN DISABLE_SCHEMA_POLICY PRAGMA AUTO with COMMIT
LBACSYS LBAC_POLICY_ADMIN DISABLE_TABLE_POLICY PRAGMA AUTO with COMMIT
LBACSYS LBAC_POLICY_ADMIN ENABLE_SCHEMA_POLICY PRAGMA AUTO with COMMIT
LBACSYS LBAC_POLICY_ADMIN ENABLE_TABLE_POLICY PRAGMA AUTO with COMMIT
LBACSYS LBAC_POLICY_ADMIN POLICY_SUBSCRIBE PRAGMA AUTO with COMMIT
LBACSYS LBAC_POLICY_ADMIN POLICY_UNSUBSCRIBE PRAGMA AUTO with COMMIT
LBACSYS LBAC_POLICY_ADMIN REMOVE_SCHEMA_POLICY PRAGMA AUTO with COMMIT
LBACSYS LBAC_POLICY_ADMIN REMOVE_TABLE_POLICY PRAGMA AUTO with COMMIT
LBACSYS SA_AUDIT_ADMIN AUDIT PRAGMA AUTO with COMMIT
LBACSYS SA_AUDIT_ADMIN AUDIT_LABEL PRAGMA AUTO with COMMIT
LBACSYS SA_AUDIT_ADMIN AUDIT_LABEL_ENABLED PRAGMA AUTO with COMMIT
LBACSYS SA_AUDIT_ADMIN AUDIT_LABEL_ENABLED_SQL PRAGMA AUTO with COMMIT
LBACSYS SA_AUDIT_ADMIN CREATE_VIEW PRAGMA AUTO with COMMIT
LBACSYS SA_AUDIT_ADMIN DROP_VIEW PRAGMA AUTO with COMMIT
LBACSYS SA_AUDIT_ADMIN NOAUDIT PRAGMA AUTO with COMMIT
LBACSYS SA_AUDIT_ADMIN NOAUDIT_LABEL PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS ALTER_COMPARTMENT PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS ALTER_COMPARTMENT PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS ALTER_GROUP PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS ALTER_GROUP PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS ALTER_GROUP_PARENT PRAGMA AUTO
LBACSYS SA_COMPONENTS ALTER_GROUP_PARENT PRAGMA AUTO
LBACSYS SA_COMPONENTS ALTER_GROUP_PARENT PRAGMA AUTO
LBACSYS SA_COMPONENTS ALTER_LEVEL PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS ALTER_LEVEL PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS CREATE_COMPARTMENT PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS CREATE_GROUP PRAGMA AUTO
LBACSYS SA_COMPONENTS CREATE_LEVEL PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS DROP_COMPARTMENT PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS DROP_COMPARTMENT PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS DROP_GROUP PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS DROP_GROUP PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS DROP_LEVEL PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS DROP_LEVEL PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS ALTER_LABEL PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS ALTER_LABEL PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS CREATE_LABEL PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS DROP_LABEL PRAGMA AUTO with COMMIT
LBACSYS SA_COMPONENTS DROP_LABEL PRAGMA AUTO with COMMIT
LBACSYS SA_SYSDBA ALTER_POLICY PRAGMA AUTO with COMMIT
LBACSYS SA_SYSDBA DISABLE_POLICY PRAGMA AUTO with COMMIT
LBACSYS SA_SYSDBA DROP_POLICY PRAGMA AUTO with COMMIT
LBACSYS SA_SYSDBA ENABLE_POLICY PRAGMA AUTO with COMMIT
LBACSYS SA_USER_ADMIN DROP_USER_ACCESS PRAGMA AUTO with COMMIT
LBACSYS SA_USER_ADMIN SET_PROG_PRIVS PRAGMA AUTO with COMMIT
LBACSYS SA_USER_ADMIN SET_USER_PRIVS PRAGMA AUTO with COMMIT
SYS DBMS_AQ AQ$_BACKGROUND_OPER PRAGMA AUTO
SYS DBMS_AQ AQ$_DELETE_DIOT_TAB PRAGMA AUTO
SYS DBMS_AQ AQ$_DELETE_HIST_TAB PRAGMA AUTO
SYS DBMS_AQ AQ$_DELETE_TIOT_TAB PRAGMA AUTO
SYS DBMS_AQ AQ$_INSERT_DIOT_TAB PRAGMA AUTO
SYS DBMS_AQ AQ$_INSERT_HIST_TAB PRAGMA AUTO
SYS DBMS_AQ AQ$_INSERT_TIOT_TAB PRAGMA AUTO
SYS DBMS_AQ AQ$_UPDATE_HIST_TAB PRAGMA AUTO
SYS DBMS_AQ AQ$_UPDATE_HIST_TAB_EX PRAGMA AUTO
SYS DBMS_AQ DEQUEUE_INTERNAL PRAGMA AUTO
SYS DBMS_AQ ENQUEUE_INT_SHARD PRAGMA AUTO
SYS DBMS_AQ ENQUEUE_INT_SHARD PRAGMA AUTO
SYS DBMS_AQ ENQUEUE_INT_SHARD PRAGMA AUTO
SYS DBMS_AQ ENQUEUE_INT_SHARD_JMS PRAGMA AUTO
SYS DBMS_AQ ENQUEUE_INT_UNSHARDED PRAGMA AUTO
SYS DBMS_AQ ENQUEUE_INT_UNSHARDED PRAGMA AUTO
SYS DBMS_AQ ENQUEUE_INT_UNSHARDED PRAGMA AUTO
SYS DBMS_AQ ENQUEUE_INT_UNSHARDED PRAGMA AUTO
SYS DBMS_AQ REGISTRATION_REPLICATION PRAGMA AUTO
SYS DBMS_AQADM ALTER_AQ_AGENT PRAGMA AUTO
SYS DBMS_AQADM CREATE_AQ_AGENT PRAGMA AUTO
SYS DBMS_AQADM DISABLE_DB_ACCESS PRAGMA AUTO
SYS DBMS_AQADM DROP_AQ_AGENT PRAGMA AUTO
SYS DBMS_AQADM ENABLE_DB_ACCESS PRAGMA AUTO
SYS DBMS_AQADM GRANT_SYSTEM_PRIVILEGE PRAGMA AUTO
SYS DBMS_AQADM GRANT_TYPE_ACCESS PRAGMA AUTO
SYS DBMS_AQADM REVOKE_SYSTEM_PRIVILEGE PRAGMA AUTO
SYS DBMS_AQADM_SYS ALTER_QUEUE PRAGMA AUTO
SYS DBMS_AQADM_SYS ALTER_QUEUE_TABLE PRAGMA AUTO
SYS DBMS_AQADM_SYS ALTER_SHARDED_QUEUE PRAGMA AUTO
SYS DBMS_AQADM_SYS ALTER_SUBSCRIBER_11G PRAGMA AUTO
SYS DBMS_AQADM_SYS CREATE_EVICTION_TABLE PRAGMA AUTO
SYS DBMS_AQADM_SYS CREATE_EXCEPTION_QUEUE PRAGMA AUTO
SYS DBMS_AQADM_SYS CREATE_NP_QUEUE_INT PRAGMA AUTO
SYS DBMS_AQADM_SYS CREATE_QUEUE PRAGMA AUTO
SYS DBMS_AQADM_SYS CREATE_QUEUE_TABLE PRAGMA AUTO
SYS DBMS_AQADM_SYS CREATE_SHARDED_QUEUE PRAGMA AUTO
SYS DBMS_AQADM_SYS DROP_EVICTION_TABLE PRAGMA AUTO
SYS DBMS_AQADM_SYS DROP_QUEUE PRAGMA AUTO
SYS DBMS_AQADM_SYS DROP_QUEUE_TABLE PRAGMA AUTO
SYS DBMS_AQADM_SYS DROP_SHARDED_QUEUE_INT PRAGMA AUTO
SYS DBMS_AQADM_SYS ENABLE_JMS_TYPES_INT PRAGMA AUTO
SYS DBMS_AQADM_SYS GRANT_QUEUE_PRIVILEGE PRAGMA AUTO
SYS DBMS_AQADM_SYS MIGRATE_QUEUE_TABLE PRAGMA AUTO
SYS DBMS_AQADM_SYS PATCH_QUEUE_TABLE PRAGMA AUTO
SYS DBMS_AQADM_SYS PATCH_QUEUE_TABLE PRAGMA AUTO
SYS DBMS_AQADM_SYS PSTUPD_CREATE_EVICTION_TABLE PRAGMA AUTO
SYS DBMS_AQADM_SYS PURGE_QUEUE_TABLE_INT PRAGMA AUTO
SYS DBMS_AQADM_SYS REMOVE_ORPHMSGS_INT PRAGMA AUTO
SYS DBMS_AQADM_SYS REMOVE_SUBSCRIBER_11G_INT PRAGMA AUTO
SYS DBMS_AQADM_SYS REVOKE_QUEUE_PRIVILEGE PRAGMA AUTO
SYS DBMS_AQADM_SYS START_QUEUE PRAGMA AUTO
SYS DBMS_AQADM_SYS STOP_QUEUE PRAGMA AUTO
SYS DBMS_AQELM SET_MAILHOST PRAGMA AUTO
SYS DBMS_AQELM SET_MAILPORT PRAGMA AUTO
SYS DBMS_AQELM SET_PROXY PRAGMA AUTO
SYS DBMS_AQELM SET_SENDFROM PRAGMA AUTO
SYS DBMS_AQ_SYS_IMP_INTERNAL BUMP_TID_SEQUENCE PRAGMA AUTO
SYS DBMS_AQ_SYS_IMP_INTERNAL CLEANUP_SCHEMA_IMPORT PRAGMA AUTO
SYS DBMS_AQ_SYS_IMP_INTERNAL IMPORT_CMT_TIME_TABLE PRAGMA AUTO with COMMIT
SYS DBMS_AQ_SYS_IMP_INTERNAL IMPORT_DEQUEUELOG_TABLE PRAGMA AUTO with COMMIT
SYS DBMS_AQ_SYS_IMP_INTERNAL IMPORT_EXP_ENTRY PRAGMA AUTO
SYS DBMS_AQ_SYS_IMP_INTERNAL IMPORT_HISTORY_TABLE PRAGMA AUTO with COMMIT
SYS DBMS_AQ_SYS_IMP_INTERNAL IMPORT_INDEX_TABLE PRAGMA AUTO with COMMIT
SYS DBMS_AQ_SYS_IMP_INTERNAL IMPORT_QTAB_EXPDEP PRAGMA AUTO
SYS DBMS_AQ_SYS_IMP_INTERNAL IMPORT_QUEUE PRAGMA AUTO with COMMIT
SYS DBMS_AQ_SYS_IMP_INTERNAL IMPORT_QUEUE_META PRAGMA AUTO
SYS DBMS_AQ_SYS_IMP_INTERNAL IMPORT_QUEUE_SEQ PRAGMA AUTO
SYS DBMS_AQ_SYS_IMP_INTERNAL IMPORT_QUEUE_TABLE PRAGMA AUTO with COMMIT
SYS DBMS_AQ_SYS_IMP_INTERNAL IMPORT_SIGNATURE_TABLE PRAGMA AUTO with COMMIT
SYS DBMS_AQ_SYS_IMP_INTERNAL IMPORT_SUBSCRIBER_TABLE PRAGMA AUTO with COMMIT
SYS DBMS_AQ_SYS_IMP_INTERNAL IMPORT_TIMEMGR_TABLE PRAGMA AUTO with COMMIT
SYS DBMS_AQ_SYS_IMP_INTERNAL POST_TTS_REBUILD_IDX PRAGMA AUTO with COMMIT
SYS DBMS_AQ_SYS_IMP_INTERNAL POST_TTS_SHARDED_Q PRAGMA AUTO
SYS DBMS_AQ_SYS_IMP_INTERNAL POST_TTS_WORK PRAGMA AUTO
SYS DBMS_AQ_SYS_IMP_INTERNAL POST_TTS_WORK_REMAINING PRAGMA AUTO
SYS DBMS_DBFS_CONTENT_ADMIN EXIM_MOUNT PRAGMA AUTO
SYS DBMS_DBFS_CONTENT_ADMIN EXIM_MOUNTP PRAGMA AUTO
SYS DBMS_DBFS_CONTENT_ADMIN EXIM_STORE PRAGMA AUTO
SYS DBMS_DBFS_CONTENT_ADMIN MOUNTSTORE_LOG PRAGMA AUTO
SYS DBMS_DBFS_CONTENT_ADMIN REGISTERSTORE_LOG PRAGMA AUTO
SYS DBMS_DBFS_CONTENT_ADMIN UNMOUNTSTORE_LOG PRAGMA AUTO
SYS DBMS_DBFS_CONTENT_ADMIN UNREGISTERSTORE_LOG PRAGMA AUTO
SYS DBMS_DBFS_SFS NORMALIZEFS PRAGMA AUTO with COMMIT
SYS DBMS_DBFS_CONTENT_ADMIN REORGANIZEFS PRAGMA AUTO with COMMIT
SYS DBMS_DBFS_CONTENT_ADMIN SHRINKFS PRAGMA AUTO with COMMIT
SYS DBMS_DBFS_SFS_ADMIN CREATEFILESYSTEM_LOG PRAGMA AUTO
SYS DBMS_DBFS_SFS_ADMIN DELETE_ORPHANS_LOG PRAGMA AUTO with COMMIT
SYS DBMS_DBFS_SFS_ADMIN DROPFILESYSTEM_LOG PRAGMA AUTO
SYS DBMS_DBFS_SFS_ADMIN EXIM_ATTRV PRAGMA AUTO with COMMIT
SYS DBMS_DBFS_SFS_ADMIN EXIM_FS PRAGMA AUTO
SYS DBMS_DBFS_SFS_ADMIN EXIM_GRANTS PRAGMA AUTO with COMMIT
SYS DBMS_DBFS_SFS_ADMIN EXIM_SEQ PRAGMA AUTO
SYS DBMS_DBFS_SFS_ADMIN EXIM_SNAP PRAGMA AUTO
SYS DBMS_DBFS_SFS_ADMIN EXIM_TABP PRAGMA AUTO
SYS DBMS_DBFS_SFS_ADMIN EXIM_TAB_LOG PRAGMA AUTO
SYS DBMS_DBFS_SFS_ADMIN EXIM_VOL PRAGMA AUTO
SYS DBMS_DBFS_SFS_ADMIN INITFILESYSTEM_LOG PRAGMA AUTO
SYS DBMS_DBFS_SFS_ADMIN PARTITION_SEQUENCE_LOG PRAGMA AUTO with COMMIT
SYS DBMS_DBFS_SFS_ADMIN RECACHE_SEQUENCE_LOG PRAGMA AUTO with COMMIT
SYS DBMS_DBFS_SFS_ADMIN REGISTERFILESYSTEM_LOG PRAGMA AUTO
SYS DBMS_DBFS_SFS_ADMIN SETFSPROPERTIES_LOG PRAGMA AUTO
SYS DBMS_DBFS_SFS_ADMIN UNREGISTERFILESYSTEM_LOG PRAGMA AUTO
SYS DBMS_DDL SET_TRIGGER_FIRING_PROPERTY PRAGMA AUTO with COMMIT
SYS DBMS_DDL SET_TRIGGER_FIRING_PROPERTY PRAGMA AUTO with COMMIT
SYS DBMS_FGA ADD_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_FGA DISABLE_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_FGA DROP_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_FGA ENABLE_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_GOLDENGATE_ADM_INT_I ADD_AUTO_CDR_COLGROUP_INT PRAGMA AUTO with COMMIT
SYS DBMS_FGA ADD_AUTO_CDR_DELTA_RES_INT PRAGMA AUTO with COMMIT
SYS DBMS_FGA ADD_AUTO_CDR_INT PRAGMA AUTO with COMMIT
SYS DBMS_FGA ALTER_AUTO_CDR_COLGROUP_INT PRAGMA AUTO with COMMIT
SYS DBMS_FGA ALTER_AUTO_CDR_INT PRAGMA AUTO with COMMIT
SYS DBMS_FGA REMOVE_AUTO_CDR_COLGROUP_INT PRAGMA AUTO with COMMIT
SYS DBMS_FGA REMOVE_AUTO_CDR_DELTA_RES_INT PRAGMA AUTO with COMMIT
SYS DBMS_FGA REMOVE_AUTO_CDR_INT PRAGMA AUTO with COMMIT
SYS DBMS_GOLDENGATE_IMP ACDR_COLUMN PRAGMA AUTO with COMMIT
SYS DBMS_GOLDENGATE_IMP ACDR_COLUMN_GROUP PRAGMA AUTO with COMMIT
SYS DBMS_GOLDENGATE_IMP ACDR_END PRAGMA AUTO with COMMIT
SYS DBMS_GOLDENGATE_IMP ACDR_START PRAGMA AUTO with COMMIT
SYS DBMS_GOLDENGATE_IMP ACDR_TABLE PRAGMA AUTO with COMMIT
SYS DBMS_INTERNAL_LOGSTDBY EDS_EVOLVE_DISABLE PRAGMA AUTO with COMMIT
SYS DBMS_INTERNAL_LOGSTDBY EDS_EVOLVE_ENABLE PRAGMA AUTO with COMMIT
SYS DBMS_INTERNAL_ROLLING DESTROY_META PRAGMA AUTO
SYS DBMS_INTERNAL_ROLLING INSERT_DGLRDDIR PRAGMA AUTO
SYS DBMS_INTERNAL_ROLLING INSERT_DGLRDEVT PRAGMA AUTO
SYS DBMS_INTERNAL_ROLLING SET_UPGRADE_FLAGS PRAGMA AUTO
SYS DBMS_INTERNAL_ROLLING UPDATE_DGLRDINS_PROGRESS PRAGMA AUTO
SYS DBMS_INTERNAL_ROLLING UPSERT_DGLRDCON PRAGMA AUTO
SYS DBMS_INTERNAL_ROLLING UPSERT_DGLRDDAT PRAGMA AUTO
SYS DBMS_INTERNAL_ROLLING UPSERT_DGLRDINS PRAGMA AUTO
SYS DBMS_INTERNAL_ROLLING UPSERT_DGLRDPAR PRAGMA AUTO
SYS DBMS_INTERNAL_ROLLING UPSERT_DGLRDSTA PRAGMA AUTO
SYS DBMS_INTERNAL_ROLLING UPSERT_DGLRDSTS PRAGMA AUTO
SYS DBMS_ISCHED CREATE_CREDENTIAL PRAGMA AUTO with COMMIT
SYS DBMS_ISCHED EXEC_JOB_RUN_LSA PRAGMA AUTO
SYS DBMS_ISCHED SET_AGENT_REGISTRATION_PASS PRAGMA AUTO with COMMIT
SYS DBMS_PRVTAQIS SUBID_REPLICATE PRAGMA AUTO with COMMIT
SYS DBMS_PRVTAQIS ADD_DURABLE_SUB PRAGMA AUTO with COMMIT
SYS DBMS_PRVTAQIS ALTER_SUBSCRIBER_12G PRAGMA AUTO
SYS DBMS_PRVTAQIS REMOVE_SUBSCRIBER_12G PRAGMA AUTO
SYS DBMS_REDACT ADD_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_REDACT ALTER_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_REDACT APPLY_POLICY_EXPR_TO_COL PRAGMA AUTO with COMMIT
SYS DBMS_REDACT CREATE_POLICY_EXPRESSION PRAGMA AUTO with COMMIT
SYS DBMS_REDACT DISABLE_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_REDACT DROP_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_REDACT DROP_POLICY_EXPRESSION PRAGMA AUTO with COMMIT
SYS DBMS_REDACT ENABLE_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_REDACT FPM_MASK PRAGMA AUTO with COMMIT
SYS DBMS_REDACT FPM_UNMASK PRAGMA AUTO with COMMIT
SYS DBMS_REDACT UPDATE_FULL_REDACTION_VALUES PRAGMA AUTO with COMMIT
SYS DBMS_REDACT UPDATE_POLICY_EXPRESSION PRAGMA AUTO with COMMIT
SYS DBMS_REDEFINITION ABORT_REDEF_TABLE PRAGMA AUTO with COMMIT
SYS DBMS_REDEFINITION ABORT_ROLLBACK PRAGMA AUTO with COMMIT
SYS DBMS_REDEFINITION COPY_TABLE_DEPENDENTS PRAGMA AUTO with COMMIT
SYS DBMS_REDEFINITION FINISH_REDEF_TABLE PRAGMA AUTO with COMMIT
SYS DBMS_REDEFINITION REGISTER_DEPENDENT_OBJECT PRAGMA AUTO with COMMIT
SYS DBMS_REDEFINITION ROLLBACK PRAGMA AUTO with COMMIT
SYS DBMS_REDEFINITION SET_PARAM PRAGMA AUTO with COMMIT
SYS DBMS_REDEFINITION START_REDEF_TABLE PRAGMA AUTO with COMMIT
SYS DBMS_REDEFINITION SYNC_INTERIM_TABLE PRAGMA AUTO with COMMIT
SYS DBMS_REDEFINITION UNREGISTER_DEPENDENT_OBJECT PRAGMA AUTO with COMMIT
SYS DBMS_RLS_INT ADD_GROUPED_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_RLS_INT ADD_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_RLS_INT ADD_POLICY_CONTEXT PRAGMA AUTO with COMMIT
SYS DBMS_RLS_INT ALTER_GROUPED_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_RLS_INT ALTER_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_RLS_INT CREATE_POLICY_GROUP PRAGMA AUTO with COMMIT
SYS DBMS_RLS_INT DELETE_POLICY_GROUP PRAGMA AUTO with COMMIT
SYS DBMS_RLS_INT DISABLE_GROUPED_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_RLS_INT DROP_GROUPED_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_RLS_INT DROP_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_RLS_INT DROP_POLICY_CONTEXT PRAGMA AUTO with COMMIT
SYS DBMS_RLS_INT ENABLE_GROUPED_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_RLS_INT ENABLE_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_RLS_INT REFRESH_GROUPED_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_RLS_INT REFRESH_POLICY PRAGMA AUTO with COMMIT
SYS DBMS_RULEADM_INTERNAL ADD_RULE PRAGMA AUTO
SYS DBMS_RULEADM_INTERNAL ALTER_EVALUATION_CONTEXT PRAGMA AUTO
SYS DBMS_RULEADM_INTERNAL ALTER_RULE PRAGMA AUTO
SYS DBMS_RULEADM_INTERNAL CREATE_EVALUATION_CONTEXT PRAGMA AUTO
SYS DBMS_RULEADM_INTERNAL CREATE_RULE PRAGMA AUTO
SYS DBMS_RULEADM_INTERNAL CREATE_RULE_SET PRAGMA AUTO
SYS DBMS_RULEADM_INTERNAL DROP_EVALUATION_CONTEXT PRAGMA AUTO
SYS DBMS_RULEADM_INTERNAL DROP_RULE PRAGMA AUTO
SYS DBMS_RULEADM_INTERNAL DROP_RULE_SET PRAGMA AUTO
SYS DBMS_RULEADM_INTERNAL REMOVE_RULE PRAGMA AUTO
SYS DBMS_RULE_ADM GRANT_OBJECT_PRIVILEGE PRAGMA AUTO
SYS DBMS_RULE_ADM GRANT_SYSTEM_PRIVILEGE PRAGMA AUTO
SYS DBMS_RULE_ADM REVOKE_OBJECT_PRIVILEGE PRAGMA AUTO
SYS DBMS_RULE_ADM REVOKE_SYSTEM_PRIVILEGE PRAGMA AUTO
SYS DBMS_SCHEDULER ADD_EVENT_QUEUE_SUBSCRIBER PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER ADD_GROUP_MEMBER PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER ADD_JOB_EMAIL_NOTIFICATION PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER ADD_TO_INCOMPATIBILITY PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER ADD_WINDOW_GROUP_MEMBER PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER ALTER_CHAIN PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER ALTER_CHAIN PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER ALTER_RUNNING_CHAIN PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER ALTER_RUNNING_CHAIN PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER ANALYZE_CHAIN PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER AUTO_PURGE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CHECK_CREDENTIAL PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER COPY_JOB PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_CHAIN PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_DATABASE_DESTINATION PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_EVENT_SCHEDULE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_FILE_WATCHER PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_GROUP PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_INCOMPATIBILITY PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_JOB PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_JOB PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_JOB PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_JOB PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_JOB PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_JOB PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_JOBS PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_JOBS PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_JOB_CLASS PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_PROGRAM PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_RESOURCE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_SCHEDULE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_WINDOW PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_WINDOW PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER CREATE_WINDOW_GROUP PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DEFINE_ANYDATA_ARGUMENT PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DEFINE_CHAIN_EVENT_STEP PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DEFINE_CHAIN_EVENT_STEP PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DEFINE_CHAIN_RULE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DEFINE_CHAIN_STEP PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DEFINE_METADATA_ARGUMENT PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DEFINE_PROGRAM_ARGUMENT PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DEFINE_PROGRAM_ARGUMENT PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DELETE_FILE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DISABLE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DISABLE1_CALENDAR_CHECK PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_AGENT_DESTINATION PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_CHAIN PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_CHAIN_RULE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_CHAIN_STEP PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_CREDENTIAL PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_DATABASE_DESTINATION PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_FILE_WATCHER PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_GROUP PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_INCOMPATIBILITY PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_JOB PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_JOB_CLASS PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_PROGRAM PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_PROGRAM_ARGUMENT PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_PROGRAM_ARGUMENT PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_RESOURCE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_SCHEDULE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_WINDOW PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER DROP_WINDOW_GROUP PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER ENABLE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER END_DETACHED_JOB_RUN PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER EVALUATE_RUNNING_CHAIN PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER GET_AGENT_INFO PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER GET_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER GET_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER GET_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER GET_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER GET_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER GET_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER GET_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER GET_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER GET_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER GET_FILE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER GET_FILE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER GET_FILE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER GET_SCHEDULER_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER PURGE_LOG PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER PUT_FILE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER PUT_FILE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER PUT_FILE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER REMOVE_EVENT_QUEUE_SUBSCRIBER PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER REMOVE_FROM_INCOMPATIBILITY PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER REMOVE_GROUP_MEMBER PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER REMOVE_JOB_EMAIL_NOTIFICATION PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER REMOVE_WINDOW_GROUP_MEMBER PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER RESET_JOB_ARGUMENT_VALUE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER RESET_JOB_ARGUMENT_VALUE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER RUN_CHAIN PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER RUN_CHAIN PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER SET_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER SET_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER SET_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER SET_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER SET_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER SET_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER SET_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER SET_ATTRIBUTE_NULL PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER SET_JOB_ANYDATA_VALUE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER SET_JOB_ANYDATA_VALUE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER SET_JOB_ARGUMENT_VALUE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER SET_JOB_ARGUMENT_VALUE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER SET_JOB_ATTRIBUTES PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER SET_RESOURCE_CONSTRAINT PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER SET_SCHEDULER_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SCHEDULER SHOW_ERRORS PRAGMA AUTO with COMMIT
SYS DBMS_SQL_TRANSLATOR CLEAR_SQL_TRANSLATION_ERROR PRAGMA AUTO with COMMIT
SYS DBMS_SQL_TRANSLATOR CREATE_PROFILE PRAGMA AUTO with COMMIT
SYS DBMS_SQL_TRANSLATOR DEREGISTER_ERROR_TRANSLATION PRAGMA AUTO with COMMIT
SYS DBMS_SQL_TRANSLATOR DEREGISTER_SQL_TRANSLATION PRAGMA AUTO with COMMIT
SYS DBMS_SQL_TRANSLATOR DROP_PROFILE PRAGMA AUTO with COMMIT
SYS DBMS_SQL_TRANSLATOR ENABLE_ERROR_TRANSLATION PRAGMA AUTO with COMMIT
SYS DBMS_SQL_TRANSLATOR ENABLE_SQL_TRANSLATION PRAGMA AUTO with COMMIT
SYS DBMS_SQL_TRANSLATOR REGISTER_ERROR_TRANSLATION PRAGMA AUTO with COMMIT
SYS DBMS_SQL_TRANSLATOR REGISTER_SQL_TRANSLATION PRAGMA AUTO with COMMIT
SYS DBMS_SQL_TRANSLATOR SET_ATTRIBUTE PRAGMA AUTO with COMMIT
SYS DBMS_SQL_TRANSLATOR SET_ERROR_TRANSLATION_COMMENT PRAGMA AUTO with COMMIT
SYS DBMS_SQL_TRANSLATOR SET_SQL_TRANSLATION_COMMENT PRAGMA AUTO with COMMIT
SYS DBMS_SQL_TRANSLATOR SET_SQL_TRANSLATION_MODULE PRAGMA AUTO with COMMIT
SYS DBMS_XDS ALTER_STATIC_ACL_REFRESH PRAGMA AUTO
SYS DBMS_XDS DISABLE_OLAP_POLICY PRAGMA AUTO
SYS DBMS_XDS DISABLE_XDS PRAGMA AUTO
SYS DBMS_XDS DROP_OLAP_POLICY PRAGMA AUTO
SYS DBMS_XDS DROP_XDS PRAGMA AUTO
SYS DBMS_XDS ENABLE_OLAP_POLICY PRAGMA AUTO
SYS DBMS_XDS ENABLE_XDS PRAGMA AUTO
SYS DBMS_XDS PURGE_ACL_REFRESH_HISTORY PRAGMA AUTO
SYS DBMS_XDS SCHEDULE_STATIC_ACL_REFRESH PRAGMA AUTO
SYS DBMS_XDS SET_TRACE_LEVEL PRAGMA AUTO
SYS DBMS_XDS XDS$REFRESH_STATIC_ACL PRAGMA AUTO
SYS LOGSTDBY_INTERNAL EDS_EVOLVE_TABLE_I PRAGMA AUTO with COMMIT
SYS LOGSTDBY_INTERNAL EDS_REMOVE_TABLE_I PRAGMA AUTO with COMMIT
SYS XS_ACL ADD_ACL_PARAMETER PRAGMA AUTO
SYS XS_ACL ADD_ACL_PARAMETER PRAGMA AUTO
SYS XS_ACL APPEND_ACES PRAGMA AUTO
SYS XS_ACL APPEND_ACES PRAGMA AUTO
SYS XS_ACL CREATE_ACL PRAGMA AUTO
SYS XS_ACL DELETE_ACL PRAGMA AUTO
SYS XS_ACL REMOVE_ACES PRAGMA AUTO
SYS XS_ACL REMOVE_ACL_PARAMETERS PRAGMA AUTO
SYS XS_ACL REMOVE_ACL_PARAMETERS PRAGMA AUTO
SYS XS_ACL REMOVE_ACL_PARAMETERS PRAGMA AUTO
SYS XS_ACL SET_DESCRIPTION PRAGMA AUTO
SYS XS_ACL SET_PARENT_ACL PRAGMA AUTO
SYS XS_ACL SET_SECURITY_CLASS PRAGMA AUTO
SYS XS_ADMIN_UTIL GRANT_SYSTEM_PRIVILEGE PRAGMA AUTO
SYS XS_ADMIN_UTIL REVOKE_SYSTEM_PRIVILEGE PRAGMA AUTO
SYS XS_DATA_SECURITY ADD_COLUMN_CONSTRAINTS PRAGMA AUTO
SYS XS_DATA_SECURITY ADD_COLUMN_CONSTRAINTS PRAGMA AUTO
SYS XS_DATA_SECURITY APPEND_REALM_CONSTRAINTS PRAGMA AUTO
SYS XS_DATA_SECURITY APPEND_REALM_CONSTRAINTS PRAGMA AUTO
SYS XS_DATA_SECURITY APPLY_OBJECT_POLICY PRAGMA AUTO
SYS XS_DATA_SECURITY CREATE_ACL_PARAMETER PRAGMA AUTO
SYS XS_DATA_SECURITY CREATE_POLICY PRAGMA AUTO
SYS XS_DATA_SECURITY DELETE_ACL_PARAMETER PRAGMA AUTO
SYS XS_DATA_SECURITY DELETE_POLICY PRAGMA AUTO
SYS XS_DATA_SECURITY DISABLE_OBJECT_POLICY PRAGMA AUTO
SYS XS_DATA_SECURITY ENABLE_OBJECT_POLICY PRAGMA AUTO
SYS XS_DATA_SECURITY REMOVE_COLUMN_CONSTRAINTS PRAGMA AUTO
SYS XS_DATA_SECURITY REMOVE_OBJECT_POLICY PRAGMA AUTO
SYS XS_DATA_SECURITY REMOVE_REALM_CONSTRAINTS PRAGMA AUTO
SYS XS_DATA_SECURITY SET_DESCRIPTION PRAGMA AUTO
SYS XS_NAMESPACE ADD_ATTRIBUTES PRAGMA AUTO
SYS XS_DATA_SECURITY ADD_ATTRIBUTES PRAGMA AUTO
SYS XS_DATA_SECURITY CREATE_TEMPLATE PRAGMA AUTO
SYS XS_DATA_SECURITY DELETE_TEMPLATE PRAGMA AUTO
SYS XS_DATA_SECURITY REMOVE_ATTRIBUTES PRAGMA AUTO
SYS XS_DATA_SECURITY REMOVE_ATTRIBUTES PRAGMA AUTO
SYS XS_DATA_SECURITY REMOVE_ATTRIBUTES PRAGMA AUTO
SYS XS_DATA_SECURITY SET_DESCRIPTION PRAGMA AUTO
SYS XS_DATA_SECURITY SET_HANDLER PRAGMA AUTO
SYS XS_PRINCIPAL ADD_PROXY_TO_DBUSER PRAGMA AUTO
SYS XS_PRINCIPAL ADD_PROXY_USER PRAGMA AUTO
SYS XS_PRINCIPAL ADD_PROXY_USER PRAGMA AUTO
SYS XS_PRINCIPAL CREATE_DYNAMIC_ROLE PRAGMA AUTO
SYS XS_PRINCIPAL CREATE_ROLE PRAGMA AUTO
SYS XS_PRINCIPAL CREATE_USER PRAGMA AUTO
SYS XS_PRINCIPAL DELETE_PRINCIPAL PRAGMA AUTO
SYS XS_PRINCIPAL ENABLE_BY_DEFAULT PRAGMA AUTO
SYS XS_PRINCIPAL ENABLE_ROLES_BY_DEFAULT PRAGMA AUTO
SYS XS_PRINCIPAL GRANT_ROLES PRAGMA AUTO
SYS XS_PRINCIPAL GRANT_ROLES PRAGMA AUTO
SYS XS_PRINCIPAL REMOVE_PROXY_FROM_DBUSER PRAGMA AUTO
SYS XS_PRINCIPAL REMOVE_PROXY_USERS PRAGMA AUTO
SYS XS_PRINCIPAL REMOVE_PROXY_USERS PRAGMA AUTO
SYS XS_PRINCIPAL REVOKE_ROLES PRAGMA AUTO
SYS XS_PRINCIPAL REVOKE_ROLES PRAGMA AUTO
SYS XS_PRINCIPAL REVOKE_ROLES PRAGMA AUTO
SYS XS_PRINCIPAL SET_ACL PRAGMA AUTO
SYS XS_PRINCIPAL SET_DESCRIPTION PRAGMA AUTO
SYS XS_PRINCIPAL SET_DYNAMIC_ROLE_DURATION PRAGMA AUTO
SYS XS_PRINCIPAL SET_DYNAMIC_ROLE_SCOPE PRAGMA AUTO
SYS XS_PRINCIPAL SET_EFFECTIVE_DATES PRAGMA AUTO
SYS XS_PRINCIPAL SET_GUID PRAGMA AUTO
SYS XS_PRINCIPAL SET_PROFILE PRAGMA AUTO
SYS XS_PRINCIPAL SET_USER_SCHEMA PRAGMA AUTO
SYS XS_PRINCIPAL SET_USER_STATUS PRAGMA AUTO
SYS XS_PRINCIPAL_INT SET_VERIFIER_HELPER PRAGMA AUTO
SYS XS_ROLESET ADD_ROLES PRAGMA AUTO
SYS XS_ROLESET ADD_ROLES PRAGMA AUTO
SYS XS_ROLESET CREATE_ROLESET PRAGMA AUTO
SYS XS_ROLESET DELETE_ROLESET PRAGMA AUTO
SYS XS_ROLESET REMOVE_ROLES PRAGMA AUTO
SYS XS_ROLESET REMOVE_ROLES PRAGMA AUTO
SYS XS_ROLESET REMOVE_ROLES PRAGMA AUTO
SYS XS_ROLESET SET_DESCRIPTION PRAGMA AUTO
SYS XS_SECURITY_CLASS ADD_IMPLIED_PRIVILEGES PRAGMA AUTO
SYS XS_SECURITY_CLASS ADD_IMPLIED_PRIVILEGES PRAGMA AUTO
SYS XS_SECURITY_CLASS ADD_PARENTS PRAGMA AUTO
SYS XS_SECURITY_CLASS ADD_PARENTS PRAGMA AUTO
SYS XS_SECURITY_CLASS ADD_PRIVILEGES PRAGMA AUTO
SYS XS_SECURITY_CLASS ADD_PRIVILEGES PRAGMA AUTO
SYS XS_SECURITY_CLASS CREATE_SECURITY_CLASS PRAGMA AUTO
SYS XS_SECURITY_CLASS DELETE_SECURITY_CLASS PRAGMA AUTO
SYS XS_SECURITY_CLASS REMOVE_IMPLIED_PRIVILEGES PRAGMA AUTO
SYS XS_SECURITY_CLASS REMOVE_IMPLIED_PRIVILEGES PRAGMA AUTO
SYS XS_SECURITY_CLASS REMOVE_IMPLIED_PRIVILEGES PRAGMA AUTO
SYS XS_SECURITY_CLASS REMOVE_PARENTS PRAGMA AUTO
SYS XS_SECURITY_CLASS REMOVE_PARENTS PRAGMA AUTO
SYS XS_SECURITY_CLASS REMOVE_PARENTS PRAGMA AUTO
SYS XS_SECURITY_CLASS REMOVE_PRIVILEGES PRAGMA AUTO
SYS XS_SECURITY_CLASS REMOVE_PRIVILEGES PRAGMA AUTO
SYS XS_SECURITY_CLASS REMOVE_PRIVILEGES PRAGMA AUTO
SYS XS_SECURITY_CLASS SET_DESCRIPTION PRAGMA AUTO
SYS DBMS_RESCONFIG ADDREPOSITORYRESCONFIG PRAGMA AUTO with COMMIT
SYS DBMS_RESCONFIG ADDRESCONFIG PRAGMA AUTO
SYS DBMS_RESCONFIG APPENDRESCONFIG PRAGMA AUTO
SYS DBMS_RESCONFIG DELETEREPOSITORYRESCONFIG PRAGMA AUTO with COMMIT
SYS DBMS_RESCONFIG DELETERESCONFIG PRAGMA AUTO
SYS DBMS_RESCONFIG DELETERESCONFIG PRAGMA AUTO
SYS DBMS_XDBZ DISABLE_HIERARCHY PRAGMA AUTO with COMMIT
SYS DBMS_XDBZ ENABLE_HIERARCHY PRAGMA AUTO with COMMIT
SYS DBMS_XDB_VERSION CHECKIN_INT PRAGMA AUTO
SYS DBMS_XDB_VERSION CHECKOUT PRAGMA AUTO
SYS DBMS_XDB_VERSION MAKEVERSIONED_INT PRAGMA AUTO
SYS DBMS_XDB_VERSION UNCHECKOUT_INT PRAGMA AUTO
SYS DBMS_XLSB DELETERESOURCE PRAGMA AUTO
SYS DBMS_XLSB DELNAMELOCKS PRAGMA AUTO
SYS DBMS_XLSB INSERTRESOURCE PRAGMA AUTO
SYS DBMS_XLSB INSERTRESOURCENXOB PRAGMA AUTO
SYS DBMS_XLSB INSERTRESOURCENXOBCLOB PRAGMA AUTO
SYS DBMS_XLSB INSERTRESOURCEREF PRAGMA AUTO
SYS DBMS_XLSB INSERTTOHTABLE PRAGMA AUTO
SYS DBMS_XLSB INSERTTOUSERHTAB PRAGMA AUTO
SYS DBMS_XLSB LINKRESOURCE PRAGMA AUTO
SYS DBMS_XLSB SAVEACL PRAGMA AUTO
SYS DBMS_XLSB SETREFCOUNT PRAGMA AUTO
SYS DBMS_XLSB TOUCHOID PRAGMA AUTO

PL/SQL Procedures with Pragma MANUAL

For the procedures and packages pragma-ed MANUAL, the top-level PL/SQL API is not called.

Schema Package Procedure Pragma
SYS DBMS_AQ AQ$_BACKGROUND_OPER_PAS PRAGMA MANUAL
SYS DBMS_AQ DEQUEUE_INTERNAL_PAS PRAGMA MANUAL
SYS DBMS_AQ ENQUEUE_INT_UNSHARDED_PAS PRAGMA MANUAL
SYS DBMS_AQADM_SYS ALTER_PROPAGATION_SCHEDULE_INT PRAGMA MANUAL
SYS DBMS_AQADM_SYS ALTER_QUEUE_INT PRAGMA MANUAL
SYS DBMS_AQADM_SYS ALTER_QUEUE_TABLE_INT PRAGMA MANUAL
SYS DBMS_AQADM_SYS ALTER_SUBSCRIBER_11G_INT PRAGMA MANUAL
SYS DBMS_AQADM_SYS CREATE_QUEUE_INT PRAGMA MANUAL
SYS DBMS_AQADM_SYS CREATE_QUEUE_TABLE_INT PRAGMA MANUAL
SYS DBMS_AQADM_SYS DISABLE_PROP_SCHEDULE_INT PRAGMA MANUAL
SYS DBMS_AQADM_SYS DROP_QUEUE_INT PRAGMA MANUAL
SYS DBMS_AQADM_SYS DROP_QUEUE_TABLE_INT PRAGMA MANUAL
SYS DBMS_AQADM_SYS ENABLE_PROP_SCHEDULE_INT PRAGMA MANUAL
SYS DBMS_AQADM_SYS GRANT_QUEUE_PRIVILEGE_INT PRAGMA MANUAL
SYS DBMS_AQADM_SYS MIGRATE_QUEUE_TABLE_INT PRAGMA MANUAL
SYS DBMS_AQADM_SYS PURGE_QUEUE_TABLE PRAGMA MANUAL
SYS DBMS_AQADM_SYS RECOVER_PROPAGATION_INT PRAGMA MANUAL
SYS DBMS_AQADM_SYS REMOVE_ORPHMSGS_NR PRAGMA MANUAL
SYS DBMS_AQADM_SYS REMOVE_SUBSCRIBER_11G PRAGMA MANUAL
SYS DBMS_AQADM_SYS REVOKE_QUEUE_PRIVILEGE_INT PRAGMA MANUAL
SYS DBMS_AQADM_SYS SCHEDULE_PROPAGATION_INT PRAGMA MANUAL
SYS DBMS_AQADM_SYS START_QUEUE_INT PRAGMA MANUAL
SYS DBMS_AQADM_SYS STOP_QUEUE_INT PRAGMA MANUAL
SYS DBMS_AQADM_SYS UNSCHEDULE_PROPAGATION_INT PRAGMA MANUAL
SYS DBMS_GOLDENGATE_AUTH GRANT_ADMIN_PRIVILEGE PRAGMA MANUAL with COMMIT
SYS DBMS_GOLDENGATE_AUTH REVOKE_ADMIN_PRIVILEGE PRAGMA MANUAL with COMMIT
SYS DBMS_INTERNAL_LOGSTDBY EDS_EVOLVE_TABLE_START PRAGMA MANUAL with COMMIT
SYS DBMS_PRVTAQIS SUBID_REPLICATE_INT PRAGMA MANUAL
SYS LOGSTDBY_INTERNAL EDS_ADD_TABLE_I PRAGMA MANUAL with COMMIT
SYS XS_ADMIN_UTIL DROP_SCHEMA_OBJECTS PRAGMA MANUAL
XDB DBMS_XDBZ0 DISABLE_HIERARCHY_INTERNAL PRAGMA MANUAL
XDB DBMS_XDBZ0 ENABLE_HIERARCHY_INTERNAL PRAGMA MANUAL

PL/SQL Procedures with Pragma NONE

For the procedures and packages pragma-ed NONE, PL/SQL markers are not generated and no grouping is performed. Redo logs generated by these procedures are applied or skipped based on table level replication semantics.

Schema Package Procedure Pragma
DVSYS DBMS_MACADM DISABLE_EVENT PRAGMA NONE
DVSYS DBMS_MACADM DV_SANITY_CHECK PRAGMA NONE
DVSYS DBMS_MACADM ENABLE_EVENT PRAGMA NONE
DVSYS DBMS_MACADM SET_PRESERVE_CASE PRAGMA NONE
DVSYS DBMS_MACADM INIT_SESSION PRAGMA NONE
DVSYS DBMS_MACADM UPDATE_POLICY_LABEL_CONTEXT PRAGMA NONE
DVSYS DBMS_MACOLS_SESSION LABEL_AUDIT_RAISE PRAGMA NONE
DVSYS DBMS_MACOLS_SESSION RESTORE_DEFAULT_LABELS PRAGMA NONE
DVSYS DBMS_MACOLS_SESSION SET_POLICY_LABEL_CONTEXT PRAGMA NONE
DVSYS DBMS_MACOUT DISABLE PRAGMA NONE
DVSYS DBMS_MACOUT ENABLE PRAGMA NONE
DVSYS DBMS_MACOUT PL PRAGMA NONE
DVSYS DBMS_MACOUT PUT_LINE PRAGMA NONE
DVSYS DBMS_MACOUT SET_FACTOR PRAGMA NONE
DVSYS DBMS_MACSEC_ROLES SET_ROLE PRAGMA NONE
DVSYS DBMS_MACSEC_ROLES EVALUATE PRAGMA NONE
DVSYS DBMS_MACSEC_ROLES EVALUATE_TR PRAGMA NONE
DVSYS DBMS_MACSEC_ROLES EVALUATE_WR PRAGMA NONE
DVSYS DBMS_MACUTL CHECK_DVSYS_DML_ALLOWED PRAGMA NONE
DVSYS DBMS_MACUTL RAISE_ERROR PRAGMA NONE
DVSYS DBMS_MACUTL RAISE_UNAUTHORIZED_OPERATION PRAGMA NONE
DVSYS EVENT SET PRAGMA NONE
DVSYS EVENT SETDEFAULT PRAGMA NONE
DVSYS EVENT SET_C PRAGMA NONE
SYS DBMS_AQ AQ$_DEQUEUE PRAGMA NONE
SYS DBMS_AQ AQ$_DEQUEUE PRAGMA NONE
SYS DBMS_AQ AQ$_DEQUEUE PRAGMA NONE
SYS DBMS_AQ AQ$_DEQUEUE PRAGMA NONE
SYS DBMS_AQ BIND_AGENT PRAGMA NONE
SYS DBMS_AQ DEQUEUE PRAGMA NONE
SYS DBMS_AQ DEQUEUE PRAGMA NONE
SYS DBMS_AQ DEQUEUE PRAGMA NONE
SYS DBMS_AQ ENQUEUE PRAGMA NONE
SYS DBMS_AQ ENQUEUE PRAGMA NONE
SYS DBMS_AQ ENQUEUE PRAGMA NONE
SYS DBMS_AQ LISTEN PRAGMA NONE
SYS DBMS_AQ LISTEN PRAGMA NONE
SYS DBMS_AQ POST PRAGMA NONE
SYS DBMS_AQ REGISTER PRAGMA NONE
SYS DBMS_AQ UNBIND_AGENT PRAGMA NONE
SYS DBMS_AQ UNREGISTER PRAGMA NONE
SYS DBMS_AQADM ADD_ALIAS_TO_LDAP PRAGMA NONE
SYS DBMS_AQADM ADD_CONNECTION_TO_LDAP PRAGMA NONE
SYS DBMS_AQADM ADD_CONNECTION_TO_LDAP PRAGMA NONE
SYS DBMS_AQADM ADD_SUBSCRIBER PRAGMA NONE
SYS DBMS_AQADM ALTER_PROPAGATION_SCHEDULE PRAGMA NONE
SYS DBMS_AQADM ALTER_QUEUE PRAGMA NONE
SYS DBMS_AQADM ALTER_QUEUE_TABLE PRAGMA NONE
SYS DBMS_AQADM ALTER_SHARDED_QUEUE PRAGMA NONE
SYS DBMS_AQADM ALTER_SUBSCRIBER PRAGMA NONE
SYS DBMS_AQADM ALTER_SUBSCRIBER PRAGMA NONE
SYS DBMS_AQADM CREATE_EXCEPTION_QUEUE PRAGMA NONE
SYS DBMS_AQADM CREATE_NP_QUEUE PRAGMA NONE
SYS DBMS_AQADM CREATE_QUEUE PRAGMA NONE
SYS DBMS_AQADM CREATE_QUEUE_TABLE PRAGMA NONE
SYS DBMS_AQADM CREATE_SHARDED_QUEUE PRAGMA NONE
SYS DBMS_AQADM DEL_ALIAS_FROM_LDAP PRAGMA NONE
SYS DBMS_AQADM DEL_CONNECTION_FROM_LDAP PRAGMA NONE
SYS DBMS_AQADM DISABLE_PROPAGATION_SCHEDULE PRAGMA NONE
SYS DBMS_AQADM DROP_QUEUE PRAGMA NONE
SYS DBMS_AQADM DROP_QUEUE_TABLE PRAGMA NONE
SYS DBMS_AQADM DROP_SHARDED_QUEUE PRAGMA NONE
SYS DBMS_AQADM ENABLE_JMS_TYPES PRAGMA NONE
SYS DBMS_AQADM ENABLE_PROPAGATION_SCHEDULE PRAGMA NONE
SYS DBMS_AQADM GET_PROP_SEQNO PRAGMA NONE
SYS DBMS_AQADM GET_REPLAY_INFO PRAGMA NONE
SYS DBMS_AQADM GET_TYPE_INFO PRAGMA NONE
SYS DBMS_AQADM GET_TYPE_INFO PRAGMA NONE
SYS DBMS_AQADM GET_WATERMARK PRAGMA NONE
SYS DBMS_AQADM GRANT_QUEUE_PRIVILEGE PRAGMA NONE
SYS DBMS_AQADM MIGRATE_QUEUE_TABLE PRAGMA NONE
SYS DBMS_AQADM NONREPUDIATE_RECEIVER PRAGMA NONE
SYS DBMS_AQADM NONREPUDIATE_RECEIVER PRAGMA NONE
SYS DBMS_AQADM NONREPUDIATE_SENDER PRAGMA NONE
SYS DBMS_AQADM NONREPUDIATE_SENDER PRAGMA NONE
SYS DBMS_AQADM PURGE_QUEUE_TABLE PRAGMA NONE
SYS DBMS_AQADM RECOVER_PROPAGATION PRAGMA NONE
SYS DBMS_AQADM REMOVE_SUBSCRIBER PRAGMA NONE
SYS DBMS_AQADM RESET_REPLAY_INFO PRAGMA NONE
SYS DBMS_AQADM REVOKE_QUEUE_PRIVILEGE PRAGMA NONE
SYS DBMS_AQADM SCHEDULE_PROPAGATION PRAGMA NONE
SYS DBMS_AQADM SET_WATERMARK PRAGMA NONE
SYS DBMS_AQADM START_QUEUE PRAGMA NONE
SYS DBMS_AQADM START_TIME_MANAGER PRAGMA NONE
SYS DBMS_AQADM STOP_QUEUE PRAGMA NONE
SYS DBMS_AQADM STOP_TIME_MANAGER PRAGMA NONE
SYS DBMS_AQADM UNSCHEDULE_PROPAGATION PRAGMA NONE
SYS DBMS_AQADM VERIFY_QUEUE_TYPES PRAGMA NONE
SYS DBMS_AQADM VERIFY_QUEUE_TYPES_GET_NRP PRAGMA NONE
SYS DBMS_AQADM VERIFY_QUEUE_TYPES_NO_QUEUE PRAGMA NONE
SYS DBMS_AQELM GET_MAILHOST PRAGMA NONE
SYS DBMS_AQELM GET_MAILPORT PRAGMA NONE
SYS DBMS_AQELM GET_PROXY PRAGMA NONE
SYS DBMS_AQELM GET_SENDFROM PRAGMA NONE
SYS DBMS_AQELM GET_TXTIMEOUT PRAGMA NONE
SYS DBMS_AQELM HTTP_SEND PRAGMA NONE
SYS DBMS_AQELM SEND_EMAIL PRAGMA NONE
SYS DBMS_AQIN AQ$_DEQUEUE_IN PRAGMA NONE
SYS DBMS_AQIN AQ$_DEQUEUE_IN PRAGMA NONE
SYS DBMS_AQIN AQ$_DEQUEUE_IN PRAGMA NONE
SYS DBMS_AQIN AQ$_DEQUEUE_IN PRAGMA NONE
SYS DBMS_AQIN AQ$_DEQUEUE_IN PRAGMA NONE
SYS DBMS_AQIN AQ$_DEQUEUE_RAW PRAGMA NONE
SYS DBMS_AQIN AQ$_DEQUEUE_RAW PRAGMA NONE
SYS DBMS_AQIN AQ$_ENQUEUE_OBJ PRAGMA NONE
SYS DBMS_AQIN AQ$_ENQUEUE_OBJ PRAGMA NONE
SYS DBMS_AQIN AQ$_ENQUEUE_OBJ_NO_RECPL PRAGMA NONE
SYS DBMS_AQIN AQ$_ENQUEUE_OBJ_NO_RECPL PRAGMA NONE
SYS DBMS_AQIN AQ$_ENQUEUE_RAW PRAGMA NONE
SYS DBMS_AQIN AQ$_JMS_ENQUEUE_BYTES_MESSAGE PRAGMA NONE
SYS DBMS_AQIN AQ$_JMS_ENQUEUE_MAP_MESSAGE PRAGMA NONE
SYS DBMS_AQIN AQ$_JMS_ENQUEUE_OBJECT_MESSAGE PRAGMA NONE
SYS DBMS_AQIN AQ$_JMS_ENQUEUE_STREAM_MESSAGE PRAGMA NONE
SYS DBMS_AQIN AQ$_JMS_ENQUEUE_TEXT_MESSAGE PRAGMA NONE
SYS DBMS_AQIN AQ$_LISTEN PRAGMA NONE
SYS DBMS_AQIN AQ$_QUEUE_SUBSCRIBERS PRAGMA NONE
SYS DBMS_AQIN SET_DEQ_SORT PRAGMA NONE
SYS DBMS_AQIN SET_MULTI_RETRY PRAGMA NONE
SYS DBMS_AQJMS AQ$_GET_PROP_STAT PRAGMA NONE
SYS DBMS_AQJMS AQ$_GET_TRANS_TYPE PRAGMA NONE
SYS DBMS_AQJMS AQ$_REGISTER PRAGMA NONE
SYS DBMS_AQJMS AQ$_UNREGISTER PRAGMA NONE
SYS DBMS_AQJMS AQ$_UPDATE_PROP_STAT_QNAME PRAGMA NONE
SYS DBMS_AQJMS CLEAR_DBSESSION_GUID PRAGMA NONE
SYS DBMS_AQJMS CLEAR_GLOBAL_AQCLNTDB_CTX_CLNT PRAGMA NONE
SYS DBMS_AQJMS CLEAR_GLOBAL_AQCLNTDB_CTX_DB PRAGMA NONE
SYS DBMS_AQJMS GET_DB_USERNAME_FOR_AGENT PRAGMA NONE
SYS DBMS_AQJMS SET_DBSESSION_GUID PRAGMA NONE
SYS DBMS_AQJMS SET_GLOBAL_AQCLNTDB_CTX PRAGMA NONE
SYS DBMS_AQJMS SUBSCRIBER_EXISTS PRAGMA NONE
SYS DBMS_AQJMS SUBSCRIBER_EXISTS PRAGMA NONE
SYS DBMS_ISCHED GET_AGENT_PASS_VERIFIER PRAGMA NONE
SYS DBMS_ISCHED OBFUSCATE_CREDENTIAL_PASSWORD PRAGMA NONE
SYS DBMS_REDEFINITION CAN_REDEF_TABLE PRAGMA NONE
SYS DBMS_REDEFINITION REDEF_TABLE PRAGMA NONE
SYS DBMS_SCHEDULER CHECK_SYS_PRIVS PRAGMA NONE
SYS DBMS_SCHEDULER CLOSE_WINDOW PRAGMA NONE
SYS DBMS_SCHEDULER CREATE_CALENDAR_STRING PRAGMA NONE
SYS DBMS_SCHEDULER CREATE_CREDENTIAL PRAGMA NONE
SYS DBMS_SCHEDULER EVALUATE_CALENDAR_STRING PRAGMA NONE
SYS DBMS_SCHEDULER FILE_WATCH_FILTER PRAGMA NONE
SYS DBMS_SCHEDULER GENERATE_EVENT_LIST PRAGMA NONE
SYS DBMS_SCHEDULER GENERATE_JOB_NAME PRAGMA NONE
SYS DBMS_SCHEDULER GET_AGENT_VERSION PRAGMA NONE
SYS DBMS_SCHEDULER GET_CHAIN_RULE_ACTION PRAGMA NONE
SYS DBMS_SCHEDULER GET_CHAIN_RULE_CONDITION PRAGMA NONE
SYS DBMS_SCHEDULER GET_DEFAULT_VALUE PRAGMA NONE
SYS DBMS_SCHEDULER GET_JOB_STEP_CF PRAGMA NONE
SYS DBMS_SCHEDULER GET_SYS_TIME_ZONE_NAME PRAGMA NONE
SYS DBMS_SCHEDULER GET_VARCHAR2_VALUE PRAGMA NONE
SYS DBMS_SCHEDULER GET_VARCHAR2_VALUE PRAGMA NONE
SYS DBMS_SCHEDULER IS_SCHEDULER_CREATED_AGENT PRAGMA NONE
SYS DBMS_SCHEDULER OPEN_WINDOW PRAGMA NONE
SYS DBMS_SCHEDULER RESOLVE_CALENDAR_STRING PRAGMA NONE
SYS DBMS_SCHEDULER RESOLVE_CALENDAR_STRING PRAGMA NONE
SYS DBMS_SCHEDULER RESOLVE_NAME PRAGMA NONE
SYS DBMS_SCHEDULER RUN_JOB PRAGMA NONE
SYS DBMS_SCHEDULER SET_AGENT_REGISTRATION_PASS PRAGMA NONE
SYS DBMS_SCHEDULER STIME PRAGMA NONE
SYS DBMS_SCHEDULER STOP_JOB PRAGMA NONE
SYS DBMS_SCHEDULER SUBMIT_REMOTE_EXTERNAL_JOB PRAGMA NONE
SYS XS_PRINCIPAL SET_PASSWORD PRAGMA NONE
SYS XS_PRINCIPAL SET_VERIFIER PRAGMA NONE

16.9 Listing the Procedures Supported for Oracle GoldenGate Procedural Replication

The DBA_GG_SUPPORTED_PROCEDURES view displays information about the supported packages for Oracle GoldenGate procedural replication.

When a procedure is supported and Oracle GoldenGate procedural replication is on, calls to the procedure are replicated, unless the procedure is excluded specifically.
  1. Connect to the database as sys (sqlplus, sqlcl, sqldeveloper) not as an Oracle GoldenGate administrator.
  2. Query the DBA_GG_SUPPORTED_PROCEDURES view.

Example 16-2 Displaying Information About the Packages Supported for Oracle GoldenGate Procedural Replication

This query displays the following information about the packages:

  • The owner of each package

  • The name of each package

  • The name of each procedure

  • The minimum database release from which the procedure is supported

  • Whether there is an exclusion rule that prevents the procedure from being replicated for some database objects

COLUMN OWNER FORMAT A10
COLUMN PACKAGE_NAME FORMAT A15
COLUMN PROCEDURE_NAME FORMAT A15
COLUMN MIN_DB_VERSION FORMAT A14
COLUMN EXCLUSION_RULE_EXISTS FORMAT A14

SELECT OWNER,
       PACKAGE_NAME,
       PROCEDURE_NAME,
       MIN_DB_VERSION,
       EXCLUSION_RULE_EXISTS
  FROM DBA_GG_SUPPORTED_PROCEDURES;

Your output looks similar to the following:

OWNER      PACKAGE_NAME    PROCEDURE_NAME  MIN_DB_VERSION EXCLUSION_RULE
---------- --------------- --------------- -------------- --------------
XDB        DBMS_XDB_CONFIG ADDTRUSTMAPPING 12.2           NO
CTXSYS     CTX_DDL         ALTER_INDEX     12.2           NO
SYS        DBMS_FGA        DROP_POLICY     12.2           NO
SYS        XS_ACL          DELETE_ACL      12.2           NO
.
.
.

16.10 Monitoring Oracle GoldenGate Procedural Replication

A set of data dictionary views enable you to monitor Oracle GoldenGate procedural replication.

You can use the following views to monitor Oracle GoldenGate procedural replication:

View Description

DBA_GG_SUPPORTED_PACKAGES

Provides details about supported packages for Oracle GoldenGate procedural replication.

When a package is supported and Oracle GoldenGate procedural replication is on, calls to subprograms in the package are replicated.

DBA_GG_SUPPORTED_PROCEDURES

Provides details about the procedures that are supported for Oracle GoldenGate procedural replication.

DBA_GG_PROC_OBJECT_EXCLUSION

Provides details about all database objects that are on the exclusion list for Oracle GoldenGate procedural replication.

A database object is added to the exclusion list using the INSERT_PROCREP_EXCLUSION_OBJ procedure in the DBMS_GOLDENGATE_ADM package. When a database object is on the exclusion list, execution of a subprogram n the package is not replicated if the subprogram operates on the excluded object.

  1. Connect to the database as sys (sqlplus, sqlcl, or sqldeveloper) not as an Oracle GoldenGate administrator.
  2. Query the views related to Oracle GoldenGate procedural replication.