From oracle-l-bounce@freelists.org Thu Jun 10 13:51:08 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5AIors23764 for ; Thu, 10 Jun 2004 13:51:03 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5AIoh623730 for ; Thu, 10 Jun 2004 13:50:53 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A904172C6E9; Thu, 10 Jun 2004 13:36:10 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03985-67; Thu, 10 Jun 2004 13:36:10 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0817072C6C6; Thu, 10 Jun 2004 13:36:10 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 10 Jun 2004 13:34:48 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6C89272C6B7 for ; Thu, 10 Jun 2004 13:34:48 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03463-74 for ; Thu, 10 Jun 2004 13:34:48 -0500 (EST) Received: from lakermmtao04.cox.net (lakermmtao04.cox.net [68.230.240.35]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DA57D72C6BD for ; Thu, 10 Jun 2004 13:34:47 -0500 (EST) Received: from smtp.central.cox.net ([172.18.52.54]) by lakermmtao04.cox.net (InterMail vM.6.01.03.02 201-2131-111-104-20040324) with SMTP id <20040610185418.UJXB12116.lakermmtao04.cox.net@smtp.central.cox.net> for ; Thu, 10 Jun 2004 14:54:18 -0400 From: To: oracle-l@freelists.org Subject: Effect of multiple block sizes on performance Date: Thu, 10 Jun 2004 14:54:20 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Message-Id: <20040610185418.UJXB12116.lakermmtao04.cox.net@smtp.central.cox.net> X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2511 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ryan.gaffuri@cox.net Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@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 -----------------------------------------------------------------