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

FiGURe 9.39 Results confirmed for the SQL Access Advisor task
exeRCiSe 9.3
Using the SQl Access Advisor
In this exercise, you will utilize the SQL Access Advisor to tune a workload. Since the
workload is highly dependent on your database configuration, you will need to provide
a workload, execute the advisor, and take the recommended actions.
1. Select a workload that you've already created, or create a new workload.
2. For the depth and breadth of recommendation options, you want to review only
indexing recommendations.
3. Review the recommendations. If they make sense to you for your database, then
implement them.
Perform Database Replay
One of the most difficult tasks for the professional DBA is setting up and conducting valid
workload performance tests. It's easy to test the performance of a single query but often very
challenging to test how an entire workload will perform in a different environment. For many
organizations, the cost to test a platform migration is prohibitive, but the risk of not testing
is significant. Organizations need to know how infrastructure changes will affect database
application performance and if there's any impact to service-level agreements.