Database Reference
In-Depth Information
In Exercise 9.4, you will capture a Database Replay workload on a source database and
replay it on a destination database.
exeRCiSe 9.4
Performing Database Replay
In this exercise, you will use the Database Replay feature to compare workload perfor-
mance between a source database and a destination database.
1. Create a replay database as a copy of the capture database. One method is to use
RMAN to make a clone. You could also use the DBCA to create a new capture data-
base and a replay database.
2. Capture a workload on the source database.
3. Preprocess the workload capture.
4. Replay the workload on the destination database.
5. Analyze the results.
Summary
In this chapter, you learned about tools that help the DBA diagnose problems in the database
and tools that assist with detecting and resolving performance issues.
In the first part, we introduced the Automatic Diagnostic Repository (ADR), the
new central repository for storing all database diagnostic information, and the Support
Workbench, which the DBA uses for problem recognition, reporting, and resolution.
The Support Workbench improves DBA productivity by providing a process and web
pages to report, analyze, and send diagnostic information to Oracle Support for prob-
lem resolution.
Block media recovery (BMR) is used to repair corrupt blocks within a data file while
keeping the data file online. Block media recovery requires Enterprise Edition.
In the second part, we introduced the SQL Tuning Advisor, the SQL Access Advisor,
and Database Replay. To help improve the performance of SQL statements, the SQL Tuning
Advisor recommends new or modified indexes, SQL profiles, rewriting your SQL statements,
or using statistics. The SQL Access Advisor looks at workgroups and recommends indexes,
partitioning, and materialized views to improve the performance of a workload. Database
Replay is an extremely useful tool that allows the DBA to capture and replay a workload to
compare the performance of one system to another.
 
Search WWH ::




Custom Search