Effect of multiple block sizes on performance

From: <ryan.gaffuri_at_cox.net>
Date: Thu, 10 Jun 2004 14:54:20 -0400
Message-Id: <20040610185418.UJXB12116.lakermmtao04.cox.net@smtp.central.cox.net>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Jun 10 2004 - 13:51:08 CDT