Hash Partition in OLTP with VPD
From: Karth Panchan <keyantech_at_gmail.com>
Date: Mon, 6 May 2013 20:11:13 -0400
Message-ID: <CAFj-6g9QG3t8HByeJZgtBhxS7ubxSvXuhMuUFVWux5StAotxRA_at_mail.gmail.com>
All
I am working on re-architect existing high transaction OLTP system facing customers with 1Million users per hour.
Date: Mon, 6 May 2013 20:11:13 -0400
Message-ID: <CAFj-6g9QG3t8HByeJZgtBhxS7ubxSvXuhMuUFVWux5StAotxRA_at_mail.gmail.com>
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-lReceived on Tue May 07 2013 - 02:11:13 CEST