Database Reference
In-Depth Information
RAC Database Performance Tuning: A Quick n' Easy Approach
OEM12c is a leap forward in sophisticated DB management, monitoring, and administration—a great tool for quick,
easy, and intuitive performance tuning of a RAC cluster. This section is an overview, and further details are presented
in other chapters.
OEM Cloud Control facilitates and accelerates identification and fixing of DB bottlenecks, problematic SQL
statements, locks, contention, concurrency, and other potential crisis situations, including monitoring/logging into
hung databases.
Holistic graphical analysis can quickly and easily help a RAC DBA/DMA to identify performance bottlenecks at
the cluster/instance level, resulting in lower incident response times.
The 3 A's of Performance Tuning
The 3 A's of performance tuning in a RAC Database, all of which are easily accessible in quite a bit of drill-down detail
within OEM12c, are listed in the following:
•
AWR (Automatic Workload Repository)
•
ADDM (Automatic Database Diagnostic Monitor)
•
ASH (Active Session History)
The preceding are supplemented by the following new/recent features within OEM12cR2:
•
Real-time ADDM
•
Compare real-time ADDM reports
•
ASH analytics
•
Top activity
•
SQL monitoring
Some of these much-needed tools/features are incorporated within the diagnostics and tuning pack, which
is essential for enhanced and effective monitoring, troubleshooting, and performance tuning the Oracle Database
Server family including RAC.
The frequency of slow times in a RAC database is way higher than downtime: the perfect tool to attack this
problem is OEM12cR2
➤
Performance Home Page, which, as the heart and soul of the visual monitoring/analysis
process/methodology, gives you a clear and easy-to-interpret overview of the RAC DB health in real time as well as
from a historical perspective.
OEM 12c R2
➤
Performance Home Page
The Performance Home Page within OEM12cR2 is all about graphs, charts, and colors (OR pictures)! This is
an intuitive starting point for effective and easy-to-learn performance tuning of the Oracle Database Server family
including RAC.
