Configuration to open files faster & less memory is used - Oracle Control Files

Q.  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?
- Published on 12 Aug 15

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
e. Both A & D

ANSWER: Both A & D

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 30 Sep 15
    - The COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group attributes specify the compatibility settings for Oracle ASM and database instances.

    - These attributes are described under the following topics:

    COMPATIBLE.ASM
    - The value for the disk group COMPATIBLE.ASM attribute determines the minimum software version for an ASM instance that uses the disk group.

    - This setting also determines the format of the data structures for the ASM metadata on the disk.

    - The format of the file contents is determined by the database instance.

    - For ASM in Oracle Database 11g, 10.1 is the default setting for the COMPATIBLE.ASM attribute.

    COMPATIBLE.RDBMS
    - The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that uses the disk group.

    - For example, if the database COMPATIBLE initialization parameter is set to 11.1.0, then COMPATIBLE.RDBMS can be set to any value between 10.1 and 11.1 inclusively.

    - For ASM in Oracle Database 11g, 10.1 is the default setting for the COMPATIBLE.RDBMS attribute.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲