SQL tuning advisory (DBMS SQLTUNE package) in Oracle
How to use SQL tuning advisory in Oracle SQL tuning advisory is the package available in the oracle for tune the SQL Query. It will provide the suggestion regarding the SQL Query to improve its performance by gathering stats, creating index and change execution plan. Steps to run the SQL Tuning Advisory for SQL Query 1. Create the SQL tuning advisory TaskPut the SQL text in the below package…



















