Oracle | DBMS_SHARED_CAPTURE

Oracle DBMS_SHARED_CAPTURE_ADM 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 utilities for Shared Capture administration.

AUTHID CURRENT_USER

Dependencies

DBA_CAPTURE	DBMS_STANDARD
DBA_QUEUES	DBMS_STREAMS_ADM
DBA_QUEUE_TABLES	DBMS_STREAMS_ADM_UTL
DBA_SHARED_CAPTURE	DBMS_SYSTEM
DBA_SHARED_CAPTURE_PDBS	DBMS_XSTREAM_GG_ADM
DBA_TABLESPACES	DBMS_XSTREAMS_UTL_IVK
DBMS_ASSERT	GV_$GOLDENGATE_CAPTURE
DBMS_CAPTURE_ADM_INTERNAL	JSON_ARRAY_T
DBMS_CHANGE_TABLE_ADM	JSON_ELEMENT_T
DBMS_LOCK	JSON_KEY_LIST
DBMS_LOGREP_UTIL	JSON_OBJECT_T
DBMS_LOGREP_UTIL_INVOK	PLITBLM
DBMS_SHARED_CAPTURE_INTERNAL	STREAMS$_CAPTURE_PROCESS
DBMS_SHARED_CAPTURE_IVK	WRM$_DATABASE_INSTANCE

Documented No

First Available 23ai

Pragmas SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED_WITH_COMMIT);

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE and OGG_SHARED_CAPTURE roles.

Source {ORACLE_HOME}/rdbms/admin/dbmscap.sql
{ORACLE_HOME}/rdbms/admin/prvtbcap.plb

Subprograms

CONFIGURE_SERVICE	ENABLE_SERVICE	STOP_SERVICE
DISABLE_SERVICE	START_SERVICE

CONFIGURE_SERVICE (new 23ai)

Configures the shared capture service based on the input parameters

Parameters must be in JSON format, for example:'{"max_workers" : 3, "change_table_retention_TIME" : 15}'

Valid parameters: MAX_WORKERS,
CHANGE_TABLE_RETENTION_TIME and existing capture parameters like MAX_SGA_SIZE, PARALELISM, etc. dbms_shared_capture_adm.configure_service( num_instances IN BINARY_INTEGER DEFAULT NULL, capture_parameters IN VARCHAR2 DEFAULT NULL);

exec dbms_shared_capture_adm.configure_service(1, '{"max_workers" : 3}');

      

      PL/SQL procedure successfully completed.

DISABLE_SERVICE (new 23ai)

Disable shared capture service which must be run in the root container dbms_shared_capture_adm.disable_service;

exec dbms_shared_capture_adm.disable_service;

      

      PL/SQL procedure successfully completed.

ENABLE_SERVICE (new 23ai)

Enable shared capture service which must be run in the root container dbms_shared_capture_adm.enable_service(tablespace_name IN VARCHAR2);

exec dbms_shared_capture_adm.enable_service('USERS');

      

      PL/SQL procedure successfully completed.

START_SERVICE (new 23ai)

Start shared capture service

This procedure only starts the capture if there is no registered PDBExtract dbms_shared_capture_adm.start_service;

exec dbms_shared_capture_adm.start_service;

      

      PL/SQL procedure successfully completed.

STOP_SERVICE (new 23ai)

Stop shared capture service

Force must be true when there is a registered PDB Extract dbms_shared_capture_adm.stop_service(force IN BOOLEAN DEFAULT FALSE);

exec dbms_shared_capture_adm.stop_service(TRUE);

      

      PL/SQL procedure successfully completed.