Oracle DBMS_XSTREAM_GG_INTERNAL
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose XStreams support for GoldenGate
AUTHID DEFINER
Data Types  
Dependencies
APPLY$_CDR_INFO DBMS_LOGREP_UTIL DBMS_XSTREAM_GG
APPLY$_ERROR DBMS_STANDARD DBMS_XSTREAM_GG_ADM
DBMS_LOGMNR_INTERNAL DBMS_STREAMS_ADM_UTL_INVOK DBMS_XSTREAM_UTL_IVK
DBMS_LOGREP_LIB DBMS_UTILITY V$PDBS
Documented No
First Available 12cR1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthxstr.plb
Subprograms
 
BUILD_PDBSET_DICTIONARY
Undocumented dbms_xstream_gg_internal.build_pdbset_dictionary(
pdb_names           IN  dbms_utility.uncl_array,
flags               IN  NUMBER,
first_lockdown_scan OUT NUMBER,
last_lockdown_scan  OUT NUMBER);
SQL> ALTER DATABASE FORCE LOGGING;

Database altered.

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

Database altered.

SQL> DECLARE
  2   pdbtab dbms_utility.uncl_array;
  3   oval1 NUMBER;
  4   oval2 NUMBER;
  5  BEGIN
  6    pdbtab(1) := 'CDB$ROOT';
  7
  8    dbms_xstream_gg_internal.build_pdbset_dictionary(pdbtab, 0, oval1, oval2);
  9    dbms_output.put_line(oval1);
 10    dbms_output.put_line(oval2);
 11  END;
 12  /
2459665
2459665


PL/SQL procedure successfully completed.
 
DISABLE_TDUP_WRKSPC_INT
Undocumented dbms_xstream_gg_internal.disable_tdup_wrkspc_int;
exec dbms_xstream_gg_internal.disable_tdup_wrkspc_int;
 
ENABLE_TDUP_WORKSPACE_INT
Undocumented dbms_xstream_gg_internal.enable_tdup_workspace_int;
SQL> exec dbms_xstream_gg_internal.enable_tdup_workspace_int;
BEGIN dbms_xstream_gg_internal.enable_tdup_workspace_int; END;

*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 290
ORA-06512: at line 1
 
GET_GG_SESS_FLAGS_INT
Undocumented dbms_xstream_gg_internal.get_gg_sess_flags_int RETURN BINARY_INTEGER;
SELECT dbms_xstream_gg_internal.get_gg_sess_flags_int
FROM dual;
 
GET_MDH_FOR_PDBNAME_SCN
Undocumented dbms_xstream_gg_internal.get_mdh_for_pdbname_scn(
logmnr_session_num IN NUMBER,
pdbname            IN VARCHAR2,
asofscn            IN NUMBER)
RETURN NUMBER;
TBD
 
GET_PDBNAME_FOR_MDH
Undocumented dbms_xstream_gg_internal.get_pdbname_for_mdh(
logmnr_session_num IN NUMBER,
mdh                IN NUMBER)
RETURN VARCHAR2;
 
 
GET_PDB_INFO
Undocumented dbms_xstream_gg_internal.get_pdb_info(
pdb_name        IN  VARCHAR2,
pdb_exists      OUT BOOLEAN,
pdb_open        OUT BOOLEAN,
pdb_global_name OUT VARCHAR2,
flags           OUT BINARY_INTEGER,
spare1          OUT NUMBER,
spare2          OUT VARCHAR2);
DECLARE
 pdbex  BOOLEAN;
 pdbop  BOOLEAN;
 pdbgn  VARCHAR2(60);
 pdbflg BINARY_INTEGER;
 spVal1 NUMBER;
 spVal2 VARCHAR2(60);
BEGIN
  dbms_xstream_gg_internal.get_pdb_info('PDBDEV', pdbex, pdbop, pdbgn, pdbflg, spVal1, spVal2);
  IF pdbex THEN
    dbms_output.put_line('PDBDEV Exists');
  END IF;
  IF pdbop THEN
    dbms_output.put_line('PDBDEV Is Open');
  END IF;
  dbms_output.put_line(pdbgn);
  dbms_output.put_line(pdbflg);
  dbms_output.put_line(spVal1);
  dbms_output.put_line(spVal2);
END;
/
 
INIT_WFIT_N_SYNCH_VARS
Undocumented dbms_xstream_gg_internal.init_wfit_n_synch_vars(
input_wfit IN  VARCHAR2,
input_sync IN  VARCHAR2,
saved_wfit OUT VARCHAR2,
saved_sync OUT VARCHAR2);
TBD
 
IS_CHARSET_COMP_FOR_MINING
Undocumented dbms_xstream_gg_internal.is_charset_comp_for_mining(
canon_charset_name IN VARCHAR2);
RETURN BINARY_INTEGER;
TBD
 
IS_CTAS_NO_DML_SESS_INT
Undocumented dbms_xstream_gg_internal.is_ctas_no_dml_ses_int RETURN BOOLEAN;
BEGIN
  IF dbms_xstream_gg_internal.is_ctas_no_dml_ses_int THEN
    dbms_output.put_line('What it is ... it is TRUE);
  END IF;
END;
/
 
IS_FOO_TRIG_FIRE_AT_SESS_INT
Undocumented dbms_xstream_gg_internal.is_foo_trig_fire_at_sess_int RETURN BOOLEAN;
exec dbms_xstream_gg_internal.is_foo_trig_fire_at_sess_int(FALSE);
 
IS_TDUP_WRKSPC_ENABLED_INT
Undocumented dbms_xstream_gg_internal.is_tdup_wrkspc_enabled_int RETURN BOOLEAN;
exec dbms_xstream_gg_internal.is_tdup_wrkspc_enabled_int(FALSE);
 
PURGE_CDR_INFO_INTERNAL
Undocumented dbms_xstream_gg_internal.purge_cdr_info_internal(
local_transaction_id IN VARCHAR2,
seqno                IN NUMBER,
rba                  IN NUMBER,
index_num            IN NUMBER);
TBD
 
RESTORE_VARIABLES
Undocumented dbms_xstream_gg_internal.restore_variables(
wfit   IN VARCHAR2,
sync   IN VARCHAR2,
is_ogg IN BOOLEAN);
TBD
 
SET_CTAS_SESS_CTX_INT
Undocumented dbms_xstream_gg_internal.set_ctas_sess_ctx_int(suppress_DML IN BOOLEAN);
exec dbms_xstream_gg_internal.set_ctas_sess_ctx_int(TRUE);
 
SET_FOO_TRIGGER_CONTXT_INT
Undocumented dbms_xstream_gg_internal.set_foo_trigger_contxt_int(fire IN BOOLEAN);
exec dbms_xstream_gg_internal.set_foo_trigger_contxt_int(FALSE);
 
SET_GG_SESS_FLAGS_INT
Undocumented dbms_xstream_gg_internal.set_gg_sess_flags_int(
gg_flags IN BINARY_INTEGER,
smode    IN BINARY_INTEGER);
SQL> exec dbms_xstream_gg_internal.set_gg_sess_flags_int(1,1);
BEGIN dbms_xstream_gg_internal.set_gg_sess_flags_int(1,1); END;
*
ERROR at line 1:
ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_XSTREAM_GG_INTERNAL", line 320
ORA-06512: at line 1
 
SET_SESSION_ACTION
Undocumented dbms_xstream_gg_internal.set_session_action(
action_name     IN VARCHAR2,
logmnr_session# IN NUMBER,
action_type     IN VARCHAR2,
action_options  IN NUMBER,
xid_usn         IN NUMBER,
xid_slt         IN NUMBER,
xid_sqn         IN NUMBER,
thread#         IN NUMBER,
start_scn       IN NUMBER,
start_sub_Scn   IN NUMBER,
end_scn         IN NUMBER,
end_sub_scn     IN NUMBER,
rba_sqn         IN NUMBER,
rba_blk         IN NUMBER,
rba_byte        IN NUMBER,
session#        IN NUMBER,
obj#            IN NUMBER,
attr1           IN NUMBER,
attr2           IN NUMBER,
attr3           IN NUMBER);
TBD
 
UNSET_SESSION_ACTION
Undocumented dbms_xstream_gg_internal.unset_session_action(
action_name     IN VARCHAR2,
logmnr_session# IN NUMBER,
FORCE           IN BOOLEAN);
TBD
 
UPDATE_ERROR_TXN
Undocumented dbms_xstream_gg_internal.update_error_txn(
transaction_id IN VARCHAR2,
error_flags    IN NUMBER);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_GOLDENGATE_ADM
DBMS_GOLDENGATE_ADM_INTERNAL
DBMS_GOLDENGATE_AUTH
DBMS_GOLDENGATE_EXP
DBMS_GOLDENGATE_IMP
DBMS_XSTREAM_ADM
DBMS_XSTREAM_GG
What's New In 18cR3
What's New In 19cR2

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