RE: Effect of multiple block sizes on performance
- From: Pete Sharman <peter.sharman@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 11 Jun 2004 06:08:13 +1000
Zip, zero, nada.
Different block size tablespaces are there for transportable tablespace reasons
only. Both internal testing at Oracle and external testing by the likes of
Anjo have shown there is so little performance benefit from them. There are
MANY other things to look at for performance tuning first.
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of ryan.gaffuri@xxxxxxx
Sent: Friday, 11 June 2004 4:54 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Effect of multiple block sizes on performance
We have to publish data from several staging databases and we are using
transportable tablespaces. What are the effects of multiple blocksizes on
performance?
Has anyone used this under very heavy user load? We have a 4-Node RAC and worst
case stress level could be 2,000 transactions/second. We will also have a
reporting element(which I hope will only run over night).
Anyone use this? Not sure I want to, just looking at it. Its a hybrid
application so scaling is rather tricky.
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
