Database Reference
In-Depth Information
This chapter is divided into two sections; the first section
is dedicated to tools that help the database administrators
diagnose problems in the database, and the second part is
dedicated to tools that assist with detecting and resolving performance issues.
In the first part, we describe the Automatic Diagnostic Repository, the central repository
for all database diagnostic information, and the Support Workbench, which the DBA uses for
problem recognition, reporting, and resolution. Together these represent the diagnostic work-
flow. We also discuss and demonstrate block media recovery.
In the second part, we describe how to monitor operations and performance in the 12
c
multitenant architecture, with a brief introduction to container databases (CDBs) and plug-
gable databases (PDBs), and how to manage allocation of resources between PDBs and within
a PDB using the SQL Tuning Advisor and the SQL Access Advisor. We also teach you the
fundamentals of Database Replay. Database Replay allows the DBA to capture a workload
on a production system and replay it on a different system, simulating the behavior of the
production application in a different environment.
Exam objectives are subject to change at any time without prior notice and
at Oracle's sole discretion. Please visit Oracle's Training and Certification
website (
http://www.oracle.com/education/certification/
) for the
most current exam-objectives listing.
Diagnosing Failures
One of the most important day-to-day tasks of the DBA is to monitor system activity and
diagnose, report, and repair problems. The Automatic Diagnostic Repository was introduced
in Oracle 11
g
and provides a central location for storing problem- and incident-related infor-
mation. We will describe and demonstrate the diagnostic process and workflow and include
an introduction to the Automatic Diagnostic Repository Command Interpreter (ADRCI).
Block media recovery improvements in 12
c
make it easier for the DBA to recognize and
recover from a data-corruption incident.
Setting Up the Automatic Diagnostic Repository
The Automatic Diagnostic Repository (ADR) is a hierarchical, file-based, system-wide and
system-managed repository for storing and organizing dump files, trace files, alert logs, health
Search WWH ::
Custom Search