Diagnosing the Database and Managing Performance - OCP: Oracle Database 12c Administrator Certified Professional - page 449

Exam Essentials
Know how to set up the Automatic Diagnostic Repository. Make sure you understand
the new initialization parameter for ADR, which parameters are deprecated, and the basic
directory structure of the ADR.
Know how to use the Support Workbench to report an incident. Know the steps required
to open a service request with Oracle Support. Know how to package and submit the files
related to a problem incident.
Know how to perform block media recovery. Know how to discover corrupt data blocks,
what causes data corruption, and how to repair corrupt data blocks. Know what can con-
tribute to faster recoveries. Know what is required to perform block media recovery.
Understand automatic and manual SQL tuning. Understand the differences between
automatic and manual SQL tuning using the Tuning Advisor. Understand the advantages
and potential dangers of automatic SQL tuning. Understand how to use the SQL Tuning
Advisor in manual mode. Understand the scope differences between CDBs and PDBs when
using the SQL Tuning Advisor in automatic and manual modes.
Understand the SQL Access Advisor. Know what types of changes and types of indexes
the SQL Access Advisor may recommend. Understand the impact of implementing
recommendations.
Know when to use Database Replay. Know the purpose and uses for Database Replay. Know
what is required to set up and perform Database Replay. Know how to compare results from
the production workload and the replay workload.