Oracle DBMS_LOGMNR_SESSION_INT
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_LOGMNR
DBMS_LOGMNR_D
DBMS_LOGMNR_LOGREP_DICT
What's New In 19c
What's New In 20c-21c

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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx