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 is now availble. If you haven't you downloaded already: Why?

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