Multiple choice technology databases

Using EM Database Control, you’ve identified that the following SQL statement is the source of a high amount of disk I/O: SELECT NAME, LOCATION, CREDIT_LIMIT FROM CUSTOMERS What might you do first to try to improve performance?

  1. Run the SQL Tuning Advisor.

  2. Run the SQL Access Advisor.

  3. Check the EM Database Control main screen for alerts.

  4. Click the Alert Log Content link in the EM Database Control main screen.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The SQL Tuning Advisor is the appropriate first tool for analyzing and improving performance of a specific SQL statement showing high disk I/O. The SQL Access Advisor is for overall schema design (indexes/materialized views), not individual statement tuning. The main screen and alert log are for monitoring, not targeted SQL optimization.

Keep practicing — related questions