||Oracle Tips by Burleson
Oracle10g Grid Computing
Chapter 12 - RAC Design Considerations
Creating Efficient RAC Data Objects
seem perplexing, since some of the suggestions are contradictory. The
correct approach depends on the specific tuning situation. In a
situation where hot blocking is occurring (multiple instances want the
same index block because all of the current data entries are indexed
there), then randomizing the index nodes will reduce the possibility
of intra-node index block pinging.
demonstrated in Figure 13.3. In the case where the data referenced in
a single index block is needed by a single instance, the number of
data blocks required is reduced by concentrating the data into as few
a number of data and index nodes as possible. This reduces the
intra-node pinging of data blocks. This is demonstrated in Figure
13.4. So in the first case we are reducing intra-node index block
pinging, in the second we are reducing the intra-node pinging of data
blocks. The appropriate technique will have to be determined for each
Example of a Reverse Key Index
Clustering Factor Affects
illustrates that a hot index block, such as an index containing
sequential data (by date or number) that is required by multiple
nodes, increases the intra-node index block pinging, as the
nodes transfer the index block to perform data lookups.
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.