Wednesday, August 6, 2014

How to identify if ASMLIB is used or not

  • How to identify if ASMLIB is used or not
SQL> select path ,library from v$asm_disk;
PATH                 LIBRARY
-------------------- ------------------------------------------------------------
ORCL:VOL001          ASM Library - Generic Linux, version 2.0.2 (KABI_V2)
ORCL:VOL002          ASM Library - Generic Linux, version 2.0.2 (KABI_V2)
ORCL:VOL003          ASM Library - Generic Linux, version 2.0.2 (KABI_V2)
ORCL:VOL004          ASM Library - Generic Linux, version 2.0.2 (KABI_V2)

PATH                                               LIBRARY
-------------------------------------------------- ------------------------------------------------------------
/dev/oracleasm/disks/ASM7                          System
/dev/oracleasm/disks/ASM2                          System
/dev/oracleasm/disks/ASM1                          System
/dev/oracleasm/disks/ASM5                          System
/dev/oracleasm/disks/ASM6                          System
/dev/oracleasm/disks/ASM4                          System
/dev/oracleasm/disks/ASM3                          System

No comments: