Oracle | DBMS_APP_CONT

Oracle DBMS_APP_CONT_ADMIN Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Administration support package for application continuity that allows an application to manage transaction monitoring and replay for select-only transactions.

All of its functionality with the exception of a single object was split out from DBMS_APP_CONT and the documentation was not update to reflect the change in location. This looks like more of the work of Oracle's Executive VP of Product Renaming.

AUTHID DEFINER

Constants

Name	Data Type	Value
Planned Maintenance Test Types
BEGINREQUEST_TEST	BINARY_INTEGER	3
ENDREQUEST_TEST	BINARY_INTEGER	2
PING_TEST	BINARY_INTEGER	1
SQL_TEST	BINARY_INTEGER	0
XA_START_TEST	BINARY_INTEGER	4
ACCHK Filtering Types
MACHINE_FILTER	BINARY_INTEGER	4
MODULE_FILTER	BINARY_INTEGER	3
PROGRAM_FILTER	BINARY_INTEGER	2
SERVICE_FILTER	BINARY_INTEGER	1
Target Side Effects
AUTONOMOUS_TRANSACTIONS	BINARY_INTEGER	2
DATABASE_LINKS	BINARY_INTEGER	4
SIDE_EFFECTS	BINARY_INTEGER	1

Dependencies

ACCH_METADATA	DBMS_OUTPUT	DUAL
ALL_SERVICES	DBMS_SCHEDULER	OBJ$
CDBVIEW	DBMS_SERVICE	PLITBLM
DBMS_APP_CONT_ADMIN_LIB	DBMS_SQL	SERVICE$
DBMS_APP_CONT_PMT_LIB	DBMS_STANDARD	V$PARAMETER
DBMS_APP_CONT_PRVT_LIB3	DBMS_SYS_ERROR	V$PDBS

Data Types TYPE svc_parameter_array IS TABLE OF VARCHAR2(100) INDEX BY VARCHAR2(100);

Documented Yes: Packages and Types Reference

Exceptions

Error Code	Reason
ORA-65159	Invalid service name specified

First Available 19c

Security Model Owned by SYS with EXECUTE granted to the DBA role.

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

Subprograms

ACCHK_CLEAR_FILTER	DELETE_SQL_CONNECTION_TEST	ENABLE_SMART_CONNECTION
ACCHK_PURGE	DISABLE_CONNECTION_TEST	ENABLE_TAC
ACCHK_SET	DISABLE_FAILOVER	ENABLE_TAF
ACCHK_SET_FILTER	DISABLE_LTXID_TABLE_LOCK	ENABLE_TG
ACCHK_SHOW_FILTERS	DISABLE_SMART_CONNECTION	MODIFY_SERVICE
ACCHK_VIEWS	ENABLE_AC	RESET_REPLAY_RULES
ADD_SQL_CONNECTION_TEST	ENABLE_CONNECTION _TEST	SET_DRAINING
CHECK_REPLAY_RULES	ENABLE_LTXID_TABLE_LOCK	SET_LOAD_BALANCING_GOAL
CREATE_CHILD_SERVICE	ENABLE_RESET_STATE	SET_REPLAY_RULES
DELETE_CHILD_SERVICE

ACCHK_CLEAR_FILTER (new 23ai)

This procedure sets ACCHK filtering options for acchk protection analysis by service name, module name, program name, and machine name dbms_app_cont_admin.acchk_clear_filter( filter_type IN NUMBER DEFAULT NULL, filter_name IN VARCHAR2 DEFAULT NULL, purge_all IN BOOLEAN DEFAULT FALSE);

TBD

ACCHK_PURGE (new 23ai)

Deletes partial or all ACCHK collected information dbms_app_cont_admin.acchk_purge( start_time IN DATE DEFAULT NULL, end_time IN DATE DEFAULT NULL, pure_all IN BOOLEAN DEAFAULT FALSE);

TBD

ACCHK_SET

Enables or disables the data collection for acchk protection analysis dbms_app_cont_admin.acchk_set( enabled IN BOOLEAN, service_name IN VARCHAR2 DEFAULT NULL);

exec dbms_app_cont_admin.acchk_set(TRUE);

      

      ACCHK is enabled

      

      PL/SQL procedure successfully completed.

ACCHK_SET_FILTER (new 23ai)

This procedure sets ACCHK filtering options for acchk protection analysis by service name, module name, program name, and machine name dbms_app_cont_admin.acchek_set_filters( filter_type IN NUMBER, filter_name IN VARCHAR2);

TBD

ACCHK_SHOW_FILTERS (new 23ai)

Uses a cursor to show ACCHK filters ordered by service name, program name, module name, and machine dbms_app_cont_admin.acchk_show_filters;

TBD

ACCHK_VIEWS (new 23ai)

Creates ACCHK views for ACCHK protected analysis dbms_app_cont_admin.acchk_views;

exec dbms_app_cont_admin.acchk_views;

      

      PL/SQL procedure successfully completed.

ADD_SQL_CONNECTION_TEST

Adds a SQL connection test with or without a service name. These tests will be used by the server to drain sessions during planned maintenance dbms_app_cont_admin.add_sql_connection_test( connection_test IN VARCHAR2, service_name IN VARCHAR2 DEFAULT '');

exec dbms_app_cont_admin.add_sql_connection_test('UWCNXTESTS', 'PDBDEV');

      

      PL/SQL procedure successfully completed.

CHECK_REPLAY_RULES (new 23ai)

Shows replay rules for the given or the current service

How? it doesn't return anything?

Overload 1 dbms_app_cont_admin.check_replay_rules(service_name IN VARCHAR2 DEFAULT NULL);

TBD

gets replay rules for the given or the current service
-- and returns the replayable targets as a bitmap in targets argument

Overload 2 dbms_app_cont_admin.check_replay_rules( service_name IN VARCHAR2 DEFAULT NULL, targets OUT BINARY_INTEGER);

TBD

CREATE_CHILD_SERVICE (new 23ai)

If a parent service exists, creates a child service dbms_app_cont_admin.create_child_service( child_service_name IN VARCHAR2, parent_service_name IN VARCHAR2);

TBD

DELETE_CHILD_SERVICE (new 23ai)

Deletes the named child service for the named parent service exists dbms_app_cont_admin.delete_child_service( child_service_name IN VARCHAR2, parent_service_name IN VARCHAR2);

TBD

DELETE_SQL_CONNECTION_TEST

Removes a SQL connection test with or without a service name dbms_app_cont_admin.delete_sql_connection_test( connection_test IN VARCHAR2, service_name IN VARCHAR2 DEFAULT '');

exec dbms_app_cont_admin.delete_sql_connection_test(dbms_app_cont_admin.sql_test);

DISABLE_CONNECTION_TEST

Disable a connection test dbms_app_cont_admin.disable_connection_test( connection_test_type IN BINARY_INTEGER, connection_test IN VARCHAR2, service_name IN VARCHAR2);

exec dbms_app_cont_admin.disable_connection_test(dbms_app_cont_admin.endrequest_test);

DISABLE_FAILOVER

Disables failover features on the given service dbms_app_cont_admin.disable_failover(service_name IN VARCHAR2);

exec dbms_app_cont_admin.disable_failover('PDBDEVRPT');

DISABLE_LTXID_TABLE_LOCK

Disables table lock on ltxid_trans table dbms_app_cont_admin.disable_ltxid_table_lock;

exec dbms_app_cont_admin.disable_ltxid_table_lock;

DISABLE_SMART_CONNECTION (new 23ai)

Disables smart connection for the named service and sets the goal to GOAL_NONE dbms_app_cont_admin.disable_smart_connection(service_name IN VARCHAR2)

exec dbms_app_cont_admin.disable_smart_connection('PDBDEVRPT');

ENABLE_AC

Enables Application Continuity (AC) for the named service dbms_app_cont_admin.enable_ac( service_name IN VARCHAR2, failover_restore IN VARCHAR2 DEFAULT 'LEVEL1');

exec dbms_app_cont_admin.enable_ac('PDBDEVRPT', 'LEVEL1');

ENABLE_CONNECTION_TEST

Enables a connection test dbms_app_cont_admin.enable_connection_test( connection_test_type IN BINARY_INTEGER, connection_test IN VARCHAR2, service_name IN VARCHAR2);

exec dbms_app_cont_admin.enable_connection_test(dbms_app_cont_admin.ping_test, 'UWCNXTEST', 'PDBDEVRPT');

ENABLE_LTXID_TABLE_LOCK

Enables table lock on ltxid_trans table dbms_app_cont_admin.enable_ltxid_table_lock;

exec dbms_app_cont_admin.enable_ltxid_table_lock;

ENABLE_RESET_STATE

Enables reset_state for the named service. To use this interface the service must have FAILOVER_TYPE TRANSACTION or AUTO dbms_app_cont_admin.enable_reset_state( service_name IN VARCHAR2, level IN VARCHAR2 DEFAULT 'NONE');

exec dbms_app_cont_admin.enable_reset_state('PDBDEVRPT');

ENABLE_SMART_CONNECTION (new 23ai)

Enables smart connection for the named service and sets the goal to SMART_CONN dbms_app_cont_admin.enable_smart_connection(service_name IN VARCHAR2);

exec dbms_app_cont_admin.enable_smart_connection('PDBDEVRPT');

ENABLE_TAC

Enables Transparent Application Continuity (TAC) for the named service dbms_app_cont_admin.enable_tac( service_name IN VARCHAR2, failover_restore IN VARCHAR2);

exec dbms_app_cont_admin.enable_tac('PDBDEVRPT', 'AUTO');

ENABLE_TAF

Enables Transparent Application Failover for the named service dbms_app_cont_admin.enable_taf( service_name IN VARCHAR2, failover_type IN VARCHAR2, failover_restore IN VARCHAR2);

exec dbms_app_cont_admin.enable_taf('PDBDEVRPT', 'SESSION');

ENABLE_TG

enables Transaction Guard (TG) on the given service dbms_app_cont_admin.enable_tg(service_name IN VARCHAR2);

exec dbms_app_cont_admin.enable_tg('PDBDEVRPT');

MODIFY_SERVICE (new 23ai)

Modifies a database service using the given parameters. Only parameters defined in the allowed list are accepted dbms_app_cont_admin.modify_service( service_name IN VARCHAR2, service_params IN dbms_app_cont_admin.svc_parameter_array);

TBD

RESET_REPLAY_RULES (new 23ai)

Clears locally defined rules in the desired scope and restores them to what's inherited from the parent scope, or the service if it doesn't have a parent scope dbms_app_cont_admin.reset_replay_rules( targets IN BINARY_INTEGER DEFAULT NULL, scope IN BINARY_INTEGER DEFAULT SCOPE_CURRENT);

TBD

SET_DRAINING

Sets the session drain timeout and stop_option for the given service dbms_app_cont_admin.set_draining( service_name IN VARCHAR2, drain_timeout IN BINARY_INTEGER DEFAULT NULL, stop_option IN VARCHAR2 DEFAULT NULL);

exec dbms_app_cont_admin.set_draining('PDBDEVRPT');

SET_LOAD_BALANCING_GOAL

Sets Runtime Load Balancing (RLB) goal for the given service dbms_app_cont.set_load_balancing_goal( service_name IN VARCHAR2, goal IN VARCHAR2 DEFAULT 'NONE');

exec dbms_app_cont_admin.set_load_balancing_goal('PDBDEVRPT', 'CLB_GOAL_SHORT');

SET_REPLAY_RULES (new 23ai)

Sets Application Continuity replay rules for the given or the current service. The rules are used by to determine whether side effects may be replayed, but do not impact normal runtime operation dbms_app_cont_admin.set_replay_rules( service_name IN VARCHAR2 DEFAULT NULL, replayable IN BOOLEAN, targets IN BINARY_INTEGER);

TBD