Performance tuning a RAC implementation

The following is an excerpt from Chapter 9 of Oracle 10g RAC Grid, Services & Clustering by Murali Vallath. Vallath is an Oracle Certified Database Administrator with expertise in implementation, configuration and performance tuning of Oracle parallel server/Oracle Real Application Clusters. Vallath currently provides consulting services through Summersky Enterprises LLC.

Click here to read the full chapter.

Performance tuning of any application, including the database, is an iterative process. This means that to maintain a healthy database, one must constantly monitor and fine-tune it. During certain periods, an aggressive performance tuning of both the application and database may be required. At other times, only routine continuous monitoring and maintenance may be needed. During this time, system hiccups may be discovered and solutions tried and tested.

The goal of a DBA or the application developer is to provide efficient, well-performing applications with good response time. In order for the application to provide a good response, the system, database, and SQL queries should be well tuned. Systems are tuned based on data collected during periods of poor performance; the evidence and the data collected may provide an indication of where the actual problem resides. For continuous monitoring and tuning of systems, a process or method should be adopted that helps streamline the activity. As in most repeatable situations, a methodology should be adopted, and once it has been validated and approved, it needs to be practiced. This methodology should be iterated every time there is a need to tune the system.

In this chapter, we will look into a scientific approach to troubleshooting, performance tuning, and maintaining a healthy database system. Tuning a RAC i

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Chapter Downloads Writing single-row and multiple-row subqueries List the types of SQL subqueries Using subqueries in SQL Define SQL subqueries Oracle 11g: PL/SQL Basics Oracle 11g: Backup and recovery concepts Migrating to Oracle: Expert Secrets to Migrate from SQL Server and MySQL Oracle Database 11g SQL Tuning Upgrading to Oracle Database 11g Tuning the Oracle database with initialization parameters Oracle database performance problems and tuning Oracle New Year's resolutions, part 1: Advice for navigating 2009 Solving common Oracle errors guide Oracle 11g data compression Varchar or number for better performance? Do statistics on SYS-owned objects hurt performance in 10g? Inside the Oracle 11g SQL Performance Advisor, part 1 Inside the Oracle 11g SQL Performance Advisor, part 2 Difference between driving table and driver table in Oracle Best design for E-Business Suite on hard drive Using the cost-based optimizer to improve Database 10g performance Oracle RAC and database clustering E-discovery firm swaps out Microsoft SQL for Oracle RAC Firm dumps MySQL on Red Hat for Oracle Database on Oracle Linux How to back up archive log files in RAC eHarmony spurns Microsoft, finds match with Oracle 10g How to back up RAC database with RMAN Using connection load balancing with Oracle RAC 20GB data dictionary causing performance problems Grid computing adoption slow amid fears of complexity DBA 102: Beyond the basics Can I install Oracle binary files on a SAN?

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary Real Application Cluster  (SearchOracle.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

mplementation has many aspects, and the techniques will vary depending on whether the RAC cluster is preproduction or live. Since a RAC configuration comprises one or more instances connected to a shared database, tuning a RAC configuration ideally starts with tuning the individual instances prior to the deployment of the production cluster. Individual instances in the cluster should be tuned using the same techniques used for single-instance databases. Once the individual instances are tuned, the other tiers, network, interconnect, cluster manager, and so on, should be incorporated into the tuning process.

Methodology

Problem-solving tasks of any nature need to be approached in a systematic and controlled manner. There needs to be a defined procedure or an action plan, and this procedure needs to be followed step by step from start to finish. During every step of the process, data is collected and analyzed, and the results are fed into the next step, which in turn is performed using a similar systematic approach. Hence, methodology is the procedure or process followed from start to finish, from identification of the problem to problem solving and documentation. A methodology is a procedure or process that is repeatable as a whole or in increments through iterations. During all of this analysis, the cause or reasons for a behavior or problem should be based on quantitative analysis and not on guesswork.

The performance tuning methodology can be broadly categorized into seven steps:

Click here to read the full chapter.

Printed with permission from Digital Press, a division of Elsevier. Copyright 2006. Oracle 10g RAC Grid, Services & Clustering by Murali Vallath. For more information about this book and other similar titles, please visit elsevier.com.

Rate this Tip To rate tips, you must be a member of SearchOracle.com. Register now to start rating these tips. Log in if you are already a member. DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.