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

As demonstrated below this package's functionality is protected by 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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx