You are managing an Oracle Database 11 g 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.
Explanation:
http://docs.oracle.com/cd/B28359_01/server.111/b31107/asmdiskgrps.htm#autoId
32
Ans. should A and D
B is correct too. If you do not set the RDBMS compatibility on the disk group you will not have support for larger AU sizes, which I believe is the point in the question when it mentions big files tbs and extend maps. Check table 4-3 on the explanation link.