Oracle External Tables

External tables can read the flat files as though they are normal oracle tables. Therefore it is convenient to use external tables to load flat files in to DB

SQL Tuning Advisor - DBMS_SQLTUNE

-- Create a tuning task
DBMS_SQLTUNE.create_tuning_task

-- Execute a task
DBMS_SQLTUNE.execute_tuning_task

-- Report of a task
DBMS_SQLTUNE.report_tuning_task

-- Interrupt a tuning task.
DBMS_SQLTUNE.interrupt_tuning_task

-- Resume a tuning task.
DBMS_SQLTUNE.resume_tuning_task

-- Cancel a tuning task.
DBMS_SQLTUNE.cancel_tuning_task

-- Reset a tuning task allowing it to be re-executed.
DBMS_SQLTUNE.reset_tuning_task

-- Cancel a tuning task.
 DBMS_SQLTUNE.cancel_tuning_task

--Check the status of a task
SELECT task_name, status FROM dba_advisor_log WHERE owner = 'SCOTT';

TASK_NAME                      STATUS
------------------------------ -----------
emp_dept_tuning_task           COMPLETED

1 row selected.