PROMPT
PROMPT ******************************************** ASM ********************************************************************

PROMPT
PROMPT ******************************************** ASM DISKGROUPS

SELECT group_number, name, state, total_mb, free_mb, ROUND(free_mb/1024,2) free_gb, block_size, allocation_unit_size, type
FROM v$asm_diskgroup;

PROMPT
PROMPT ******************************************** ASM DISKS

COL path FORMAT a50

SELECT group_number, disk_number, mount_status, header_status, mode_status, state, redundancy, total_mb, free_mb, name, path, create_date, mount_date
FROM v$asm_disk;

PROMPT
PROMPT ******************************************** ASM FILES

SELECT group_number, file_number, block_size, blocks, ROUND((bytes/1024/1024),2) mb, space, type, redundancy, creation_date, modification_date
FROM v$asm_file;

PROMPT
PROMPT ******************************************** ASM OPERATIONS

SELECT group_number, operation, state, power, actual, ROUND(100*sofar/DECODE(est_work,0,1,est_work),2) avance, est_rate, est_minutes
FROM v$asm_operation;