| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Effect of multiple block sizes on performance
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of ryan.gaffuri_at_cox.net
Sent: Friday, 11 June 2004 4:54 AM
To: oracle-l_at_freelists.org
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.
 |
 |