Home > Workload Solutions > Oracle > White Papers > Oracle ASM on ScaleIO Best Practices > DISK11
Table 18 includes compatibility information for the disk11.sql script.
Table 18. Script details—disk11
Type of information |
Details |
Name |
disk11.sql |
Compatibility |
11g, 12c |
Purpose |
Shows each disk and the diskgroup it is assigned to. |
Sample output:
DISK_NAME DISKGROUP_NAME DSK MNT_STA HDR_STA STATE OS_SZ TOTAL FREE PATH
--------- -------------- --- ------- ------- ------ ----- ----- ---- -------------
CRS_0000 CRS 0 CACHED MEMBER NORMAL 1G 1G 1G /dev/oracleasm/disks/CRSVOL1
CRS_0001 CRS 1 CACHED MEMBER NORMAL 1G 1G 1G /dev/oracleasm/disks/CRSVOL2
CRS_0002 CRS 2 CACHED MEMBER NORMAL 1G 1G 1G /dev/oracleasm/disks/CRSVOL3
DISK1 DATA 0 CACHED MEMBER NORMAL 2G 2G 0G /dev/oracleasm/disks/DATA1
DISK2 DATA 1 CACHED MEMBER NORMAL 2G 2G 0G /dev/oracleasm/disks/DATA2
DISK3 DATA 2 CACHED MEMBER NORMAL 2G 2G 0G /dev/oracleasm/disks/DATA3
DISK4 DATA 3 CACHED MEMBER NORMAL 2G 2G 0G /dev/oracleasm/disks/DATA4
DISK5 DATA 4 CACHED MEMBER NORMAL 2G 2G 0G /dev/oracleasm/disks/DATA5
DISK1 FRA 0 CACHED MEMBER NORMAL 2G 2G 2G /dev/oracleasm/disks/FRA1
DISK2 FRA 1 CACHED MEMBER NORMAL 2G 2G 2G /dev/oracleasm/disks/FRA2
DISK3 FRA 2 CACHED MEMBER NORMAL 2G 2G 2G /dev/oracleasm/disks/FRA3
DISK1 REDO 0 CACHED MEMBER NORMAL 1G 1G 1G /dev/oracleasm/disks/REDO1
DISK2 REDO 1 CACHED MEMBER NORMAL 1G 1G 1G /dev/oracleasm/disks/REDO2
Table 19 contains the key to the output:
Table 19. Key to disk11.sql columns
Column |
Meaning |
DISK_NAME |
Name of the ASM disk |
DISKGROUP_NAME |
Diskgroup name |
DSK |
Disk number |
MNT_STA |
Mount status |
HDR_STA |
Header status |
STATE |
Device status |
OS_SZ |
Device size as reported to OS |
TOTAL |
Total space on the disk (after mirroring) |
FREE |
Free space on the disk (after mirroring) |
PATH |
Device path |
Script text:
set linesize 132
set pagesize 999
col diskgroup_name for a15
col dsk for 999
col gn for 99
col hdr_sta for a11
col mnt_sta for a7
col free for a6
col os_sz for a6
col total for a6
col path for a30
col raid for a8
col state for a10
col disk_name for a12
select
vad.name "DISK_NAME",
vag.name "DISKGROUP_NAME",
-- vad.group_number "GN",
-- vad.voting_file
vad.disk_number "DSK",
vad.mount_status "MNT_STA",
vad.header_status "HDR_STA",
vad.state,
-- vad.redundancy "RAID",
decode(floor(vad.os_mb/1048576),0,
to_char(vad.os_mb/1024,'9999')||'G',
to_char(vad.os_mb/1048576,'99.9')||'T'
) "OS_SZ",
decode(floor(vad.total_mb/1048576),0,
to_char(vad.total_mb/1024,'9999')||'G',
to_char(vad.total_mb/1048576,'99.9')||'T'
) "TOTAL",
decode(floor(vad.free_mb/1048576),0,
to_char(vad.free_mb/1024,'9999')||'G',
to_char(vad.free_mb/1048576,'99.9')||'T'
) "FREE",
vad.path
from
v$asm_disk vad,
v$asm_diskgroup vag
where 1=1
and vad.group_number = vag.group_number(+)
order by vag.name, vad.name
/