Re: IO waits in SAP/Oracle

From: thuge <thuge_at_steelcase-strafor.com>
Date: Wed, 23 Jun 1999 09:27:50 GMT
Message-ID: <7kq9ai$2f6$1@nnrp1.deja.com>

In article <376FA771.D50DBE0D_at_navisent.com>, William Dangren <wdangren_at_navisent.com> wrote:
> 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
>
>

Hello,

If i understand your message my IO waits would come ONLY from the "write" processes (DBWR LGWR).
It would be ONLY Output waits due to write operations, then i have to monitor the data files which are the most written. Is this right ?

thanks for your help,

Thierry
--
Thierry HUGE
AIX/Oracle/SAP Administrator
STEELCASE STRAFOR (FRANCE) Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 23 1999 - 04:27:50 CDT