SET line 120
col NAME FOR a20
col PATH FOR a30
col mode_status FOR a11
col voting_files FOR a12
SELECT group_number,name,total_mb,free_mb,voting_files FROM v$asm_diskgroup ORDER BY group_number;
SELECT NAME,PATH,mode_status FROM v$asm_disk ORDER BY NAME;
col NAME FOR a20
col PATH FOR a30
col mode_status FOR a11
col voting_files FOR a12
SELECT group_number,name,total_mb,free_mb,voting_files FROM v$asm_diskgroup ORDER BY group_number;
SELECT NAME,PATH,mode_status FROM v$asm_disk ORDER BY NAME;