[askdba] Disk intensive prblem
- From: "Yavor Ivanov" <yavor_ivanov@xxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Fri, 29 Oct 2004 13:24:04 +0300
I have some strange problem with one of my Oracle servers. The disk
activity is too much, and the disk queue length reaches values like 10-15,
even up to 50! THe disk is fast enough, in fact it is RAID 1+0 of Ultra
SCSI 320 disks.
Do any of you have any script for identifying disk-intensive SQL / hot
datablocks? Maybe I'll be lucky one to spot 2-3 "bad" queries....
Rgds,
Yavor
Other related posts:
