dbms_xplan.display_cursor

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

Read more >

DBMS_SQLTUNE

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

Read more >

Last DDL in Oracle

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

Read more >

AIOUG-Sangam

General

For the first time in India we had an All India Oracle Users Group(AIOUG) meet “SANGAM 09 – Meeting of Minds” from 8th-10th Sept.It was a wonderful experience. Some key speakers at the event were:- 1. Thomas Kyte – Whom everyone knows. 2. Francisco Munoz Alvarez (Oracle ACE) – founder and CEO of DBIS. 3. […]

Read more >

About Me..

Uncategorized

Hi All.. I am Anand Prakash.I am working as an ORACLE DBA and this is my first blog and I’ll attempt to share some of my experiences with Oracle over this blog.Let’s see how everything goes here. Cheers 🙂 Anand

Read more >