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 is now availble. If you haven't you downloaded already: Why?

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.