Menu
What is the difference between default & manual in the following code snippet? (Oracle 11g)
alter table t_a result_cache (mode default);
and
alter table t_a result_cache (mode manual);
Image:
The user_tables.result_cache column has three possible values (Source E40402-18 Oracle Reference 11g)
257
The Protected access specifier is visible within the same package and also visible in the subclass whereas the Default is a package level access specifier and it can be visible in the same package.
Default : When no access modifier is specified, it is treated as default modifier. Its scope is limited within the package. Public: The word itself indicates that it has scope everywhere, i.e; it is visible everywhere even outside the package. Private: It has scope only within the class.
default (no modifier specified): accessible by the classes of the same package. private : accessible within the same class only.
2) Default The default modifier is accessible only within package. It cannot be accessed from outside the package. It provides more accessibility than private. But, it is more restrictive than protected, and public.
After scanning a lot of the 11g (this question was about 11g) documentation from Oracle regarding this, I think the answer should be: alter table t_a result_cache (mode manual); is not documented. The fact that it is accepted is either an Oracle bug or it is a documentation defect that it is not described. While it might (who outside of Oracle can really proof that?) behave 100% the same as mode default, I would not use it, and use the two modes on table level that are described in the documentation: DEFAULT and FORCE. MANUAL is a documented option only for the parameter RESULT_CACHE_MODE.
This is the best - 11g related - documentation from Oracle that I could find which covers both Result Cache Table Annotations (chapter 7.6.3.3) as well as the RESULT_CACHE_MODE Initialization Parameter (chapter 7.6.3.1): https://docs.oracle.com/cd/E25178_01/server.1111/e16638/memory.htm#BGBCABED
Edit: corrected the link
140
answered Oct 14 '22 18:10
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
