RE: Oracle Application Partitioning
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <hrishys@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Feb 2008 08:34:20 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of hrishy
Sent: Tuesday, February 19, 2008 6:03 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Oracle Application Partitioning
Hi
What is meant by oracle Application Partitioning esp
in the case of RAC ?
Can anybody explain.
regards
Hrishy
__________________________________________________________
Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
