[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....


Other related posts: