Oracle DBMS_LOGMNR_INTERNAL
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 Log Miner Internal Utilities
AUTHID DEFINER
Constants
Name Data Type Value
 General
LS_Special_2 NUMBER 10
LS_Special_3 NUMBER 11
Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_LOGMNR_INTERNAL' UNION
SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_LOGMNR_INTERNAL'
ORDER BY 1;

Returns 101 objects
Documented No
First Available Not known
Security Model Owned by SYS with EXECUTE granted to SYSTEM
Source {ORACLE_HOME}/rdbms/admin/prvtlmd.plb
Subprograms
ADD_TABLE_INCLUSION_RULE GET_PDBNAME_FOR_MDH PRUNE_STREAMS_CKPT
ADD_USER_INCLUSION_RULE GET_PROCESS_ROLE# RELEASE_SESS_OP_LOCK
ADD_XID_INCLUSION_RULE GET_ROOT_GLOBAL_NAME RELEASE_SHARED_SETTBL_LOCK
ADVANCE_READ_SCN GET_SESSION_ACTION_TYPE# REPLACE_DICTIONARY_BEGIN
AGESPILL_11202TO112 GET_SESS_OP_LOCK REPLACE_DICTIONARY_END
AGESPILL_11204TO121 GET_SHARED_SETTBL_LOCK RESOLVE_TABLE_INCLUSION_RULE
AGESPILL_112TO11 INIT_REPLICATION_METADATA SET_SESSION_ACTION
AGESPILL_11TO112 INIT_REPLICATION_META_TAB SET_SESSION_ACTION2
AGESPILL_121TO11204 INIT_REPLICATION_META_UPGRADE SET_SESSION_ACTION_HELPER
AGESPILL_12202TO122 INJECTCOMMITORROLLBACK SET_TABLESPACE
AGESPILL_122TO12 INSERT_INTO_SESSION_ACTION_TBL SHARE_PERSISTENT_DICTIONARY
AGESPILL_122TO12202 INT_BUILD SKIP_OBJ
AGESPILL_12TO122 INT_BUILD_N SKIP_OBJ_C
DELETE_TABLE_INCLUSION_RULE IS_SHARED_CAPTURE SKIP_OBJ_V
DELETE_USER_INCLUSION_RULE KRVIGSSS SKIP_RBA
DELETE_XID_INCLUSION_RULE KRVILCJ SKIP_SCN
DICTIONARY_S_LOCK KRVIOSTZ SKIP_XID
DICTIONARY_S_LOCK_FS LOGMNR_KRVICL TRACEREDOLOGS
DICTIONARY_UNLOCK LOGMNR_KRVIFTSI TRACE_FOREIGN_LOG_INFO
DICTIONARY_X_LOCK LOGMNR_KRVIGENQ TRACE_LOCAL_LOG_INFO
DICTIONARY_X_LOCK_FS LOGMNR_KRVIISAC TRACE_LOCAL_XID
DO_INT_BUILD LOGMNR_KRVILSS TRACE_TABLE_LOCAL_DICT
DUMP_CKPT_DATA LOGMNR_KRVILT UNSET_SESSION_ACTION
DUMP_PAGEOUT_DATA LOGMNR_KRVIRENQ UNSET_SESSION_ACTION_HELPER
DUMP_STREAMS_CKPT_DATA LOGMNR_KRVIULSS UNSKIP_OBJ
ENABLE_ONLINE_DDL LOGMNR_KRVIULT UNSKIP_OBJ_C
GET_BRANCH_INFO LOGMNR_SESSION_EVOLVE_DIVERGED UNSKIP_RBA
GET_MDH PMOP_LOCK UNSKIP_SCN
GET_MDH_FOR_PDBNAME_SCN PMOP_UNLOCK UNSKIP_XID
 
ADD_TABLE_INCLUSION_RULE
Undocumented dbms_logmnr_internal.add_table_inclusion_rule(
schema_name    IN VARCHAR2,
table_name     IN VARCHAR2,
container_name IN VARCHAR2);
TBD
 
ADD_USER_INCLUSION_RULE
Undocumented dbms_logmnr_internal.add_user_inclusion_rule(
user_name      IN VARCHAR2,
user_type      IN NUMBER,
container_name IN VARCHAR2);
TBD
 
ADD_XID_INCLUSION_RULE
Undocumented dbms_logmnr_internal.add_xid_inclusion_rule(
l_xidusn IN NUMBER,
l_xidslt IN NUMBER,
l_xidsqn IN NUMBER);
TBD
 
ADVANCE_READ_SCN
Undocumented dbms_logmnr_internal.advance_read_scn(sid_in IN NUMBER);
exec dbms_logmnr_internal.advance_read_scn(sys_context('USERENV', 'SESSIONID'));
*
ORA-01309: invalid session
 
AGESPILL_11202TO112
Undocumented

Previously tested in the appropriate versions		 dbms_logmnr_internal.agespill_11202to112;
exec dbms_logmnr_internal.agespill_11202to112;

PL/SQL procedure successfully completed.
 
AGESPILL_11204TO121
Undocumented

Previously tested in the appropriate versions		 dbms_logmnr_internal.agespill_11204to121;
exec dbms_logmnr_internal.agespill_11204to121;

PL/SQL procedure successfully completed.
 
AGESPILL_112TO11
Undocumented

Previously tested in the appropriate versions		 dbms_logmnr_internal.agespill_112to11;
exec dbms_logmnr_internal.agespill_112to11;

PL/SQL procedure successfully completed.
 
AGESPILL_11TO112
Undocumented

Previously tested in the appropriate versions		 dbms_logmnr_internal.agespill_11to112;
exec dbms_logmnr_internal.agespill_11to112;

PL/SQL procedure successfully completed.
 
AGESPILL_121TO11204
Undocumented

Previously tested in the appropriate versions		 dbms_logmnr_internal.agespill_121to11204;
exec dbms_logmnr_internal.agespill_121to11204;

PL/SQL procedure successfully completed.
 
AGESPILL_12202TO122
Undocumented

Previously tested in the appropriate versions		 dbms_logmnr_internal.agespill_12202to122;
exec dbms_logmnr_internal.agespill_12202to122;

PL/SQL procedure successfully completed.
 
AGESPILL_122TO12
Undocumented

Previously tested in the appropriate versions		 dbms_logmnr_internal.agespill_122to12;
exec dbms_logmnr_internal.agespill_122to12;

PL/SQL procedure successfully completed.
 
AGESPILL_122TO12202
Undocumented

Previously tested in the appropriate versions		 dbms_logmnr_internal.agespill_122to12202;
exec dbms_logmnr_internal.agespill_122to12202;

PL/SQL procedure successfully completed.
 
AGESPILL_12TO122
Undocumented

Previously tested in the appropriate versions		 dbms_logmnr_internal.agespill_12to122;
exec dbms_logmnr_internal.agespill_12to122;

PL/SQL procedure successfully completed.
 
DELETE_TABLE_INCLUSION_RULE
Undocumented dbms_logmnr_internal.delete_table_inclusion_rule(
schema_name    IN VARCHAR2,
table_name     IN VARCHAR2,
container_name IN VARCHAR2);
TBD
 
DELETE_USER_INCLUSION_RULE
Undocumented dbms_logmnr_internal.delete_user_inclusion_rule(
user_name      IN VARCHAR2,
user_type      IN NUMBER,
container_name IN VARCHAR2);
TBD
 
DELETE_XID_INCLUSION_RULE
Undocumented dbms_logmnr_internal.delete_xid_inclusion_rule(
l_xidusn IN NUMBER,
l_xidslt IN NUMBER,
l_xidsqn IN NUMBER);
TBD
 
DICTIONARY_S_LOCK
Undocumented dbms_logmnr_internal.dictionary_s_lock(uid IN NUMBER);
TBD
 
DICTIONARY_S_LOCK_FS
Undocumented dbms_logmnr_internal.dictionary_s_lock_fs(uid IN NUMBER);
TBD
 
DICTIONARY_UNLOCK
Undocumented dbms_logmnr_internal.dictionary_unlock(uid IN NUMBER);
TBD
 
DICTIONARY_X_LOCK
Undocumented dbms_logmnr_internal.dictionary_x_lock(uid IN NUMBER);
TBD
 
DICTIONARY_X_LOCK_FS
Undocumented dbms_logmnr_internal.dictionary_x_lock_fs(uid IN NUMBER);
TBD
 
DO_INT_BUILD
Undocumented

Overload 1		 dbms_logmnr_internal.do_int_build(
build_op            IN     NUMBER,
dictionary_filename IN     VARCHAR2,
dictionary_location IN     VARCHAR2,
bldlogid_initxid    IN OUT VARCHAR2,
lockdownscn         IN OUT NUMBER,
lastlockdownscn        OUT NUMBER,
release_locks       IN     BOOLEAN,
flags               IN     NUMBER,
pdb_names           IN     sys.dbms_utility.uncl_array,
cdb_xid             IN     VARCHAR2);
TBD
Overload 2

Example code from $ORACLE_HOME/
rdbms/admin/utlmmig.sql		 dbms_logmnr_internal.do_int_build(
build_op            IN     NUMBER,
dictionary_filename IN     VARCHAR2,
dictionary_location IN     VARCHAR2,
bldlogid_initxid    IN OUT VARCHAR2,
lockdownscn         IN OUT NUMBER,
release_locks       IN     BOOLEAN);
IF 0 != rowcnt THEN
  -- Logminer may be mining this redo stream, so we must do a special
  -- logminer dictionary build to capture the revised obj# etc.
  sys.dbms_logmnr_internal.DO_INT_BUILD(build_op=>LS_Special_3,
                                        dictionary_filename=>NULL,
                                        dictionary_location=>NULL,
                                        bldlogid_initxid=>LOCbldlogid,
                                        LockDownScn=>LOCLockDownScn,
                                        release_locks=>FALSE);
END IF;
 
DUMP_CKPT_DATA
Undocumented dbms_logmnr_internal.dump_ckpt_data(
sid_in      IN NUMBER,
xidusn_in   IN NUMBER,
xidslt_in   IN NUMBER,
xidsqn_in   IN NUMBER,
startidx_in IN NUMBER,
endidx_in   IN NUMBER);
TBD
 
DUMP_PAGEOUT_DATA
Undocumented dbms_logmnr_internal.dump_pageout_data(
sid_in      IN NUMBER,
xidusn_in   IN NUMBER,
xidslt_in   IN NUMBER,
xidsqn_in   IN NUMBER,
startidx_in IN NUMBER,
endidx_in   IN NUMBER);
TBD
 
DUMP_STREAMS_CKPT_DATA
Undocumented dbms_logmnr_internal.dump_streams_ckpt_data(
sid_in IN NUMBER,
scn_in IN NUMBER);
TBD
 
ENABLE_ONLINE_DDL (new 23ai)
Undocumented dbms_logmnr_internal.enable_online_ddl(
TBD
 
GET_BRANCH_INFO
Undocumented dbms_logmnr_internal.get_branch_info(
l_session_id          IN  NUMBER,
l_db_id               IN  NUMBER,
l_current_reset_scn   IN  NUMBER,
l_current_reset_count IN  NUMBER,
l_session_type        IN  NUMBER,
l_branch_reset_scn    OUT NUMBER,
l_branch_reset_count  OUT NUMBER);
TBD
 
GET_MDH
Undocumented

Overload 1		 dbms_logmnr_internal.get_mdh(
pdb_id    IN NUMBER,
build_scn IN NUMBER)
RETURN NUMBER;
TBD
Overload 2 dbms_logmnr_internal.get_mdh(
pdb_id       IN NUMBER,
build_scnwrp IN NUMBER,
build_scnbas IN NUMBER)
RETURN NUMBER;
TBD
 
GET_MDH_FOR_PDBNAME_SCN
Undocumented dbms_logmnr_internal.get_mdh_for_pdbname_scn(
sessionnum IN NUMBER,
pdbname    IN VARCHAR2,
asofscn    IN NUMBER);
TBD
 
GET_PDBNAME_FOR_MDH
Undocumented dbms_logmnr_internal.get_pdbname_for_mdh(
session_num IN NUMBER,
mdh         IN NUMBER)
RETURN VARCHAR2;
TBD
 
GET_PROCESS_ROLE#
Undocumented dbms_logmnr_internal.get_process_role#(action_type# IN NUMBER) RETURN NUMBER;
SELECT dbms_logmnr_internal.get_process_role#(1);

DBMS_LOGMNR_INTERNAL.GET_PROCESS_ROLE#(1)
-----------------------------------------
                                        2
 
GET_ROOT_GLOBAL_NAME
Returns the global name from CDB$ROOT dbms_logmnr_internal.get_root_global_name RETURN VARCHAR2;
SELECT dbms_logmnr_internal.get_root_global_name;

GET_ROOT_GLOBAL_NAME
---------------------
ASRA23c
 
GET_SESSION_ACTION_TYPE#
Undocumented dbms_logmnr_internal.get_session_action_type#(action_type IN VARCHAR2) RETURN NUMBER;
TBD
 
GET_SESS_OP_LOCK
Undocumented dbms_logmnr_internal.get_sess_op_lock(sid IN NUMBER);
SELECT UNIQUE sid
FROM v$mystat;

 SID
----
 260

exec dbms_logmnr_internal.get_sess_op_lock(260);

PL/SQL procedure successfully completed.
 
GET_SHARED_SETTBL_LOCK
Undocumented dbms_logmnr_internal.get_shared_settbl_lock;
exec dbms_logmnr_internal.get_shared_settbl_lock;

PL/SQL procedure successfully completed.
 
INIT_REPLICATION_METADATA (new 23ai)
Undocumented dbms_logmnr_internal.init_replication_metadata(
TBD
 
INIT_REPLICATION_META_TAB (new 23ai)
Undocumented dbms_logmnr_internal.init_replication_meta_tab(
TBD
 
INIT_REPLICATION_META_UPGRADE (new 23ai)
Undocumented dbms_logmnr_internal.init_replication_meta_upgrade
TBD
 
INJECTCOMMITORROLLBACK
Undocumented dbms_logmnr_internal.injectcommitorrollback(
sid_in IN NUMBER,
xidusn_in IN NUMBER,
xidslt_in IN NUMBER,
xidsqn_in IN NUMBER,
action_in IN NUMBER);
TBD
 
INSERT_INTO_SESSION_ACTION_TBL
Undocumented dbms_logmnr_internal.insert_into_session_action_tbl(
action_name     IN VARCHAR2,
logmnr_session# IN NUMBER,
process_role#   IN NUMBER,
action_type#    IN NUMBER,
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,
attr_1          IN NUMBER,
attr_2          IN NUMBER,
attr_3          IN NUMBER,
spare_1         IN NUMBER,
spare_2         IN NUMBER,
spare_3         IN TIMESTAMP,
spare_4         IN VARCHAR2);
TBD
 
INT_BUILD
Undocumented dbms_logmnr_internal.int_build(
dictionary_filename IN  VARCHAR2,
dictionary_location IN  VARCHAR2,
options             IN  NUMBER,
low_scn             OUT NUMBER);
TBD
 
INT_BUILD_N
Undocumented dbms_logmnr_internal.int_build_n(
pdb_names          IN  sys.dbms_utility.uncl_array,
flags              IN  NUMBER,
first_lockdown_scn OUT NUMBER,
last_lockdown_scn  OUT NUMBER);
TBD
 
IS_SHARED_CAPTURE (new 23ai)
Undocumented dbms_logmnr_internal.is_shared_capture(
TBD
 
KRVIGSSS
Undocumented dbms_logmnr_internal.krvigsss(
session_id     IN  NUMBER,
safe_start_scn OUT NUMBER);
DECLARE
 outVal NUMBER;
BEGIN
  dbms_logmnr_internal.krvigsss(sys_context('USERENV', 'SESSIONID'), outVal);
  dbms_output.put_line(outVal);
END;
/
9223090561878065151

PL/SQL procedure successfully completed.
 
KRVILCJ
Undocumented dbms_logmnr_internal.krvilcj(session_id IN NUMBER);
exec dbms_logmnr_internal.krvilcj(sys_context('USERENV', 'SESSIONID'));
*
ORA-16540: invalid argument
 
KRVIOSTZ (new 23ai)
Undocumented dbms_logmnr_internal.krviostz(
TBD
 
LOGMNR_KRVICL
Undocumented dbms_logmnr_internal.logmnr_krvicl(redo_log_file IN VARCHAR2) RETURN BINARY_INTEGER;
TBD
 
LOGMNR_KRVIFTSI
Undocumented dbms_logmnr_internal.logmnr_krviftsi(
session_id OUT NUMBER,
logmnr_uid OUT NUMBER);
DECLARE
 sesID NUMBER;
 logID NUMBER;
BEGIN
  dbms_logmnr_internal.logmnr_krviftsi(sesID, logID);
  dbms_output.put_line('Session ID: ' || sesID);
  dbms_output.put_line('LogMnr UID: ' || logID);
END;
/
Session ID: 0
LogMnr UID: 0

PL/SQL procedure successfully completed.
 
LOGMNR_KRVIGENQ
Undocumented dbms_logmnr_internal.logmnr_krvigenq(
option_num IN     NUMBER,
sid        IN     NUMBER,
spare1     IN OUT NUMBER,
spare2     IN OUT NUMBER,
spare3     IN OUT NUMBER);
TBD
 
LOGMNR_KRVIISAC
Undocumented dbms_logmnr_internal.logmnr_krviisac(
logmnr_session# IN NUMBER,
process_role#   IN NUMBER);
TBD
 
LOGMNR_KRVILSS
Undocumented dbms_logmnr_internal.logmnr_krvilss(session_id IN NUMBER);
exec dbms_logmnr_internal.logmnr_krvilss(sys_context('USERENV', 'SESSIONID'));

PL/SQL procedure successfully completed.
 
LOGMNR_KRVILT
Undocumented dbms_logmnr_internal.logmnr_krvilt;
exec dbms_logmnr_internal.logmnr_krvilt;

PL/SQL procedure successfully completed.
 
LOGMNR_KRVIRENQ
Undocumented dbms_logmnr_internal.logmnr_krvirenq(
option_num IN     NUMBER,
spare1     IN OUT NUMBER,
spare2     IN OUT NUMBER,
spare3     IN OUT NUMBER);
TBD
 
LOGMNR_KRVIULSS
Undocumented dbms_logmnr_internal.logmnr_krviulss(session_id IN NUMBER);
exec dbms_logmnr_internal.logmnr_krviulss(sys_context('USERENV', 'SESSIONID'));

PL/SQL procedure successfully completed.
 
LOGMNR_KRVIULT
Undocumented dbms_logmnr_internal.logmnr_krviult;
exec dbms_logmnr_internal.logmnr_krviult;

PL/SQL procedure successfully completed.
 
LOGMNR_SESSION_EVOLVE_DIVERGED
Undocumented dbms_logmnr_internal.logmnr_session_evolve_diverged(
l_session_id IN  NUMBER,
l_db_id      IN  NUMBER,
l_diverged   OUT NUMBER);
TBD
 
PMOP_LOCK
Undocumented dbms_logmnr_internal.pmop_lock;
exec dbms_logmnr_internal.pmop_lock;

PL/SQL procedure successfully completed.
 
PMOP_UNLOCK
Undocumented dbms_logmnr_internal.pmop_unlock(
exec dbms_logmnr_internal.pmop_unlock;

PL/SQL procedure successfully completed.
 
PRUNE_STREAMS_CKPT
Undocumented dbms_logmnr_internal.prune_streams_ckpt(
sid_in          IN NUMBER,
startday_in     IN NUMBER,
endday_in       IN NUMBER,
pairsleft_in    IN NUMBER,
req_ckpt_scn_in IN NUMBER);
TBD
 
RELEASE_SESS_OP_LOCK
Undocumented dbms_logmnr_internal.release_sess_op_lock;
exec dbms_logmnr_internal.release_sess_op_lock;

PL/SQL procedure successfully completed.
 
RELEASE_SHARED_SETTBL_LOCK
Undocumented dbms_logmnr_internal.release_shared_settbl_lock;
exec dbms_logmnr_internal.release_shared_settbl_lock;

PL/SQL procedure successfully completed.
 
REPLACE_DICTIONARY_BEGIN
Undocumented dbms_logmnr_internal.replace_dictionary_begin(sid IN NUMBER) RETURN NUMBER;
TBD
 
REPLACE_DICTIONARY_END
Undocumented dbms_logmnr_internal.replace_dictionary_end(sid IN NUMBER);
TBD
 
RESOLVE_TABLE_INCLUSION_RULE
Undocumented dbms_logmnr_internal.resolve_table_inclusion_rule(
l_schema_name IN  VARCHAR2,
l_table_name  IN  VARCHAR2,
l_pdb_name    IN  VARCHAR2,
l_client_info OUT NUMBER);
TBD
 
SET_SESSION_ACTION
Undocumented dbms_logmnr_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
 
SET_SESSION_ACTION2 (new 23ai)
Undocumented dbms_logmnr_internal.set_session_action2(
TBD
 
SET_SESSION_ACTION_HELPER
Undocumented dbms_logmnr_internal.set_session_action_helper(
action_name     IN VARCHAR2,
logmnr_session# IN NUMBER,
process_role#   IN NUMBER,
action_type#    IN NUMBER,
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
 
SET_TABLESPACE
Undocumented dbms_logmnr_internal.set_tablespace(new_tablespace IN VARCHAR2);
exec dbms_logmnr_internal.set_tablespace('UWDATA');

PL/SQL procedure successfully completed.
 
SHARE_PERSISTENT_DICTIONARY
Undocumented dbms_logmnr_internal.share_persistent_dictionary(
sessionid IN NUMBER,
startscn  IN NUMBER,
endscn    IN NUMBER,
starttime IN DATE,
endtime   IN DATE,
options   IN BINARY_INTEGER);
TBD
 
SKIP_OBJ
Undocumented dbms_logmnr_internal.skip_obj(
con_name          IN VARCHAR2,
user_name         IN VARCHAR2,
table_name        IN VARCHAR2,
partition_name    IN VARCHAR2,
subpartition_name IN VARCHAR2,
object_id         IN NUMBER,
object_version    IN NUMBER,
sid_in            IN NUMBER);
TBD
 
SKIP_OBJ_C
Undocumented dbms_logmnr_internal.skip_obj_c(
con_name          IN VARCHAR2,
user_name         IN VARCHAR2,
table_name        IN VARCHAR2,
partition_name    IN VARCHAR2,
subpartition_name IN VARCHAR2,
object_id         IN NUMBER,
object_version    IN NUMBER,
sid_in            IN NUMBER);
TBD
 
SKIP_OBJ_V
Undocumented dbms_logmnr_internal.skip_obj_v(
con_name            IN  VARCHAR2,
user_name           IN  VARCHAR2,
table_name          IN  VARCHAR2,
partition_name      IN  VARCHAR2,
subpartition_name   IN  VARCHAR2,
object_id           IN  NUMBER,
v_con_name          OUT VARCHAR2,
v_user_name         OUT VARCHAR2,
v_table_name        OUT VARCHAR2,
v_partition_name    OUT VARCHAR2,
v_subpartition_name OUT VARCHAR2);
TBD
 
SKIP_RBA
Undocumented dbms_logmnr_internal.skip_rba(
thrd_in        IN NUMBER,
rbaseq_in      IN NUMBER,
rbabno_in      IN NUMBER,
rbabof_in      IN NUMBER,
resetlogscn_in IN NUMBER,
resetlogcnt_in IN NUMBER,
sid_in         IN NUMBER);
TBD
 
SKIP_SCN
Undocumented dbms_logmnr_internal.skip_scn(
thrd_in     IN NUMBER,
startscn_in IN NUMBER,
endscn_in   IN NUMBER,
sid_in      IN NUMBER);
TBD
 
SKIP_XID
Undocumented dbms_logmnr_internal.skip_xid(
pdbuid_in IN NUMBER,
xidusn_in IN NUMBER,
xidslt_in IN NUMBER,
xidsqn_in IN NUMBER,
txnscn_in IN NUMBER,
sid_in    IN NUMBER);
TBD
 
TRACEREDOLOGS
Undocumented dbms_logmnr_internal.traceredologs(
session_num IN NUMBER,
upstream    IN NUMBER,
branchscn   IN NUMBER,
startscn    IN NUMBER,
endscn      IN NUMBER);
TBD
 
TRACE_FOREIGN_LOG_INFO
Undocumented dbms_logmnr_internal.trace_foreign_log_info(
l_which_file IN NUMBER,
session_id   IN NUMBER,
target_scn   IN NUMBER);
TBD
 
TRACE_LOCAL_LOG_INFO
Undocumented dbms_logmnr_internal.trace_local_log_info(
l_which_file IN NUMBER,
target_scn   IN NUMBER);
TBD
 
TRACE_LOCAL_XID
Undocumented dbms_logmnr_internal.trace_local_xid(l_which_file IN NUMBER);
TBD
 
TRACE_TABLE_LOCAL_DICT
Undocumented dbms_logmnr_internal.trace_table_local_dict(
l_which_file IN NUMBER,
table_owner  IN VARCHAR2,
table_name   IN VARCHAR2,
pdb_name     IN VARCHAR2);
TBD
 
UNSET_SESSION_ACTION
Undocumented dbms_logmnr_internal.unset_session_action(
action_name     IN VARCHAR2,
logmnr_session# IN NUMBER,
force           IN BOOLEAN);
TBD
 
UNSET_SESSION_ACTION_HELPER
Undocumented dbms_logmnr_internal.unset_session_action_helper(
action_name     IN  VARCHAR2,
logmnr_session# IN  NUMBER,
force           IN  BOOLEAN,
process_role#   OUT NUMBER);
TBD
 
UNSKIP_OBJ
Undocumented dbms_logmnr_internal.unskip_obj(
con_name          IN VARCHAR2,
user_name         IN VARCHAR2,
table_name        IN VARCHAR2,
partition_name    IN VARCHAR2,
subpartition_name IN VARCHAR2,
object_id         IN NUMBER,
object_version    IN NUMBER,
sid_in            IN NUMBER);
TBD
 
UNSKIP_OBJ_C
Undocumented dbms_logmnr_internal.unskip_obj_c(
con_name          IN VARCHAR2,
user_name         IN VARCHAR2,
table_name        IN VARCHAR2,
partition_name    IN VARCHAR2,
subpartition_name IN VARCHAR2,
object_id         IN NUMBER,
object_version    IN NUMBER,
sid_in            IN NUMBER);
TBD
 
UNSKIP_RBA
Undocumented dbms_logmnr_internal.unskip_rba(
thrd_in        IN NUMBER,
rbaseq_in      IN NUMBER,
rbabno_in      IN NUMBER,
rbabof_in      IN NUMBER,
resetlogscn_in IN NUMBER,
resetlogcnt_in IN NUMBER,
sid_in         IN NUMBER);
TBD
 
UNSKIP_SCN
Undocumented dbms_logmnr_internal.unskip_scn(
thrd_in     IN NUMBER,
startscn_in IN NUMBER,
endscn_in   IN NUMBER,
sid_in      IN NUMBER);
TBD
 
UNSKIP_XID
Undocumented dbms_logmnr_internal.unskip_xid(
pdbuid_in IN NUMBER,
xidusn_in IN NUMBER,
xidslt_in IN NUMBER,
xidsqn_in IN NUMBER,
sid_in    IN NUMBER);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_CAPTURE_ADM_INTERNAL
DBMS_LOGMNR
DBMS_LOGMNR_D
DBMS_LOGMNR_LOGREP_DICT
DBMS_LOGMNR_SESSION_INT
LOGMNR_DICT_CACHE
LOGMNR_EM_SUPPORT
What's New In 21c
What's New In 26ai

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