Change is relentless in today's rapidly evolving IT environments. But it doesn't have to be difficult for data center managers and administrators. Oracle Real Application Testing helps organizations reduce their testing efforts by giving DBAs and system administrators an easy-to-deploy solution for testing and rolling out data center changes. This white paper discusses how Real Application Testing - with Oracle Database 11g Release 2 - allows businesses to quickly adopt new technologies while eliminating the risks associated with change.
Oracle Database 11g: Manageability and Real Application Testing Overview
An Oracle White Paper August 2009
Oracle Database 11g Release 2:
Manageability and Real Application
Testing Overview
Oracle Database 11g: Manageability and Real Application Testing Overview
Introduction ....................................................................................... 3
Manageability Challenges.................................................................. 3
Performance Management ................................................................ 4
Performance Diagnostics............................................................... 4
Automatic Workload Repository .......................................................... 4
Automatic Database Diagnostics Monitor ............................................ 4
AWR Baselines and Adaptive Thresholds ........................................... 6
Application Tuning......................................................................... 7
SQL Tuning and Access Advisors ....................................................... 8
Automatic SQL Tuning........................................................................ 9
Real Time SQL Monitoring.................................................................10
SQL Plan Management......................................................................11
Change Management...................................................................... 13
Change Detection........................................................................ 13
Change Testing ........................................................................... 14
Real Application Testing ....................................................................14
Database Replay ...............................................................................14
SQL Performance Analyzer................................................................17
Change Automation..................................................................... 19
Securely provisioned database environments ....................................19
Ongoing Administration ................................................................... 20
Resource Management ............................................................... 20
Automatic Memory Management........................................................20
Space Management...........................................................................22
Fault Diagnostics......................................................................... 23
Automated Health Checks .................................................................24
SQL Test Case Builder ......................................................................24
Automatic Diagnostic Repository (ADR) .............................................24
Incident packaging service (IPS)........................................................25
Support Workbench ...........................................................................25
What does it mean to you?.............................................................. 26
Conclusion ...................................................................................... 26 Oracle Database 11g: Manageability and Real Application Testing Overview
Introduction The Oracle database is the marketleader and the preferred database for hundreds of thousands of businesses as well as application developers and database administrators worldwide. Over the years, enterprises have come to rely on the Oracle Database to provide unparalleled performance and reliability. In release 10g of the database, Oracle delivered a selfmanaging database with breakthrough manageability that dramatically reduced management costs. Oracle is ready to raise the bar once again with the release of Oracle Database 11g. Designed for data center environments that are rapidly evolving and changing to keep up with the demands of the business, Oracle Database 11g allows businesses to adopt new technologies quickly while minimizing risk. In addition, building on its selfmanaging capabilities, Oracle Database 11g has made significant advances in the ... [download for more]
