Re: Hash Partition in OLTP with VPD

From: Ls Cheng <exriscer_at_gmail.com>
Date: Tue, 7 May 2013 14:01:45 +0200
Message-ID: <CAJ2-Qb8j6w5DOHAmX7-wJ4PsANWNzEM0GQpUNf5NzZbJ8iVX0g_at_mail.gmail.com>

Hi
I have used hash partition in OLTP system, it's main purpose is to reduce access contention, specially indexes. Use global indexes and not too many partitions (start with 4).

Regards

On Tue, May 7, 2013 at 2:11 AM, Karth Panchan <keyantech_at_gmail.com> wrote:

> All
> I am working on re-architect existing high transaction OLTP system facing
> customers with 1Million users per hour.
>
> It is on Oracle 11.2 Version on Enterprise Linux with 2 node RAC.
>
> This system faced by around approx 8000 clients. Microsoft .NET web tier.
>
> I am new to this place and in database, many tables are Hash partitioned
> using VPD.
>
> I was debating myself, it would be better with none other Hash Partition.
> Not sure, it is because last 7 years I developed most of partition types
> except Hash.
>
> Anyone have insight/experience with Hash on OLTP (or) with VPD?
>
> Thanks in advance.
>
> Karth
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 07 2013 - 14:01:45 CEST