dbms_xplan.display_cursor

Posted Leave a commentPosted in Oracle

Never too late today i thought to learn and know about  using the packaged function DBMS_XPLAN.DISPLAY_CURSOR (as i was trying to tune the query :)). The DBMS_XPLAN package had 4 table fuctions : 1. DISPLAY :- formats and displays the contents of the plan table, 2. DISPLAY_CURSOR :- formats and displays the contents of the […]

DBMS_SQLTUNE

Posted 1 CommentPosted in Oracle

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 ( […]

Last DDL in Oracle

Posted 3 CommentsPosted 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: – […]