Oracle | DBMS_STREAMS_AUTO

Oracle DBMS_STREAMS_AUTO_INT 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 Streams Support Utilities

Streams was deprecated 03-Jan-2018 but this package still exists in 23ai,

AUTHID DEFINER

Dependencies

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

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	GET_NEXT_SMID
CLEAN_AUTO_SPLIT_MERGE	READY_TO_SPLIT_NON_CCAC
CLEAN_MISSING_ORIGINAL_CAPTURE	SPLIT_STREAMS
CLEAN_RECOVERABLE_SCRIPT	SPLIT_STREAMS_JOB
ENABLE_AUTO_SPLIT_JOB	SUBMIT_SPLIT_MERGE_STREAMS_JOB
GET_CAPTURE_ID

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);

      

      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;

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