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!     * 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$