Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Oracle 11g R1/R2 Real Application Clusters Essentials
  • Table Of Contents Toc
Oracle 11g R1/R2 Real Application Clusters Essentials

Oracle 11g R1/R2 Real Application Clusters Essentials

4.4 (11)
close
close
Oracle 11g R1/R2 Real Application Clusters Essentials

Oracle 11g R1/R2 Real Application Clusters Essentials

4.4 (11)

Overview of this book

Oracle RAC or Real Application Clusters is a grid computing solution that allows multiple nodes (servers) in a clustered system to mount and open a single database that resides on shared disk storage. Should a single system (node) fail, the database service will still be available on the remaining nodes. Oracle RAC is an integral part of the Oracle database setup. You have one database with multiple users accessing it, in real time. This book will enable DBAs to get their finger on the pulse of the Oracle 11g RAC environment quickly and easily.This book will cover all areas of the Oracle RAC environment and is indispensable if you are an Oracle DBA who is charged with configuring and implementing Oracle11g R1, with bonus R2 information included. This book presents a complete method for the configuration, installation, and design of Oracle 11g RAC, ultimately enabling rapid administration of Oracle 11g RAC environments.This practical handbook documents how to administer a complex Oracle 11g RAC environment. Packed with real world examples, expert tips and troubleshooting advice, the book begins by introducing the concept of Oracle RAC and High Availability. It then dives deep into the world of RAC configuration, installation and design, enabling you to support complex RAC environments for real world deployments. Chapters cover Oracle RAC and High Availability, Oracle 11g RAC Architecture, Oracle 11g RAC Installation, Automatic Storage Management, Troubleshooting, Workload Management and much more. By following the practical examples in this book, you will learn every concept of the RAC environment and how to successfully support complex Oracle 11g R1 and R2 RAC environments for various deployments within real world situations. This book is the updated release of our previous Oracle 11g R1/R2 Real Application Clusters Handbook. If you already own a copy of that Handbook, there is no need to upgrade to this book.
Table of Contents (20 chapters)
close
close
Oracle 11g R1/R2 Real Application Clusters Essentials
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
2
Index

Chapter 8. Performance Tuning

Performance tuning is as much an art as a science when it comes to Oracle database systems. In the past, different performance tuning methodologies were used in a random fashion without a valid scientific method. For example, Oracle DBAs would use methods for tuning the buffer cache hit ratios based on experience rather than tested formulae. Using so called silver bullets produced a haphazard solution at best, without a true understanding of the root cause of a performance issue. With the advent of the Oracle Wait Interface (OWI), many of these old and inaccurate techniques have finally been laid to the dustbins of false myths. The first step in the performance tuning of Oracle RAC environments is to tune the database itself, as you would for a non-clustered Oracle database environment. By assessing basics such as database instance tuning, as well as efficient SQL query tuning, most of your performance issues can be addressed before moving on to the more challenging...

Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Oracle 11g R1/R2 Real Application Clusters Essentials
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon