ASM Scripts

ASM Scripts

Some Important v$ views for ASM

v$asm_diskgroup

v$asm_client

v$asm_disk

v$asm_file

v$asm_template

v$asm_alias

v$asm_operation 

Some useful scripts to get ASM details.

1) ASM Diskgroup Details

SELECT *

  FROM v$asm_diskgroup

 ORDER BY group_number;

2) ASM Connected database

SELECT ad.name,

       ac.instance_name,

       ac.db_name,

       status

  FROM v$asm_diskgroup ad,

       v$asm_client ac

 WHERE ad.group_number = ac.group_number

 ORDER BY ac.instance_name,

       ac.db_name, 

       ac.group_number;

3) ASM disk details

SELECT * from v$asm_disk;

4) ASM disk operations

SELECT * from v$asm_operation;

5) Free disk details

SELECT * from v$asm_disk;

check header_status is FORMER or CANDIDATE