Oracle 11g contains an integrated framework for proactive monitoring, management, administration, and performance tuning advances to a completely self-tuned database with a set of expert advisors and tools. This enables the DBA to make an informed and intelligent decision based on real workload, historical database behavior, and what-if impact analysis. We will now cover the most significant features introduced in 11gR1 and 11gR2, related to performance monitoring and tuning.
Let's first take a look at the new performance tuning features in Oracle 11g R1.
The Database Replay feature (sometimes referred to as Workload Replay) in Oracle 11g Enterprise Edition Real Application Testing allows you to reproduce the production database conditions in a testing environment. Database Replay enables you to capture the actual workload on a production system and replay it in a test system. This way, you can...