||Oracle Tips by Burleson
Oracle10g Grid Computing
Chapter 3 - High
Performance and Highly Available
IBM Parallel SysPlex Architecture
The Coupling facility is a microprocessor unit.
High bandwidth fiber optic links, called channels, provides
connectivity between CF and nodes/systems. DB2 uses the coupling
facility to provide for inter-node communications. The coupling
facility ensures data availability while maintaining data integrity
across the connected DB2 subsystems. Coupling facility provides core
services such as data locking, data consistency and buffering.
The coupling facility uses three structures to
synchronize the activities of the data-sharing group members:
Cache structure - Supplies a
mechanism called buffer invalidation to ensure consistency of
cached data. The cache structure can also be used as a
high-speed buffer for storing shared data with common read/write
List structure - Enables authorized
applications to share data that is organized in a set of lists,
for implementing function such as shared work queues and shared
Lock structure - Supplies shared and
exclusive locking capability for serialization of shared
resources down to a very small unit of data.
Thus, the Coupling Facility manages all
locking, contention and concurrency issues. It does liaison with
local buffers of the nodes. It is the heart of data sharing system.
While it provides a high performance parallel
cluster for database support, it comes with very high price.
Moreover, this system is a proprietary solution requiring higher
costs in terms of administration and manageability.
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