[Home] [Help]
PACKAGE: CTXSYS.DRIOPT
Source
1 package driopt as
2
3 p_inv_count number;
4
5 LOCK_WAIT constant number := null;
6 LOCK_NOWAIT constant number := 0;
7 IGNORE_ERRORS constant boolean := TRUE;
8
9 /*------------------------------ lock_opt_AF-------------------------------*/
10
11 procedure lock_opt_AF(
12 cid in number,
13 timeout in number,
14 retval out number
15 );
16
17 /*------------------------------ lock_opt --------------------------------*/
18
19 procedure lock_opt(
20 cid in number,
21 pid in number,
22 timeout in number
23 );
24 function lock_opt_ret(
25 cid in number,
26 pid in number,
27 timeout in number
28 ) return number;
29
30 /*------------------------- lock_opt_rebuild ------------------------------*/
31 /* Added for bug 5079472 */
32
33 procedure lock_opt_rebuild(
34 cid in number,
35 pid in number,
36 lock_mode in number,
37 timeout in number,
38 release_on_commit in boolean default FALSE
39 );
40
41 /*------------------------- lock_opt_all_part ----------------------------*/
42 /* NOTE: gets multiple locks. If fails, it's up to calling procedure to */
43 /* release any locks it may have gotten */
44 procedure lock_opt_all_part(
45 cid in number
46 );
47
48 /*--------------------------- lock_opt_mvdata ---------------------------*/
49 /* lock optimize mvdata against commit callback of update_mvdata
50 * releases lock on commit */
51 procedure lock_opt_mvdata(
52 cid in number,
53 pid in number
54 );
55
56 /*----------------------------- unlock_opt ------------------------------*/
57
58 procedure unlock_opt(
59 ignore_errors in boolean default false
60 );
61
62 /*----------------------------- unlock_opt_AF-----------------------------*/
63
64 procedure unlock_opt_AF(
65 ignore_errors in boolean default false
66 );
67
68 /*------------------------- unlock_opt_rebuild ----------------------------*/
69 /* Added for bug 5079472 */
70
71 procedure unlock_opt_rebuild(
72 ignore_errors in boolean default false
73 );
74
75 /*------------------------ unlock_opt_all_part ---------------------------*/
76
77 procedure unlock_opt_all_part(
78 ignore_errors in boolean default false
79 );
80
81 /*---------------------------- start_timer ---------------------------*/
82 /*
83 NAME
84 start_timer
85
86 DESCRIPTION
87 start the optimization timer
88 */
89 procedure start_timer;
90
91 /*---------------------------- get_timer ------------------------------*/
92 /*
93 NAME
94 get_timer
95
96 DESCRIPTION
97 get the amount of minutes since last start_timer call
98 */
99 function get_timer return number;
100
101 /*---------------------------- get_state ------------------------------*/
102 /*
103 NAME
104 get_state
105
106 DESCRIPTION
107 get the current state of optimization
108 */
109 procedure get_state(
110 p_idx_id in number
111 , p_ixp_id in number
112 , p_opt_token out varchar2
113 , p_opt_type out number
114 );
115
116 /*---------------------------- set_state ------------------------------*/
117 /*
118 NAME
119 set_state
120
121 DESCRIPTION
122 set the new state of optimization for next time
123 */
124 procedure set_state(
125 p_idx_id in number
126 , p_ixp_id in number
127 , p_opt_token in varchar2
128 , p_opt_type in number
129 );
130
131 /*--------------------------- set_ddl_lock_timeout -------------------------*/
132 /* set_ddl_lock_timeout parameter for this session */
133 procedure set_ddl_lock_timeout(
134 p_timeout in number default 1000000
135 );
136
137 /*--------------------------- get_ddl_lock_timeout -------------------------*/
138 /* get_ddl_lock_timeout parameter for this session */
139 function get_ddl_lock_timeout
140 return number;
141
142 /*---------------------- IndexOptimizeRebuild_Verify ------------------------*/
143 PROCEDURE IndexOptimizeRebuild_Verify(
144 idx in dr_def.idx_rec,
145 ixp in dr_def.ixp_rec,
146 base_itab_obj in varchar2,
147 base_xidx_obj in varchar2,
148 char_semantics out varchar2,
149 ipart out varchar2
150 ) ;
151
152 /*------------------------- getSegmentInfo ---------------------------------*/
153 procedure getSegmentInfo(
154 idxowner in varchar2,
155 base_itab_obj in varchar2,
156 blocks out number,
157 bytes out number
158 );
159
160
161 end driopt;