How And What To Check On Oracle ASM Instance?

Objective: To check on Oracle Automatic Storage Management (ASM) instance.

Version: Applies to Oracle 11g or later.

Solution:

spool asm.html
set markup html on
set echo on
set pagesize 200
alter session set nls_date_format='dd-mon-yyyy hh24:mi:ss';
select 'this asm report was generated at: ==> ' , sysdate " " from dual;
select 'hostname associated with this asm instance: ==> ' , machine " " from v$session where program like '%smon%';
select * from v$asm_diskgroup;
select * from v$asm_disk order by group_number,disk_number;
select * from v$asm_disk_iostat order by group_number,disk_number;
select * from v$asm_client;
select * from v$asm_attribute;
select * from v$asm_operation;
select * from gv$asm_operation;
select * from v$asm_alias;
select * from v$asm_file;
select * from v$version;
show parameter asm
show parameter cluster
show parameter instance_type
show parameter instance_name
show parameter spfile
show parameter
show sga
spool off
exit

Above script will create a .html file.  If you open up the .html file you will find extensive information populated from the ASM related views.