Oracle | DBMS_LOGMNR_SESSION

Oracle DBMS_LOGMNR_SESSION_INT Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Log Miner Session Level utilities

AUTHID DEFINER

Dependencies

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

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

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

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

Subprograms

ABORT_PURGE	CREATE_SESSION	PROCESS_PURGE
ADD_LOG_FILE	DESTROY_SESSION	PURGE_SESSION
ATTACH_SESSION	DETACH_SESSION	RELEASE_SCN_RANGE
CLONE_CONTEXT	MINE_VALUE	REMOVE_LOG_FILE
CLONE_CONTEXT2	MISSING_LOG	SET_DICT_ATTR
COLUMN_PRESENT	PREPARE_SCN_RANGE	SET_SESSION_PARAMS

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);

      BEGIN dbms_logmnr_session_int.attach_session(224); END;

      *

      ERROR at line 1:

      ORA-01031: insufficient privileges

      ORA-06512: at "SYS.DBMS_LOGMNR_SESSION_INT", line 34

      ORA-06512: at line 1

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_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_SESSION

Undocumented dbms_logmnr_session_int.destroy_session(session_id IN NUMBER);

exec dbms_logmnr_session_int.destroy_session(224);

      BEGIN dbms_logmnr_session_int.destroy_session(224); END;

      *

      ERROR at line 1:

      ORA-01031: insufficient privileges

      ORA-06512: at "SYS.DBMS_LOGMNR_SESSION_INT", line 102

      ORA-06512: at line 1

DETACH_SESSION

Undocumented dbms_logmnr_session_int.detach_session(session_id IN NUMBER);

exec dbms_logmnr_session_int.detach_session(224);

      BEGIN dbms_logmnr_session_int.detach_session(224); 
      END;

      *

      ERROR at line 1:

      ORA-01031: insufficient privileges

      ORA-06512: at "SYS.DBMS_LOGMNR_SESSION_INT", line 93

      ORA-06512: at line 1

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

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