||Oracle Tips by Burleson
Oracle10g Grid Computing
Chapter 12 - RAC Design Considerations
Designing for High Performance
at these factors for proper application design one-by-one, and see how
they can be utilized to make RAC applications perform optimally.
Compartmenting Transactions to Specific Nodes
One obvious method of reducing pings between
instances is to isolate the transactions that use a specific data
set to a specific server in the RAC cluster. For example, in a
multiuse instance that contains multiple applications, isolate each
application’s user logins to a specific node (for example, sales
users use the sales node, accounting uses the accounting node, and
so on). In the case of a node failure, the users switch to one of
the other nodes.
This compartmenting of transactions is difficult
to implement for a large, multiuse RAC database where many different
groups of users use each of the applications on the RAC cluster. In
the case of a multi-use instance that is used by almost all
corporate users, other techniques must be employed to optimize
Creating Efficient RAC Data Objects
of efficient RAC data objects entails using storage wisely in
accordance with good RAC practices. Some of the good RAC practices, to
put it quite frankly, waste disk and memory space to improve data
sharing and dispersal characteristics.
of an efficient RAC object is one that is used by only a single
instance at a time. To achieve this singularity of use, the
rows-per-block (RPB) of the data object must be reduced. By reducing
the RPB, the chances that multiple instances in the RAC cluster will
require data in the same block are decreased. Here are several
techniques to reduce the RPB in a RAC data object:
For more information,
see the book
Grid and Real Application Clusters 30% off if you
buy it directly from Rampant TechPress .
Written by top Oracle
experts, this RAC book has a complete online code depot with
ready to use RAC scripts.
can offer world-class remote Oracle database support at super-affordable prices.
Oracle DBA service provides 100% of the remote Oracle database administration
needs for your company, and includes 24x7 access to our staff of 100% OCP
Certified Oracle DBAs.
We require a 12 month service commitment and include the following services:
- Initial configuration review and problem identification
- Installation of Oracle statistics collection mechanisms and quarterly
database growth summaries
- Hourly monitoring of your Oracle database for pending problems
- Periodic performance analysis & identification of tuning activities
- Twenty Four hour Oracle emergency support
- Reporting and resolving all serious Oracle alert log messages
- Free use of the BC
- Quick response emergency support for production database outages
- Four hours of free remote DBA support every month. You can use these free
hours for any DBA activity, including database analysis, system design,
production migrations or personal mentoring.
information, please visit www.oracle-training.cc.