S311441 Practical Performance Management for Oracle Real.ppt

S311441 Practical Performance Management for Oracle Real Application Clusters
Michael Zoll, Consulting Member of Technical Staff
Barb Lundhild, Product Manager, Oracle Real Application Clusters
The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not mitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.
<Insert Picture Here>
Agenda
Oracle RAC Infrastructure and Technical Fundamentals
Application and Database mon Problems and Symptoms
Diagnostics and Problem Determination
Appendix
Objective
Convey a few simple and fundamental concepts of Oracle RAC performance
Summarize application level performance and scalability information
Provide some simple sizing hints
Give exemplary overview mon problems and solutions
Builds on similar presentation from OOW 2008
hnology/products/database/clustering/pdf/
<Insert Picture Here>
Oracle RAC Infrastructure: Technical Fundamentals, Sizing and Configuration
Service
Oracle RAC Architecture
work
Node1
Operating System
Oracle Clusterware
instance 1
ASM
VIP1
Listener
Node 2
VIP2
Node n
VIPn
/…/
Redo / Archive logs all instances
shared storage
Database / Control files
OCR and Voting Disks
Managed by ASM
SCAN_Listener
Service
Operating System
Oracle Clusterware
instance 2
ASM
Listener
SCAN_Listener
Service
Operating System
Oracle Clusterware
instance n
ASM
Listener
SCAN_Listener
Global Cache and Global Enqueue ServiceProcesses and Functions
Dictionary
Cache
Log buffer
LGWR
DBW0
Library
Cache
Buffer Cache
LMON
LMD0
SGA
Runs in Real
Time Priority
LMSx
Cluster Private High work
Global Resource Directory
Global Enqueue Service
Global Cach