| |
 |
|
Oracle Tips by Burleson |
Oracle10g Grid Computing
with RAC
Chapter 12 - RAC Design Considerations
Conclusion
Proper implementation of a strategy that
considers these points will make the system more robust and
scalable.
The old 80/20 rule applies here; 80% or more of
the overhead results from 20% or less of the workload. If the 20% is
fixed by observing some simple guidelines, then tangible benefits
can be achieved with minimal effort. Workload problems can be
corrected by implementing any or all of the following:
-
Use Oracle automated free list management,
or define free list groups for partitioned, as well as
non-partitioned, data that is frequently modified.
-
Use read-only tablespaces wherever data
remains constant.
-
Use
locally managed tablespaces to reduce extent management costs.
-
Use Oracle sequences to generate unique
numbers and set the CACHE parameter to high value, if needed.
-
Use sequence staggering to help prevent
index block contention.
-
If
possible, reduce concurrent changes to index blocks. However, if
index key values are not modified by multiple instances, or if
the modification rate is not excessive, the overhead may be
acceptable. In extreme cases, techniques like physical table
partitioning can be applied.
References
Metalink Note: 226880.1: Configuration of
Load Balancing and Transparent Application Failover
OOW 2003 Presentation 32035: Oracle 9i RAC: A
Case Study, Steve Teeters, Science Applications International
Corporation, Bobby Hampton, Science Applications International
Corporation
OOW 2003 Presentation 32949: Oracle 9i Real
Application Clusters Helping Southwest Airlines Take Off, Kerry
Schwab. Director IT, Southwest Airlines
OOW 2003 Presentation 33433: Oracle RAC and
Linux in
the real enterprise, Mark Clark, Director, Merrill Lynch Europe PLC,
Global Database Technologies
SEOUC 2003 Presentation: A Bare Bones RAC
Installation, Michael R. Ault, Senior Technical Management
Consultant, TUSC Inc - The Oracle Experts
UKOUG 2001 Presentation: Advantages of Oracle9i
Real Application Clusters, Michael R. Ault, Senior Technical
Management Consultant, TUSC Inc - The Oracle Experts.
Oracle Real Application Clusters Deployment and Performance Guide
10g Release 1 (10.1),
Part Number B10768-01
Oracle Real Application Clusters Administrator's Guide 10g Release 1
(10.1) Part Number B10765-01
Oracle Real Application Clusters Installation
and Configuration Guide 10g Release 1 (10.1) for AIX-Based Systems, hp HP-UX
PA-RISC (64-bit), hp Tru64 UNIX, Linux, Solaris Operating System (SPARC
64-bit) Part No. B10766-01
For more information,
see the book
Oracle 11g
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.
Remote DBA
Services
Burleson Consulting
can offer world-class remote Oracle database support at super-affordable prices.
Our remote
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
TablePack,
ServerPack
and
AuditPack
services
- 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.
For more
information, please visit www.oracle-training.cc.
|
