Oracle DBMS_STREAMS_AUTO_INT
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx