[askdba] Re: Disk intensive prblem

  • From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Fri, 29 Oct 2004 11:44:48 +0100

A Select from v$sql with ordering on the Various Disk Related Columns
wil give u a Fair Idea of what Query is Causing the Maximum Disk

Also V$Filestat is a nice way to find out Hot Files. 

IMHO .. The first idea should give u more room to play around.


On Fri, 29 Oct 2004 13:24:04 +0300, Yavor Ivanov <yavor_ivanov@xxxxxxxx> wrote:
>         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: