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.
dbms_logmnr_internal.advance_read_scn(sid_in IN NUMBER);
exec dbms_logmnr_internal.advance_read_scn(sys_context('USERENV', 'SESSIONID'));
BEGIN dbms_logmnr_internal.advance_read_scn(sys_context('USERENV', 'SESSIONID')); END;
*
ERROR at line 1:
ORA-01309: invalid session
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 262
ORA-06512: at line 1
dbms_logmnr_internal.do_int_build(
build_op IN NUMBER,
dictionary_filename IN VARCHAR2,
dictionary_location IN VARCHAR2,
bldlogid_initxid IN OUT VARCHAR2,
lockdownscn IN OUT NUMBER,
lastlockdownscn OUT NUMBER,
release_locks IN BOOLEAN,
flags IN NUMBER,
pdb_names IN sys.dbms_utility.uncl_array,
cdb_xid IN VARCHAR2);
TBD
Overload 2
Example code from $ORACLE_HOME/
rdbms/admin/utlmmig.sql
dbms_logmnr_internal.do_int_build(
build_op IN NUMBER,
dictionary_filename IN VARCHAR2,
dictionary_location IN VARCHAR2,
bldlogid_initxid IN OUT VARCHAR2,
lockdownscn IN OUT NUMBER,
release_locks IN BOOLEAN);
IF 0 != rowcnt THEN
-- Logminer may be mining this redo stream, so we must do a special
-- logminer dictionary build to capture the revised obj# etc.
sys.dbms_logmnr_internal.DO_INT_BUILD(build_op=>LS_Special_3,
dictionary_filename=>NULL,
dictionary_location=>NULL,
bldlogid_initxid=>LOCbldlogid,
LockDownScn=>LOCLockDownScn,
release_locks=>FALSE);
END IF;
dbms_logmnr_internal.dump_ckpt_data(
sid_in IN NUMBER,
xidusn_in IN NUMBER,
xidslt_in IN NUMBER,
xidsqn_in IN NUMBER,
startidx_in IN NUMBER,
endidx_in IN NUMBER);
dbms_logmnr_internal.dump_pageout_data(
sid_in IN NUMBER,
xidusn_in IN NUMBER,
xidslt_in IN NUMBER,
xidsqn_in IN NUMBER,
startidx_in IN NUMBER,
endidx_in IN NUMBER);
dbms_logmnr_internal.get_branch_info(
l_session_id IN NUMBER,
l_db_id IN NUMBER,
l_current_reset_scn IN NUMBER,
l_current_reset_count IN NUMBER,
l_session_type IN NUMBER,
l_branch_reset_scn OUT NUMBER,
l_branch_reset_count OUT NUMBER);
dbms_logmnr_internal.insert_into_session_action_tbl(
action_name IN VARCHAR2,
logmnr_session# IN NUMBER,
process_role# IN NUMBER,
action_type# IN NUMBER,
action_options IN NUMBER,
xid_usn IN NUMBER,
xid_slt IN NUMBER,
xid_sqn IN NUMBER,
thread_# IN NUMBER,
start_scn IN NUMBER,
start_sub_scn IN NUMBER,
end_scn IN NUMBER,
end_sub_scn IN NUMBER,
rba_sqn IN NUMBER,
rba_blk IN NUMBER,
rba_byte IN NUMBER,
session_# IN NUMBER,
obj_# IN NUMBER,
attr_1 IN NUMBER,
attr_2 IN NUMBER,
attr_3 IN NUMBER,
spare_1 IN NUMBER,
spare_2 IN NUMBER,
spare_3 IN TIMESTAMP,
spare_4 IN VARCHAR2);
dbms_logmnr_internal.int_build_n(
pdb_names IN sys.dbms_utility.uncl_array,
flags IN NUMBER,
first_lockdown_scn OUT NUMBER,
last_lockdown_scn OUT NUMBER);
dbms_logmnr_internal.krvilcj(session_id IN NUMBER);
exec dbms_logmnr_internal.krvilcj(sys_context('USERENV', 'SESSIONID'));
BEGIN dbms_logmnr_internal.krvilcj(sys_context('USERENV', 'SESSIONID')); END;
*
ERROR at line 1:
ORA-16540: invalid argument
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 11667
ORA-06512: at line 1
dbms_logmnr_internal.prune_streams_ckpt(
sid_in IN NUMBER,
startday_in IN NUMBER,
endday_in IN NUMBER,
pairsleft_in IN NUMBER,
req_ckpt_scn_in IN NUMBER);
dbms_logmnr_internal.resolve_table_inclusion_rule(
l_schema_name IN VARCHAR2,
l_table_name IN VARCHAR2,
l_pdb_name IN VARCHAR2,
l_client_info OUT NUMBER);
dbms_logmnr_internal.set_session_action(
action_name IN VARCHAR2,
logmnr_session# IN NUMBER,
action_type IN VARCHAR2,
action_options IN NUMBER,
xid_usn IN NUMBER,
xid_slt IN NUMBER,
xid_sqn IN NUMBER,
thread# IN NUMBER,
start_scn IN NUMBER,
start_sub_scn IN NUMBER,
end_scn IN NUMBER,
end_sub_scn IN NUMBER,
rba_sqn IN NUMBER,
rba_blk IN NUMBER,
rba_byte IN NUMBER,
session# IN NUMBER,
obj# IN NUMBER,
attr1 IN NUMBER,
attr2 IN NUMBER,
attr3 IN NUMBER);
dbms_logmnr_internal.set_session_action_helper(
action_name IN VARCHAR2,
logmnr_session# IN NUMBER,
process_role# IN NUMBER,
action_type# IN NUMBER,
action_options IN NUMBER,
xid_usn IN NUMBER,
xid_slt IN NUMBER,
xid_sqn IN NUMBER,
thread# IN NUMBER,
start_scn IN NUMBER,
start_sub_scn IN NUMBER,
end_scn IN NUMBER,
end_sub_scn IN NUMBER,
rba_sqn IN NUMBER,
rba_blk IN NUMBER,
rba_byte IN NUMBER,
session# IN NUMBER,
obj# IN NUMBER,
attr1 IN NUMBER,
attr2 IN NUMBER,
attr3 IN NUMBER);
dbms_logmnr_internal.share_persistent_dictionary(
sessionid IN NUMBER,
startscn IN NUMBER,
endscn IN NUMBER,
starttime IN DATE,
endtime IN DATE,
options IN BINARY_INTEGER);
dbms_logmnr_internal.skip_obj(
con_name IN VARCHAR2,
user_name IN VARCHAR2,
table_name IN VARCHAR2,
partition_name IN VARCHAR2,
subpartition_name IN VARCHAR2,
object_id IN NUMBER,
object_version IN NUMBER,
sid_in IN NUMBER);
dbms_logmnr_internal.skip_obj_c(
con_name IN VARCHAR2,
user_name IN VARCHAR2,
table_name IN VARCHAR2,
partition_name IN VARCHAR2,
subpartition_name IN VARCHAR2,
object_id IN NUMBER,
object_version IN NUMBER,
sid_in IN NUMBER);
dbms_logmnr_internal.skip_obj_v(
con_name IN VARCHAR2,
user_name IN VARCHAR2,
table_name IN VARCHAR2,
partition_name IN VARCHAR2,
subpartition_name IN VARCHAR2,
object_id IN NUMBER,
v_con_name OUT VARCHAR2,
v_user_name OUT VARCHAR2,
v_table_name OUT VARCHAR2,
v_partition_name OUT VARCHAR2,
v_subpartition_name OUT VARCHAR2);
dbms_logmnr_internal.skip_rba(
thrd_in IN NUMBER,
rbaseq_in IN NUMBER,
rbabno_in IN NUMBER,
rbabof_in IN NUMBER,
resetlogscn_in IN NUMBER,
resetlogcnt_in IN NUMBER,
sid_in IN NUMBER);
dbms_logmnr_internal.skip_xid(
pdbuid_in IN NUMBER,
xidusn_in IN NUMBER,
xidslt_in IN NUMBER,
xidsqn_in IN NUMBER,
txnscn_in IN NUMBER,
sid_in IN NUMBER);
dbms_logmnr_internal.unskip_obj(
con_name IN VARCHAR2,
user_name IN VARCHAR2,
table_name IN VARCHAR2,
partition_name IN VARCHAR2,
subpartition_name IN VARCHAR2,
object_id IN NUMBER,
object_version IN NUMBER,
sid_in IN NUMBER);
dbms_logmnr_internal.unskip_obj_c(
con_name IN VARCHAR2,
user_name IN VARCHAR2,
table_name IN VARCHAR2,
partition_name IN VARCHAR2,
subpartition_name IN VARCHAR2,
object_id IN NUMBER,
object_version IN NUMBER,
sid_in IN NUMBER);
dbms_logmnr_internal.unskip_rba(
thrd_in IN NUMBER,
rbaseq_in IN NUMBER,
rbabno_in IN NUMBER,
rbabof_in IN NUMBER,
resetlogscn_in IN NUMBER,
resetlogcnt_in IN NUMBER,
sid_in IN NUMBER);