Oracle | DBMS_STREAMS_AUTO

Oracle DBMS_STREAMS_AUTO_INT Version 21c

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 Undocumented

AUTHID DEFINER

Dependencies

DBA_APPLY	DBMS_LOCK	GV$PROPAGATION_RECEIVER
DBA_APPLY_ERROR	DBMS_LOGREP_UTIL	GV$STREAMS_CAPTURE
DBA_APPLY_SPILL_TXN	DBMS_PROPAGATION_INTERNAL	OBJ$
DBA_CAPTURE	DBMS_RECOVERABLE_SCRIPT	PLITBLM
DBA_CAPTURE_PARAMETERS	DBMS_SCHEDULER	RECO_SCRIPT_BLOCK$
DBA_PROPAGATION	DBMS_SQL	STREAMS$_CAPTURE_PROCESS
DBA_QUEUE_SCHEDULES	DBMS_STANDARD	STREAMS$_CAPTURE_SERVER
DBA_RECOVERABLE_SCRIPT_HIST	DBMS_STREAMS_ADM_UTL	STREAMS$_PROCESS_PARAMS
DBA_SCHEDULER_JOB_RUN_DETAILS	DBMS_STREAMS_SM	STREAMS$_PROPAGATION_PROCESS
DBMS_ASSERT	DBMS_SYSTEM	STREAMS$_SM_ID
DBMS_CAPTURE_ADM	DBMS_UTILITY	STREAMS$_SPLIT_MERGE
DBMS_CAPTURE_ADM_INTERNAL	DUAL	_DBA_SXGG_SPLIT_MERGE
DBMS_CAPTURE_ADM_IVK	GLOBAL_NAME

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvthsai.plb

Subprograms

APPLY_SPLITTABLE_VARCHAR2	ENABLE_AUTO_SPLIT_JOB	SPLIT_STREAMS
CLEAN_AUTO_SPLIT_MERGE	GET_CAPTURE_ID	SPLIT_STREAMS_JOB
CLEAN_MISSING_ORIGINAL_CAPTURE	GET_NEXT_SMID	SUBMIT_SPLIT_MERGE_STREAMS_JOB
CLEAN_RECOVERABLE_SCRIPT	READY_TO_SPLIT_NON_CCAC

APPLY_SPLITTABLE_VARCHAR2

Undocumented dbms_streams_auto_int.apply_splittable_varchar2(canon_apply_name IN VARCHAR2) RETURN VARCHAR2;

TBD

CLEAN_AUTO_SPLIT_MERGE

Undocumented dbms_streams_auto_int.clean_auto_split_merge(life_time IN NUMBER);

exec dbms_streams_auto_int.clean_auto_split_merge(10);

      

      PL/SQL procedure successfully completed.

CLEAN_MISSING_ORIGINAL_CAPTURE

Undocumented dbms_streams_auto_int.clean_missing_original_capture(canon_capture_name IN VARCHAR2);

TBD

CLEAN_RECOVERABLE_SCRIPT

Undocumented dbms_streams_auto_int.clean_recoverable_script(life_time IN NUMBER);

exec dbms_streams_auto_int.clean_recoverable_script(11);

      

      PL/SQL procedure successfully completed.

ENABLE_AUTO_SPLIT_JOB

Undocumented dbms_streams_auto_int.enable_auto_split_job( canon_capture_name IN VARCHAR2, canon_queue_owner IN VARCHAR2, canon_queue_name IN VARCHAR2);

TBD

GET_CAPTURE_ID

Undocumented dbms_streams_auto_int.get_capture_id(canon_capture_name IN VARCHAR2) RETURN NUMBER;

SELECT dbms_streams_auto_int.get_capture_id(1)

      FROM dual;

      

      DBMS_STREAMS_AUTO_INT.GET_CAPTURE_ID(1)

      ---------------------------------------

GET_NEXT_SMID

Undocumented dbms_streams_auto_int.get_next_smid RETURN NUMBER;

SELECT dbms_streams_auto_int.get_next_smid

      FROM dual;

READY_TO_SPLIT_NON_CCAC

Undocumented dbms_streams_auto_int.ready_to_split_non_ccac( canon_capture_name IN VARCHAR2, split_threshold IN NUMBER, canon_streams_name OUT VARCHAR2, streams_type OUT NUMBER, real_lag OUT NUMBER) RETURN BOOLEAN;

TBD

SPLIT_STREAMS

Undocumented dbms_streams_auto_int.split_streams( canon_capture_name IN VARCHAR2, canon_cloned_capture_name IN OUT VARCHAR2, canon_streams_name IN VARCHAR2, canon_cloned_streams_name IN OUT VARCHAR2, streams_type IN NUMBER, auto_merge_threshold IN NUMBER);

TBD

SPLIT_STREAMS_JOB

Undocumented dbms_streams_auto_int.split_streams_job( canon_capture_name IN VARCHAR2, canon_split_jowner IN VARCHAR2, canon_split_jname IN VARCHAR2);

TBD

SUBMIT_SPLIT_MERGE_STREAMS_JOB

Undocumented dbms_streams_auto_int.submit_split_merge_streams_job( canon_capture_name IN VARCHAR2, split_threshold IN NUMBER, merge_threshold IN NUMBER, sm_job_max_interval IN NUMBER, is_starting IN BOOLEAN);

TBD