Re: hash partitions on 10gR2 RAC database

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Thu, 13 Dec 2007 16:40:06 +0700
Message-ID: <3edcb66e0712130140r59145eccse9d322ec71692ee0@mail.gmail.com>

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 <sjaffarhussain_at_gmail.com> 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

Received on Thu Dec 13 2007 - 03:40:06 CST