Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 5841 invoked from network); 13 Dec 2007 04:27:33 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 13 Dec 2007 04:27:33 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4E69B7D8357; Thu, 13 Dec 2007 05:27:33 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05152-10; Thu, 13 Dec 2007 05:27:33 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B30DB7D849E; Thu, 13 Dec 2007 05:27:32 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 13 Dec 2007 04:40:08 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0B57D7D8821 for ; Thu, 13 Dec 2007 04:40:08 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29771-06 for ; Thu, 13 Dec 2007 04:40:07 -0500 (EST) Received: from hs-out-2122.google.com (hs-out-0708.google.com [64.233.178.247]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C83887D85D5 for ; Thu, 13 Dec 2007 04:40:07 -0500 (EST) Received: by hs-out-2122.google.com with SMTP id 23so980570hsn.2 for ; Thu, 13 Dec 2007 01:40:07 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=t2CpnEYqzWoX0XxfQD1u/bYeh3zOI7N8kRFsimOJiM0=; b=bEwX28+SQRZY+na9ETBfzC/D5wczS96PLxrlbFhkn02psQmBOSDiCgP0EpX77u7efSniUh9f+YkH/0jwPKRF3kuaPc4ijqxDGnLMhp26zxqslVpV9LIWGUTlWHi0khsyCHJI5j9ZXGJ+mRAkei8Wo16OnppO2zz1UxH71+XczrI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=aO3e/BX2IJ/zHWiEDaPq8tTofkN35c7OZBLqfYhmwPcUEexyn9vDgKeBPV1g7Ab9fQjDkwmphaQa8FRdUlhHzxiUbzJo9rtC2FouJySgWMM2rQcWWANXSRFbXRYewnVZJhJDSajMkdVCQ8porvpfxAzqb+PdbBsqOrPr3nY/QVw= Received: by 10.70.13.6 with SMTP id 6mr2885305wxm.29.1197538806920; Thu, 13 Dec 2007 01:40:06 -0800 (PST) Received: by 10.70.112.18 with HTTP; Thu, 13 Dec 2007 01:40:06 -0800 (PST) Message-ID: <3edcb66e0712130140r59145eccse9d322ec71692ee0@mail.gmail.com> Date: Thu, 13 Dec 2007 16:40:06 +0700 From: "Ujang Jaenudin" To: sjaffarhussain@gmail.com Subject: Re: hash partitions on 10gR2 RAC database Cc: oracle-l In-Reply-To: <97b7fd2f0712120428n35a3315cr6b4cec13cf277ab9@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline References: <97b7fd2f0712120428n35a3315cr6b4cec13cf277ab9@mail.gmail.com> X-archive-position: 3908 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: ujang.jaenudin@gmail.com Precedence: normal Reply-to: ujang.jaenudin@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain jaffar, I have the experienced that performance increased when using hash partition in RAC. we have very high DML load database (RAC) which is on 10.2.0.3 and we have no issue about bugs on that particular partitions, except for HW - contention on LOB objetcs. regards ujang On 12/12/07, Syed Jaffar Hussain wrote: > Hi, > > We are planning to make use of hash partition to one of the heavily accessed > table on a RAC database(Oracle 10gR2). > > Are there any serious bugs/performance issues assosiates with hash partition > on Oracle 10gR2 ? > > > > > > -- > Best Regards, > Syed Jaffar Hussain > Oracle ACE > 8i,9i & 10g OCP DBA > > http://jaffardba.blogspot.com/ > http://apex.oracle.com/pls/otn/f?p=19297:4:1579866181463918::NO:4:P4_ID:126 > ---------------------------------------------------------------------------------- > "Winners don't do different things. They do things differently." > -- regards ujang jakarta - indonesia http://ujang-id.blogspot.com -- http://www.freelists.org/webpage/oracle-l