LATEST TOPICS

Query to check high I/O ASM Disks

This query can be used to identify the Top 10 ASM disks involved in High I/O for a particular database

----------------------------------
----- Script: chk_asm_io.sql
----- Author: Abu Fazal Abbas
-----------------------------------
set lines 200
col Device for a55
select * from
(
select a.DBNAME as "DB Name",
b.PATH as "Device",
a.READS as "Read Request",
a.WRITES as "Write Requests",
a.BYTES_READ/1024/1024 as "Total Read MB",
a.BYTES_WRITTEN/1024/1024 "Total Write MB"
from v$asm_disk_iostat a, v$asm_disk b
where  a.GROUP_NUMBER=b.GROUP_NUMBER 
and a.DISK_NUMBER=b.DISK_NUMBER 
and a.DBNAME='&DB_Name'
order by 3 desc
)
where rownum <=10;
;

Once the high I/O ASM disks are identified, we can Map them with physical disks to troubleshoot I/O bottlenecks

%d bloggers like this:
Visit Us On LinkedinVisit Us On TwitterVisit Us On Google PlusCheck Our Feed