Oracle | DBMS_LOGMNR_SESSION

Oracle DBMS_LOGMNR_SESSION_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 Log Miner Session Level Internal Utilities

AUTHID DEFINER

Dependencies

DBA_LOGMNR_SESSION	DBMS_SHARED_CAPTURE_IVK	LOGMNR_PARAMETER$
DBA_SCHEDULER_JOBS	DBMS_SQL	LOGMNR_PDB_INFO$
DBMS_CAPTURE_PROCESS	DBMS_SYSTEM	LOGMNR_REMOTE_SESSION$
DBMS_LOCK	DUAL	LOGMNR_RESTART_CKPT$
DBMS_LOGMNR_INTERNAL	GV$LOGMNR_SESSION	LOGMNR_SEQ$
DBMS_LOGMNR_LIB	LOGMNRSC_REMOTE_SESSION	LOGMNR_SESSION$
DBMS_LOGREP_UTIL	LOGMNR_DICT_CACHE	LOGMNR_UID$
DBMS_LOGSTDBY	LOGMNR_DID$	STREAMS$_CAPTURE_PROCESS
DBMS_OUTPUT	LOGMNR_KRVRDLUID3	V$ARCHIVED_LOG
DBMS_SCHEDULER	LOGMNR_LOG$	V$STANDBY_LOG

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Direct access to this package is prevented by an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/prvtlmss.plb
{ORACLE_HOME}/rdbms/admin/prvtlmsb.plb

Subprograms

ABORT_PURGE	CREATE_SESSION	PREPARE_SCN_RANGE
ADD_LOG_FILE	DESTROY_REMOTE_CONTEXT_LINK	PROCESS_PURGE
ATTACH_SESSION	DESTROY_REMOTE_LINK	PURGE_SESSION
CLONE_CONTEXT	DESTROY_SESSION	RELEASE_SCN_RANGE
CLONE_CONTEXT2	DETACH_SESSION	REMOVE_LOG_FILE
COLUMN_PRESENT	MINE_VALUE	SET_DICT_ATTR
CREATE_REMOTE_CONTEXT_LINK	MISSING_LOG	SET_SESSION_PARAMS
CREATE_REMOTE_LINK	MOVE_PDB_CAPTURE

ABORT_PURGE

Undocumented dbms_logmnr_session_int.abort_purge(session_id IN NUMBER);

Can not be executed directly due to an ACCESSIBLE BY clause

ADD_LOG_FILE

Undocumented dbms_logmnr_session_int.add_log_file( session_id IN NUMBER, logfile_name IN VARCHAR2);

Can not be executed directly due to an ACCESSIBLE BY clause

ATTACH_SESSION

Undocumented dbms_logmnr_session_int.attach_session(session_id IN NUMBER);

exec dbms_logmnr_session_int.attach_session(224);

           *

      ORA-01031: insufficient privileges

CLONE_CONTEXT

Undocumented dbms_logmnr_session_int.clone_context( session_id IN NUMBER, new_session_name IN VARCHAR2, scn IN NUMBER, clone_flags IN NUMBER) RETURN NUMBER;

Can not be executed directly due to an ACCESSIBLE BY clause

CLONE_CONTEXT2

Undocumented dbms_logmnr_session_int.clone_context2( session_id IN NUMBER, new_session_name IN VARCHAR2, scn IN NUMBER, clone_flags IN NUMBER) RETURN NUMBER;

Can not be executed directly due to an ACCESSIBLE BY clause

COLUMN_PRESENT

Undocumented dbms_logmnr_session_int.column_present( sql_redo_undo IN NUMBER, column_name IN VARCHAR2) RETURN BINARY_INTEGER;

Can not be executed directly due to an ACCESSIBLE BY clause

CREATE_REMOTE_CONTEXT_LINK (new 23ai)

Undocumented dbms_logmnr_session_int.create_remote_context_link( remote_session_id IN NUMBER, link_session_name IN VARCHAR2, link_flags IN NUMBER, db_id IN NUMBER, resetlogs_change# IN NUMBER, reset_timestamp IN NUMBER);

TBD

CREATE_REMOTE_LINK (new 23ai)

Undocumented dbms_logmnr_session_int.create_remote_link( db_id_in IN NUMBER, remote_session_id IN NUMBER);

TBD

CREATE_SESSION

Undocumented dbms_logmnr_session_int.create_session( client_id IN NUMBER, db_id IN NUMBER, reset_scn IN NUMBER, reset_timestamp IN NUMBER, flags IN NUMBER, flags2 IN NUMBER, global_dbname IN VARCHAR2, session_name IN VARCHAR2, session_id OUT NUMBER);

Can not be executed directly due to an ACCESSIBLE BY clause

DESTROY_REMOTE_CONTEXT_LINK (new 23ai)

Undocumented

Does not generate an exception if the remote link does not exist. dbms_logmnr_session_int.destroy_remote_context_link(session_id IN NUMBER);

exec dbms_logmnr_session_int.destroy_remote_context_link(300);

      

      PL/SQL procedures successfully completed.

DESTROY_REMOTE_LINK (new 23ai)

Undocumented dbms_logmnr_session_int.destroy_remote_link(db_id_in IN NUMBER);

TBD

DESTROY_SESSION

Undocumented dbms_logmnr_session_int.destroy_session(session_id IN NUMBER);

exec dbms_logmnr_session_int.destroy_session(224);

           *

      ORA-01031: insufficient privileges

DETACH_SESSION

Undocumented dbms_logmnr_session_int.detach_session(session_id IN NUMBER);

exec dbms_logmnr_session_int.detach_session(224);

           *

      ORA-01031: insufficient privileges

MINE_VALUE

Undocumented dbms_logmnr_session_int.mine_value( sql_redo_undo IN NUMBER, column_name IN VARCHAR2) RETURN VARCHAR2;

Can not be executed directly due to an ACCESSIBLE BY clause

MISSING_LOG

Undocumented dbms_logmnr_session_int.missing_log( name IN VARCHAR2, dblink IN VARCHAR2, debug IN BOOLEAN);

Can not be executed directly due to an ACCESSIBLE BY clause

MOVE_PDB_CAPTURE (new 23ai)

Undocumented dbms_logmnr_session_int.move_pdb_capture( pdb_name IN VARCHAR2, donor_session_num IN NUMBER, acquirer_session_num IN NUMBER);

TBD

PREPARE_SCN_RANGE

Undocumented dbms_logmnr_session_int.prepare_scn_range( session_id IN NUMBER, start_scn IN NUMBER, end_scn IN NUMBER);

Can not be executed directly due to an ACCESSIBLE BY clause

PROCESS_PURGE

Undocumented dbms_logmnr_session_int.process_purge( session_id IN NUMBER, purge_scn IN NUMBER, batch_row_cnt IN NUMBER, flags IN NUMBER);

Can not be executed directly due to an ACCESSIBLE BY clause

PURGE_SESSION

Undocumented dbms_logmnr_session_int.purge_session( session_id IN NUMBER, scn IN NUMBER, batch_rows IN NUMBER, silent_error IN BOOLEAN);

Can not be executed directly due to an ACCESSIBLE BY clause

RELEASE_SCN_RANGE

Undocumented dbms_logmnr_session_int.release_scn_range( session_id IN NUMBER, end_scn IN NUMBER);

Can not be executed directly due to an ACCESSIBLE BY clause

REMOVE_LOG_FILE

Undocumented dbms_logmnr_session_int.remove_log_file( session_id IN NUMBER, logfile_name IN VARCHAR2);

Can not be executed directly due to an ACCESSIBLE BY clause

SET_DICT_ATTR

Undocumented dbms_logmnr_session_int.set_dict_attr( session_id IN NUMBER, dict_attr IN NUMBER);

Can not be executed directly due to an ACCESSIBLE BY clause

SET_SESSION_PARAMS

Undocumented dbms_logmnr_session_int.set_session_params( session_id IN NUMBER, num_process IN NUMBER, memory_size IN NUMBER, max_log_lookback IN NUMBER);

Can not be executed directly due to an ACCESSIBLE BY clause