V$ASMFILE - Definition - Oracle Control Files

Q.  Which view in an ASM instance contains one row for every ASM file in every disk group mounted by the ASM instance in a DB instance that contains no rows?
- Published on 12 Aug 15

a. V$ASM_FILE
b. V$ASM_DISK
c. V$ASM_DISK_STAT
d. V$ASM_DISKGROUP_STAT

ANSWER: V$ASM_FILE

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 28 Aug 15
    - Oracle Automated Storage Management has several v$ views to see information About Automated Storage Management disks, diskgroups and other internals.

    - V$ASM_FILE - Contains one row for every Oracle ASM file in every disk group mounted by the Oracle ASM instance.

    - V$ASM_DISK - Contains one row for every disk discovered by the Oracle ASM instance, including disks that are not part of any disk group.
    This view performs disk discovery every time it is queried.

    - V$ASM_DISK_STAT - Contains the same columns as V$ASM_DISK, but to reduce overhead, does not perform a discovery when it is queried. It only returns information about any disks that are part of mounted disk groups in the storage system. To see all disks, use V$ASM_DISK instead.

    - V$ASM_DISKGROUP_STAT - Contains the same columns as V$ASM_DISKGROUP, but to reduce overhead, does not perform a discovery when it is queried. It does not return information about any disks that are part of mounted disk groups in the storage system. To see all disks, use V$ASM_DISKGROUP instead.

➨ 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.)
▲