RE: Oracle Application Partitioning

Various modules within given applications suites may have wildly varying requirements for accessing and/or updating different tables or different blocks within the same tables.

For example, a General Ledger application might rarely need access to Personnel Data, but a Payroll application would likely need Personnel frequently.

Outside of application suites, some applications using the same database might have no common reference of data at all.

In the case of RAC (or previously OPS), if instead of load balancing all applications on all nodes, you provide different service entry points and database connections for the various applications you use to one (or more) specific instances of a database, you have a good chance to minimize interinstance traffic. (If you make sure that sequences serving applications intended to operate primarily on different instances do not share the same block in seq$ it can in some cases dramatically improve your situation). Likewise, within a single application it may be possible to partition by values known at login time so that data crosstalk between instance even within a single application is minimized.

A primary marketing feature of RAC is that it is not required to rearchitect an application to execute correctly across all the instances of the RAC.

Sometimes lost in that marketing message is that Application Partitioning is usually a boon to performance and is often the easiest thing to do to minimize the "RAC TAX."

In the non-RAC context, Application Partitioning is often putting applications that have minimal or no cross data reference in different databases entirely. This can be useful, for example, if you have two completely disjoint applications that currently have enough horsepower from one quarter of a company standard node, but you expect each of them to need more than half the horsepower of a company standard node within a year.

So when someone says "Application Partitioning" you need to ask a few more questions to be sure you are talking about the same branch of the concept.

Regards,

mwf

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of hrishy
Sent: Tuesday, February 19, 2008 6:03 AM To: oracle-l_at_freelists.org
Subject: Oracle Application Partitioning

Hi

What is meant by oracle Application Partitioning esp in the case of RAC ?

Can anybody explain.

regards
Hrishy

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Feb 19 2008 - 07:34:20 CST