Re: "free buffer waits" under eXtreme Transaction Loads
- From: zhu chao <zhuchao@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 27 Jul 2004 09:37:52 +0800
From your statspack report, I did not see huge physical write, it is
not very high for your hardware.
For HPUX, did you use raw for your datafiles(you mentioned logfile
is on raw). And in HPUX, there are a lot of kernel parameter to set to
enable and optimize the AIO. Did your SA setup them properly?
And I wonder whether you are using a really small dataset for your
benchmark. You data buffer size is really small (less than 1g) but
your cache hit ratio is 99%+.
--
Regards
Zhu Chao
www.cnoug.org
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
