Re: hash partitions on 10gR2 RAC database

  • From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
  • To: sjaffarhussain@xxxxxxxxx
  • Date: Thu, 13 Dec 2007 16:40:06 +0700

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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l


Other related posts: