Oracle | DBMS_SHARED_CAPTURE

Oracle DBMS_SHARED_CAPTURE_ADM Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Administration utilities for Shared Capture administration.

AUTHID CURRENT_USER

Dependencies

DBA_CAPTURE	DBMS_STREAMS_ADM
DBA_QUEUES	DBMS_STREAMS_ADM_UTL
DBA_QUEUE_TABLES	DBMS_SYSTEM
DBA_SHARED_CAPGTURE	DBMS_XSTREAM_GG_ADM
DBA_SHARED_CAPTURE_PDBS	DBMS_XSTREAMS_UTL_IVK
DBA_TABLESPACES	GV_$INSTANCE
DBMS_ASSERT	JSON_ARRAY_T
DBMS_LOCK	JSON_ELEMENT_T
DBMS_LOGREP_UTIL	JSON_KEY_LIST
DBMS_SHARED_CAPTURE_INTERNAL	JSON_OBJECT_T
DBMS_SHARED_CAPTURE_IVK	PLITBLM
DBMS_STANDARD

Documented No

First Available 23.1

Pragmas PRAGMA 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 23c)

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); PRAGMA SUPPLEMENTAL_LOG_DATA(configure_service, UNSUPPORTED_WITH_COMMIT);

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

      

      PL/SQL procedure successfully completed.

DISABLE_SERVICE (new 23c)

Disable shared capture service which must be run in the root container dbms_shared_capture_adm.disable_service; PRAGMA SUPPLEMENTAL_LOG_DATA(disable_service, UNSUPPORTED_WITH_COMMIT);

exec dbms_shared_capture_adm.disable_service;

      

      PL/SQL procedure successfully completed.

ENABLE_SERVICE (new 23c)

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

exec dbms_shared_capture_adm.enable_service('USERS');

      

      PL/SQL procedure successfully completed.

START_SERVICE (new 23c)

Start shared capture service

This procedure only starts the capture if there is no registered PDBExtract dbms_shared_capture_adm.start_service; PRAGMA SUPPLEMENTAL_LOG_DATA(start_service, NONE);

exec dbms_shared_capture_adm.start_service;

      

      PL/SQL procedure successfully completed.

STOP_SERVICE (new 23c)

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); PRAGMA SUPPLEMENTAL_LOG_DATA(stop_service, NONE);

exec dbms_shared_capture_adm.stop_service(TRUE);

      

      PL/SQL procedure successfully completed.