Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

ISBN: 978-0-9861194-1-5 Library of Congress Number: 2015932839
441 pages
Perfect Bind -  7.5 x 9.25
PD 315
Shelving: Database/Oracle Oracle in-Focus Series:  # 50

  Oracle RAC Performance Tuning
Includes Oracle 12c

Brian Peasland

Retail Price $54.95 USD/  £36.95 / $65.95 Canadian

Order now for 30% off! Only $41.95
(30% off)
     
Key Features About the Author Table of Contents
Index Reader Comments Errata
     


This book is the first of its kind, a book dedicated to tuning the Oracle high availability RAC architecture.  Oracle RAC databases are flexible and robust, and along with this flexibility comes complexity, making RAC tuning one of the most challenging areas of Oracle tuning.

Packed with incisive insights and examples from one of America's leading RAC experts, guru Brian Peasland delivers an indispensible book for all RAC administrators who need to guarantee that their RAC systems run at optimal performance.

It's not enough for the DBA to maintain and control RAC database, the RAC DBA must also have an arsenal of tools and scripts that will help them ensure that their RAC database run at optimal levels.

This book will be valuable to all Oracle professionals who must tune their Oracle RAC systems for peak performance. Similar to tuning Oracle database systems in general, Oracle RAC performance tuning covers a wide variety of focus areas.

Topics will include Oracle wait events specific to RAC deployments, using Oracle Enterprise Manager Grid Control and AWR in diagnosing RAC problems, and RAC utilities such as OS Watcher and ORAchk (formerly RACcheck). This book will also discuss architecture issues related RAC performance, delving into the cluster interconnect, physical disk layout and Oracle 12c new Flex Clusters.

Oracle RAC also allows the workload the spread among several low cost servers (scale-out) rather than a large single server (scale-up), and this book examines these approaches from a tuning perspective.

Many companies are working towards private cloud implementations using RAC, and this book is perfect for the DBA's charged with . Oracle 12c RAC raises the bar with its new multi-tenant database implementation. Think of multi-tenant as virtualization at the database level. As more companies start leveraging Oracle 12c RAC for their enterprise database architecture, it is important that the system be designed and tuned properly to ensure the application has a well-performing user experience.

This unique book provides a one-stop location for any RAC DBA who must become a RAC performance tuning specialist. Most Oracle RAC books on the market devote only one chapter to performance tuning.

The information in this book provides a solid foundation for one’s first RAC deployment, and provide you with the tools and methods needed to keep your complex RAC systems running optimally.

While this book is not for beginners, the reader is given sufficient background throughout the chapters so that most Oracle DBAs, even those will little Oracle RAC experience, will be able to understand its contents. Oracle RAC is inherently complex. This explains the concepts before delving into highly technical areas. Many in-depth areas of RAC tuning are explored that help the DBA reveal hidden performance trends within even the most complex RAC database.

 
 

                
             
   Includes
            Oracle 12c
!
 

Key Features

  * Download a code depot with all of the tuning scripts in the book.

* Understand the main areas of RAC performance tuning.

* See how to tune RAC for peak performance.

* Learn about RAC wait events.

* Get examples of tuning the RAC cluster interconnect.

* Understand how to use OS Watcher and ORAchk to monitor RAC performance.

* See how to use AWR to diagnose long-term RAC tuning issues.

* Download RAC troubleshooting scripts.

* Learn RAC wait event tuning.

* See optimal disk layout techniques for RAC

* Understand the 12c flex clusters.

About the Author:

 

    Brian Peasland

Brian Peasland has 17 years of experience as an Oracle Database Administrator. He has a M.S. degree in Computer Science focusing on database systems. Brian is Oracle certified with the Oracle Certified Professional (OCP) DBA for the 7.3, 8, 8.1, 9i, and 10g versions.

Brian has been working with Oracle database performance tuning since Oracle 7.3 and with Oracle RAC since the 10.1 version.

Brian is a frequent contributor to the Oracle Technet (OTN) forums and My Oracle Support Communities. Prior to his involvement in these groups, he was a major contributor to SearchOracle.com’s Ask The Expert program. He has presented papers at IOUG Live! conferences.

Table of Contents:

Chapter 1:

Introduction TO RAC Tuning

Introduction to RAC Tuning

RAC Database vs. Instance

RAC Tuning Methodology
RAC Tuning for a Single Instance

RAC Scalability

Summary

 

Chapter 2:

Cache Fusion

Introduction to Cache Fusion

History of Cache Fusion

Cache Fusion Overview

Cache Coherency

RAC Current Read Tracing

RAC Consistent Reads Tracing

RAC 2-way and 3-way Global Cache Fusion Transfers

Oracle RAC Global Resource Manager Grants

RAC Dynamic Resource Manager (DRM)

RAC Session Blockers

RAC Block Busy Events

Summary

 

Chapter 3:

RAC Application Tuning

SQL Trace and RAC

Sequence Cache and RAC

Sequence ORDER clause

SYS.AUDSES$ Sequence

RAC Row Insert Contention

Reverse Key Indexes in RAC

RAC TNS Services

Creating RAC TNS Services

RAC Buffer Cache Effect

The Resource Manager and RAC

Real Application Testing and RAC

Table Compression and RAC

Partitioning and RAC

Summary

 

Chapter 4:

Tuning the Cluster Interconnect

Private Network

Using iperf with RAC

Infiniband or Gig-E Cluster Interconnects with RAC

Jumbo Frames and RAC

Block Size and RAC

Sizing UDP in RAC

GC Block Lost

Top GC Transfers

Cluster Interconnect Performance

HAIP

In Summary

 

Chapter 5:

Tuning RAC Storage

Tuning storage for Single Instance RAC

RAC Disk Architecture

RAID 5 and RAC

RAID striping and RAC

Oracle Orion testing utility

ASM and RAC

NFS and RAC Tuning

Direct NFS and RAC Tuning

OCR and Voting Disks with RAC Tuning

Tuning Online Redo Logs in a RAC environment

Undo Tablespaces in RAC

Temporary Tablespaces and RAC

ASSM and RAC

Hot Segments in RAC Tuning

Hot Services

Information Lifecycle Management (ILM) and RAC

Summary

 

Chapter 6:

Tuning Memory

Tuning For Single Instance Databases

The Data Buffer Cache

Shared Pool

PGA Sizing for RAC

pga_aggregate_limit

Huge Pages

Result Cache and RAC

In Memory Database

Summary

 

Chapter 7:

RAC Parallel Operations

Parallel Example

How Parallel Query Works

Determining the Degree of Parallelism

Parallel Query Parameters and RAC

Parallel Query Granules and RAC

Partitions and the optimal degree of parallelism

Parallel Statement Queuing and RAC

Tuning Parallel Execution

Local Parallel Operations

Controlling Slave Locations

Parallel Explain Plans and RAC

Bloom Filters

The px_join_filter hint

Summary

 

Chapter 8:

RAC Support Tools

RAC and DB Tools Bundle

Cluster Health Monitor

CHMOSG

OSWatcher

OSWatcher Analyzer

RACDIAG

RAC Wait Chains

RAC GES Blocking

RAC Global Cache Consistent Read

RAC top-10 wait events

Procwatcher

Oratop

ORAchk

SQLT

Summary

 

Chapter 9:

AWR, ADDM and ASH

Diagnostics Pack

AWR Retention and RAC

SYSAUX tablespace components

Setting the AWR Collection Interval

AWR Reports

Invoking awrrpt.sql

Buffer Cache Access

Average processing time for GCS and GES messages

Cluster Interconnect Statistics

Foreground Wait Class Statistics

Service statistics

Statistics by wait event

SQL Statements

Global Cache Buffer Busy Events

Global Cache Transfer Statistics

Average time to complete 2-way and 3-way transfers

awrrpti.sql

awrgrpt.sql

ADDM

ASH for RAC

Summary

 

Chapter 10:

Benchmark Utilities for RAC

Swingbench

Order Entry Benchmark

Calling Circle Benchmark

Charbench Utility

Clusteroverview for RAC

Swingbench Summary

HammerDB

TPC-C Benchmark

AWR Driver Script

TPC-H Benchmark

HammerDB Summary

Summary

 

Chapter 11:

Enterprise Manager for  RAC

Optional Packs

Cluster Topology

Performance Home

OEM Parallel Execution History

AWR and RAC in EM

Cluster Cache Coherency in EM

Real Time ADDM in EM

Search Sessions

Blocking Sessions

Services

Cluster Performance in EM

Summary

 

Chapter 12:

Wait Events, Locks, and Statistics in RAC

Wait Events

Parallel Execution Wait Events in RAC

Cluster Wait Class Events

Miscellaneous RAC Wait Events

RAC Locks

RAC Statistics

RAC Parallel Statistics

Global Cache Statistics

Summary

 

Chapter 13:

Flex ASM and Flex Cluster

Flex ASM

Migrating to Flex ASM

Installing With Flex ASM

Using Flex ASM in RAC

Flex ASM Performance in RAC

Flex Cluster

Summary

 

Chapter 14:

Book Summary 4

RAC Areas of Focus

Index


/etc/fstab  

/etc/sysctl.conf  

/proc/sys/net/core

/usr/sbin/ss

ACID  

Active Session History   

ADDM               

ADO  

Advanced Compression   

Alert Log  

AMM     

analytic functions

append hint

ARCnet

ASH             

ASH Analytics.

ashrpt.sql

ASM                        

ASM diskgroups

asmca   

ASSM   

audsid

Automated Database Diagnostics Monitor

Automated ILM

Automated Workload Repository

Automatic Data Optimization

Automatic Database Diagnostics Monitor  

Automatic Memory Management

Automatic Segment Space Management  

AWR                                        

awrgrpt.sql  

awrinfo.sql    

awrrpt.sql     

BCHR

benchmark     

block size

block size parameter

Blocking Sessions

Blocks Lost

blocks lost in wait events

bloom filters  

bottleneck       

Buffer Cache                     

Buffer Caches  

cache                         

Cache Fusion                      

Calling Circle   

CC  

ccwizard  

CFS  

charbench     

CHM               

chmosg   

CHMOSG   

Cloud Control

Cluster Health Monitor           

cluster interconnect    

Cluster Interconnect                    

Cluster Managed Services

cluster_interconnects

Clustered File System

clusteroverview  

Clusteroverview     

consistent read          

Consistent Read blocks  

Consistent Read Blocks Received

consistent reads   

CPU time

CPU Time

CR     

CSV files

current_master  

Data Buffer Cache  

Data Dictionary    

Database Control  

Database Replay

Database Writer processes

Datapoint

db file scattered read       

db file sequential read      

DB time

db_block_size     

dba_data_files

dba_hist_active_sess_history

dba_hist_ic_client_stats

dba_ilmparameters  

dba_objects      

dba_tablespaces

dba_temp_files

dbms_application_info  

dbms_monitor   

dd command

DDL statements parallelized  

DEC PDP-

default socket sizes

Degree of Parallelism      

DFS lock handle

diagnostic dump destination

diagnostic_dest

Diagnostics Pack        

Distributed Lock Manager  

DLM

DML statements parallelized  

DOP          

DRM  

Dynamic Resource Mastering  

EM Database Control

Enterprise Manager                       

Enterprise Manager c

estd_cluster_read_time

estd_cluster_reads

Ethernet switches

exclusive lock  

FC  

Fibre Channel   

Flex ASM                    

Flex Cluster    

gc blocks corrupt  

gc blocks lost  

gc buffer busy

gc buffer busy acquire

gc buffer busy release

gc cr        

gc cr block -way     

gc cr block -way  

gc cr block busy

gc cr block congested

gc cr block lost   

gc cr block receive time

gc cr block send time

gc cr blocks received   

gc cr blocks served

gc cr disk read

gc cr failure

gc cr grant -way   

gc cr grant busy

gc cr grant congested

gc cr multi block request

gc cr request

gc current block -way    

gc current block -way    

gc current block busy

gc current block congested

gc current block lost    

gc current block receive time

gc current block send time

gc current blocks received  

gc current blocks served

gc current grant -way

gc current grant busy

gc current grant congested

gc current multi block request

gc current read

gc current request

gc current retry

gc current split

gc kbytes sent

gc local grants

gc quiesce

gc remaster

gc remote grants

GCS    

gcs resources  

gcs_resources

GES          

ges enqueues  

gets.

Gigabit Ethernet  

Gig-E  

global block cache transfer

Global cache block transfers

Global Cache Consistent Read

global cache current blocks

Global Cache Services  

global cache transfers               

Global Enqueue Services      

global locking

Global Resource Directory  

grant queue.  

GRD   

Grid Control

Grid Infrastructure              

gv$cluster_interconnects    

gv$ges_blocking_enqueue  

gv$ges_resource  

gv$im_segments  

gv$lock   

gv$lock.

gv$pga_target_advice

gv$ps_session

gv$segment_statistics   

gv$services  

gv$session

gv$session_event  

gv$session_wait

gv$sesstat

gv$sga_target_advice

gv$sqlarea.

gv$sysstat      

gv$system_event   

gv$tempundostat

gv$undostat  

HAIP             

HammerDB                   

HammerOra  

hash-partitioning

HBA  

heartbeat   

Highly Available IP   

Host Bus Adapter

hr_svc  

Huge Pages        

–hugenotneeded

HV contention

I/O contention

IB

ILM      

In Memory        

In Memory database    

index range scans

Infiniband   

Information Lifecycle Management    

inmemory_size   

Inst No column

instance enqueue process

instance_groups  

Inter-Operation Parallelism

Intra-Operation Parallelism

IP over Infiniband

ip route

iperf       

Iperf

IPoIB

ipq traffic

Java

Jumbo Frames      

Large Pool    

Larry Ellison

LCK

Leaf Nodes  

link aggregation   

Linux               

LMD  

LMON

LMS     

Lock Manager Daemon  

Lock Manager Server

Lock Monitor.

Logical I/O

lsnrctl  

master copy   

master

max_utilization

maximizing throughput

Maximum Transmission Unit

MBPS  

memory_max_target  

memory_target     

minimizing response time

misses

mixed pages

 

master_node    

mktg_svc  

MMNL

MMON Lite

MOSC   

MTU       

Multipathing

multiple block sizes

Multitenant  

mutex S  

mutex X

My Oracle Support Community

Network File System  

NFS          

nfs_read

nfs_readbytes

nfs_write

nfs_writebytes

NIC    

NIC bonding  

NIC Bonding  

NIC teaming

no_parallel  

no_px_join_filter

nocache      

node   

obj#  

oclumon    

OCR

oifcfg     

ologgerd  

OLTP

OLTP test   

on DEC VAX  

onepass  

Online Transaction Processing

OPS  

ORA-

ORA-

orachk     

ORAchk         

Oracle c         

Oracle Diagnostics Pack

Oracle Interface Configuration Tool

Oracle Parallel Server   

Oracle Performance Pack

Oracle’s Times Ten

Oracle’s Wait Interface  

Oratop       

Orion            

OSWatcher           

oswbb      

oswbba    

P   

P  

pagefile.

paging

parallel degree   

Parallel operations downgraded  to  pct

Parallel operations downgraded  to  pct

Parallel operations downgraded  to  pct

Parallel operations downgraded  to  pct

Parallel operations downgraded to serial

Parallel operations not downgraded

parallel parallelism

parallel slave  

parallel SQL              

parallel SQL slaves

parallel_degree_policy   

parallel_force_local  

parallel_instance_group  

parallel_max_servers   

parallel_min_servers  

parallel_queue_timeout

parallel_server_limit

partition pruning

partitioning       

pctfree

PerfMon  

Performance Packs

PGA   

pga_aggregate_limit

pga_aggregate_target   

pin S

pin X

ping

PL/SQL functions

plan_hash_value

pmon timer

port trunking

previous_master

private network                     

Procwatcher       

Program Global Area  

Pstart  

Pstop  

PX Deq   

PX local messages recv'd

PX local messages sent

PX message pool    

PX remote messages recv'd

PX remote messages sent

px_join_filter

QC               

QoS

Quality of Service

queries parallelized  

Query Coordinator          

RAC Consistent Reads Tracing

RAC Tuning Methodology

RACchk    

RACchk)  

Racdiag.sql script  

RAID   

RAID  

RAID   

RAID +

RAID   

RAT

raw disks  

Real Application Testing

Real-Time ADDM

redo log groups  

Redundant Array of Independent Disks

Relational Software Inc

response time  

Response time  

Result Cache     

result_cache_max_size  

Reverse Key index  

rmem   

-run parameter

S.A.M.E

SAN   

sar

SAS

SATA  

scale out.

scale up

scaling up

SCAN Listener  

SDL

sequence                

sequence values       

Serial ATA  

Serial Attached SCSI

serial#  

serv_mod_act_trace_enable  

server_set  

SGA              

sga_target   

shared lock  

Shared Pool            

shared_pool_size  

sid    

simulate I/O

Single Instance RAC

slave processes               

Solid State Disk

SQL Execution phase

SQL Trace

sql_plan_hash_value

SQLT           

SS contention

SSD

ssh  

Statspack

Storage Area Network

Stripe And Mirror Everywhere

stripe length

stripe size

sudo  

SV contention

swap space

swapping  

Swingbench                   

sys

SYS      

sys$background

sys.audses$.

sysaux tablespace    

sysdba

SYSTEM

System Global Area     

TAF

Task Manager

TCP       

Technet    

TFA  

Tile Chart radio button

tkprof       

TLB  

TLB miss

top              

top  wait events

top five wait events

TPC-C            

TPC-H     

Trace File Analyzer  

trace files     

traceroute   

Transaction Performance Processing Council

Translation Lookaside Buffer

Transparent Application Failover

trcsess

TX contention

TX index contention

UDP         

Undo Advisor

Unix        

used_bytes  

v$asm_client

v$database

v$instance      

v$lock_type  

v$logfile

v$mystat

v$pga_target_advice  

v$resource_limit

v$segment_statistics

v$session    

v$session_event

v$sesstat

v$sga_target_advice

v$sql_join_filter

v$sysstat  

v$wait_chain

VAXCluster

vertical scaling

VIP    

Virtual Box hypervisor

virtual memory

vmstat

VMWare

Voting Disks  

wait time

Wait Time

wmem   

workarea executions  

X Windows

X$


 


Reviews:


Errata:


 

 
 
 
 

 

 

Hit Counter

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks