||Oracle Tips by Burleson
Oracle10g Grid Computing
Chapter 3 - High
Performance and Highly Available
Exclusion with STOMITH approach
However, there are certain issues with method:
Potential data integrity issues on account
of forceful shutdown of node.
Nodes can shoot each other and shutdown
Cannot access shot server to diagnose
In another example, Sistina GFS supports
multiple, cascading I/O fencing methods including manual, network
power control, and fibre channel switch zone control.
Cache Coherency and Lock
One of the most critical features for a
parallel database is its ability to control global concurrency of
the data (pages or blocks) located in the individual node’s cache.
As each of the nodes has its own local cache that has current data
blocks, their status and access need to be controlled globally.
Other node’s cache might need to access concurrently. Blocks are
moved frequently across the nodes when needed. In addition, there
should be effective and accurate monitoring of the status of the
blocks in cache. Lock acquisition, lock release and lock conversions
should be performed at rapid speeds. Low latency and High-speed
communication between the nodes is an essential requirement.
Since a data block can be present in the
database buffers of more than one node, when an update occurs all
other buffered copies become obsolete. Global cache control
mechanism invalidates the obsolete data blocks. Another important
feature is the way in which the reconfiguration of cache occurs when
a node fails. To maintain integrity of data blocks, failed
instance’s resources need to be taken over or re-mastered by another
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.
Oracle Consulting Services
Burleson Oracle Consulting offers Senior Oracle consultants which are available
for all areas of Oracle support. Common Oracle consulting support
activities include short-term Oracle tuning, Oracle database troubleshooting,
Oracle9i and Oracle10g migration,
Oracle9iAS App Server
consulting, Oracle design reviews and
Oracle requirements evaluation support. Oracle support and Oracle consulting
services are priced by the hour, so you only pay for what you need. These
one-time Oracle consulting services commonly include:
Answering questions from your Oracle DBA technical staff
Repairing down production Oracle database systems
One-time Oracle tuning evaluation
Guru support for your Oracle DBA
Installation of Oracle application packages
For more information, please visit