2080 12

Database Administration20805 marksSQL Tuning Advisor usage

Explain how SQL tuning advisor can be used to tune your database.

Explain how SQL tuning advisor can be used to tune your database. [5]

--- SQL Tuning Advisor is an Oracle Database built-in diagnostic tool that automatically analyzes SQL statements and provides recommendations to improve their performance. It acts as an expert system that examines problematic SQL and suggests tuning actions. --- - The DBA first identifies poorly ...

Up nextWhat are different database administration tasks? Explain Oracle Data Guard in brief.