Useful queries to find the details of ASM

 

This document describes how to find the asm diskgroup details and it's size.

Find the asm disk details.

SQL> select GROUP_NUMBER DG#, name, ALLOCATION_UNIT_SIZE AU_SZ, STATE,TYPE, TOTAL_MB, FREE_MB, OFFLINE_DISKS from v$asm_diskgroup;

Query to find the ASM disk size.

set linesize 400 

pagesize 400
col path for a30

SQL> select HEADER_STATUS, group_number,disk_number,name, path,os_mb/1024 OS_GB , total_mb/1024 TOTGB from v$asm_disk order by group_number,disk_number;

Query to find the ASM operations.

select * from v$asm_operation;

Thanks for going through this post..............