Performance problem?

From: Little Prince <milan1810_at_geocities.com>
Date: Sun, 15 Jul 2001 12:33:05 +0800
Message-ID: <9ir6ek$h5322@ctmsun0.macau.ctm.net>

I meet a problem recently. I use Oracle ver. 8.0.6 and IBM RS6000 (AIX) v.4. The performanc of my oracle server sometimes is very poor. At that time, I querey 'SELECT * FROM V$SESSION_WAIT'. I have started three DBWR. I found that there are three 'DBWR PARALLEL WRITE' and several 'WRITE COMPLETE WAITS' events. These events continuously appear in V$SESSION_WAIT. Then, I use UNIX command 'iostat /hdisk1' to check the hard disk. The % activity if 98%, 99%, 100%, etc. But, only several transactions are existed at that time.

I made a conclusion that the poor performance may be due to IO bound because Oracle may continuously write data from buffer pool to data files on disk. How can I tune the Oracle server? How can I know the throughput of harddisk1?

Anyone can give me a comment?

Regards,
Andrew Received on Sat Jul 14 2001 - 23:33:05 CDT