DBA Data[Home] [Help]

PACKAGE: SYS.DBMS_CACHEUTIL

Source


1 PACKAGE dbms_cacheutil AS
2 
3 -- DE-HEAD  <- tell SED where to cut when generating fixed package
4 
5 --*****************************************************************************
6 -- Package Public Exceptions
7 --*****************************************************************************
8 
9 --*****************************************************************************
10 -- Package Public Types
11 --*****************************************************************************
12 -------------------------------------------------------------------------------
13 --
14 -- PROCEDURE     grab_affinity
15 --
16 -- Description:  try to grab object affinity in RAC environment
17 --
18 -- Parameters:
19 --
20 -------------------------------------------------------------------------------
21 PROCEDURE grab_affinity( schema     IN varchar2,
22                          obj        IN varchar2,
23                          partition  IN varchar2 := null,
24                          grab_index IN boolean := TRUE,
25                          active_drm IN boolean := FALSE);
26 
27 -------------------------------------------------------------------------------
28 --
29 -- PROCEDURE     grab_readmostly
30 --
31 -- Description:  try to grab object readmostly in RAC environment
32 --
33 -- Parameters:
34 --
35 -------------------------------------------------------------------------------
36 PROCEDURE grab_readmostly( schema     IN varchar2,
37                            obj        IN varchar2,
38                            partition  IN varchar2 := null,
39                            grab_index IN boolean := TRUE);
40 
41 -------------------------------------------------------------------------------
42 --
43 -- PROCEDURE     dissolve_affinity
44 --
45 -- Description:  try to dissolve object affinity in RAC environment
46 --
47 -- Parameters:
48 --
49 -------------------------------------------------------------------------------
50 PROCEDURE dissolve_affinity( schema         IN varchar2,
51                              obj            IN varchar2,
52                              partition      IN varchar2 := null,
53                              dissolve_index IN boolean := TRUE,
54                              active_drm     IN boolean := FALSE);
55 
56 -------------------------------------------------------------------------------
57 --
58 -- PROCEDURE     dissolve_readmostly
59 --
60 -- Description:  try to dissolve object readmostly in RAC environment
61 --
62 -- Parameters:
63 --
64 -------------------------------------------------------------------------------
65 PROCEDURE dissolve_readmostly( schema         IN varchar2,
66                                obj            IN varchar2,
67                                partition      IN varchar2 := null,
68                                dissolve_index IN boolean := TRUE);
69 
70 -------------------------------------------------------------------------------
71 --
72 -- PROCEDURE     list_readmostly
73 --
74 -- Description:  list objects have readmostly property set
75 --
76 -- Parameters:
77 --
78 -------------------------------------------------------------------------------
79 PROCEDURE list_readmostly;
80 
81 -------------------------------------------------------------------------------
82 --
83 -- PROCEDURE     object_downconvert
84 --
85 -- Description:  try to downconvert object locks to shared mode in RAC
86 --
87 -- Parameters:
88 --
89 -------------------------------------------------------------------------------
90 PROCEDURE object_downconvert( schema            IN varchar2,
91                               obj               IN varchar2,
92                               partition         IN varchar2 := null,
93                               downconvert_index IN boolean := TRUE);
94 
95 
96 END;
97 
98 -- CUT_HERE    <- tell sed where to chop off the rest