Effect of multiple block sizes on performance

  • From: <ryan.gaffuri@xxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 10 Jun 2004 14:54:20 -0400

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
-----------------------------------------------------------------

Other related posts: