The DBMS_SQLTUNE package helps us tune the SQL statements.One can run the SQL Tuning Advisor using DBMS_SQLTUNE package.The steps involved are:- 1. Create the Tuning Task. 2. Execute the Tuning Task. 3. Report Tuning Task. The tuning task can be created from the AWR SET SERVEROUTPUT ON DECLARE l_sql_tune_task_id  VARCHAR2(100); BEGIN l_sql_tune_task_id := DBMS_SQLTUNE.create_tuning_task ( … Continue reading DBMS_SQLTUNE

Last DDL in Oracle

Many a times this question arises “HOW can I know when LAST DDL/DML was done??” So I thought to blog it.In this blog i will be writing only about last DDL.Last DML will be covered in next blog. Firstly, let’s see what DDL and DML mean in oracle (as per oracle doc) DDL statements: - … Continue reading Last DDL in Oracle