You are managing an Oracle Database 11g database with the ASM storage. The database
is having big file tablespaces. You want files to open faster and less memory to be used in
the shared pool to manage the extent maps.
What configuration would you effect to achieve your objective? (Choose all that apply.)
A.
Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
B.
Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
C.
Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
D.
Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.
Can anybody explain why the answer is AD?
I think B is also the answer.
C is wrong because there is no COMPATIBLE initialization parameter for the ASM instance.
see the list of inits in the ASM instance at
https://docs.oracle.com/cd/E11882_01/server.112/e18951/asminst.htm
Now lets talk about answer B …..
In …
https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm
it says…..
For example, if the COMPATIBLE initialization parameters of the databases are set to either 11.1 or 11.2, then COMPATIBLE.RDBMS can be set to any value between 10.1 and 11.1 inclusively.
later in the same document it says…
The following example creates a normal redundancy disk group data1 with the Oracle ASM compatibility set to 11.2 and the RDBMS compatibility set to the default (the COMPATIBLE.RDBMS default is less than or equal to 11.2):
So the COMPATIBLE.RDBMS disk group attribute can be less than both of these
– COMPATIBLE initialization parameters of the databases (Answer D above)
– Oracle ASM compatibility i.e. the disk group attribute COMPATIBLE.ASM (Answer A above)
Therefore answer B is not necessarily right, hence answer B is wrong.
I have changed my mind, I found the reason why A and D are correct.
See
http://oracle.su/docs/11g/server.112/e10500/asmdiskgrps.htm#CHDIBHBB
http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#CHDIBHBB