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;