Re: IO waits in SAP/Oracle

From: William Dangren <wdangren_at_navisent.com>
Date: Tue, 22 Jun 1999 11:10:41 -0400
Message-ID: <376FA771.D50DBE0D@navisent.com>

DBWR and LGWR are always writing blocks to the disks. When you have a check point it also writes to the disks. It also will write to the temp tablespace when you are doing large sorts. I suggest you run bstat and estat to tell you which files are being hit most of the time and try to distribute them better. Place the most hit file on the same disk as the least hit file and so on. Hope this helps.

Bill

--
William Dangren
Navis Enterprises
407.348.6401
800.219.0207 Received on Tue Jun 22 1999 - 10:10:41 CDT