1 PACKAGE dbms_logmnr_session as
2
3 -----------------------------------
4 -- SUBTYPES and related CONSTANTS
5 --
6
7 -- constants for create_session
8 --
9 CREATE_FLAG_TRANSIENT_SESSION CONSTANT NUMBER := 1;
10 CREATE_FLAG_UNCOMMITTED_DATA CONSTANT NUMBER := 8;
11 CREATE_FLAG_WAIT_FOR_LOG CONSTANT NUMBER := 16;
12 CREATE_FLAG_SKIP_CORRUPTION CONSTANT NUMBER := 32;
13 CREATE_FLAG_ALLOW_MISSING_LOG CONSTANT NUMBER := 64;
14 CREATE_FLAG_ALLOW_MULTIPLE CONSTANT NUMBER := 128;
15 CREATE_FLAG_IGNORE_CONSISTENCY CONSTANT NUMBER := 256;
16 CREATE_FLAG_NO_DICT_DDL_TRACK CONSTANT NUMBER := 1024;
17 CREATE_FLAG_AUTO_ADD_ARCHIVED CONSTANT NUMBER := 65536;
18 CREATE_FLAG_AUTO_ADD_ONLINE CONSTANT NUMBER := 131072;
19 CREATE_FLAG_DISCARD_ROLLBACK CONSTANT NUMBER := 16777216;
20 CREATE_FLAG_DISCARD_INTERNAL CONSTANT NUMBER := 33554432;
21 CREATE_FLAG_FILTER_ALL CONSTANT NUMBER := 67108864;
22 CREATE_FLAG_ENABLE_CKPT CONSTANT NUMBER := 268435456;
23 CREATE_FLAG_RECORD_GLOBALNAME CONSTANT NUMBER := 1073741824;
24
25 -- constants for set_dict_attr
26 --
27 DICT_FLAG_GENERATE_HEX CONSTANT NUMBER := 0;
28 DICT_FLAG_REDO_LOGS CONSTANT NUMBER := 1;
29 DICT_FLAG_ONLINE_CATALOG CONSTANT NUMBER := 2;
30 DICT_FLAG_FLAT_FILE CONSTANT NUMBER := 3;
31
32
33 -------------
34 -- PROCEDURES
35 --
36
37 PROCEDURE create_session(
38 client_id IN NUMBER default 0,
39 db_id IN NUMBER default 0,
40 reset_scn IN NUMBER default 0,
41 reset_timestamp IN NUMBER default 0,
42 flags IN NUMBER default 0,
43 global_dbname IN VARCHAR2 default '',
44 session_name IN VARCHAR2,
45 session_id OUT NUMBER);
46
47
48 PROCEDURE attach_session(
49 session_id IN NUMBER default 0);
50
51
52 PROCEDURE set_session_params(
53 session_id IN NUMBER default 0,
54 num_process IN NUMBER default 0,
55 memory_size IN NUMBER default 10,
56 max_log_lookback IN NUMBER default 4294967295);
57
58
59 PROCEDURE set_dict_attr(
60 session_id IN NUMBER default 0,
61 dict_attr IN NUMBER default DICT_FLAG_REDO_LOGS,
62 dict_file IN VARCHAR2 default '');
63
64
65 PROCEDURE prepare_scn_range(
66 session_id IN NUMBER default 0,
67 start_scn IN NUMBER default 0,
68 end_scn IN NUMBER default 0);
69
70
71 PROCEDURE release_scn_range(
72 session_id IN NUMBER default 0,
73 end_scn IN NUMBER default 0);
74
75
76 PROCEDURE detach_session(
77 session_id IN NUMBER default 0);
78
79
80 PROCEDURE destroy_session(
81 session_id IN NUMBER default 0);
82
83
84 PROCEDURE add_log_file(
85 session_id IN NUMBER default 0,
86 logfile_name IN VARCHAR2 default '');
87
88
89 PROCEDURE remove_log_file(
90 session_id IN NUMBER default 0,
91 logfile_name IN VARCHAR2 default '');
92
93
94 FUNCTION mine_value(
95 sql_redo_undo IN NUMBER,
96 column_name IN VARCHAR2 default '') RETURN VARCHAR2;
97
98
99 FUNCTION column_present(
100 sql_redo_undo IN NUMBER,
101 column_name IN VARCHAR2 default '') RETURN BINARY_INTEGER;
102
103
104 /******************************************************************************
105 *
106 * NAME
107 * clone_context
108 *
109 * DESCRIPTION
110 * Clone an existing LogMiner persistent context. The specified persistent
111 * context is duplicated and its session# is returned. The new context
112 * shares the dictionary with the parent context. If the specified SCN is
113 * zero (default) or there are no valid checkpoints at or below it then the
114 * new context is created with start_scn of the parent context.
115 *
116 * With the exception of session# and session_name the new context inherits
117 * all attributes of the parent context and may itself be subsequently
118 * cloned. The shared dictionary is kept intact as long as there are
119 * sharers.
120 *
121 * PARAMETERS
122 * session_id IN: The session# of context to be duplicated.
123 * new_session_name IN: The unique name to be given to the cloned session.
124 * scn IN: SCN at or above a checkpoint where the new context is
125 * to be started. By default, the new context starts at
126 * the start_scn of the parent context.
127 * clone_flags IN : Flag : 0 refers to clone_all
128 * 1 refers to clone_dictionary_only
129 * TRANSACTION
130 * Autonomous
131 *
132 * ERRORS
133 * Error conditions are raised.
134 */
135 FUNCTION clone_context(
136 session_id IN NUMBER,
137 new_session_name IN VARCHAR2,
138 scn IN NUMBER default 0,
139 clone_flags IN NUMBER default 0) RETURN NUMBER;
140
141 /******************************************************************************
142 *
143 * NAME
144 * purge_session
145 *
146 * DESCRIPTION
147 * PARAMETERS
148 * session_id IN: The session# of context to be purged.
149 * scn IN: SCN below which all checkpoints and log entries
150 * are to be purged.
151 * TRANSACTION
152 * Autonomous
153 *
154 * ERRORS
155 * Error conditions are raised.
156 */
157 PROCEDURE purge_session(
158 session_id IN NUMBER default 0,
159 scn IN NUMBER default 0,
160 batch_rows IN NUMBER default 100000);
161
162 END dbms_logmnr_session;