Oracle Database Webinars Video Archive

Hi all, A very quick note about the webinar's conducted at All Things Oracle on Oracle technologies presented by many well known Oracle gurus and experts. If you have missed the opportunity to attend the live webinars, here is the link to listen to the recorded webinar, additionally, you can also download the presentation (PDF format):

http://www.red-gate.com/products/oracle-development/deployment-suite-for-oracle/webinars/webinar-archive

Enjoy the presentations.

Regards, Jaffar

My upcoming webinar on 11gR2 clusterware upgrade

Hi everyone,

A very quick update about my upcoming webinar on 9th Feb 2012 titled 'Upgrading to 11gR2 - a case study' where I will be sharing all my experience, tips and techniques of a successful 11gR2 upgrade project. The upgrade project gave us an opportunity to work with 4 cluster environments with nearly 400 databases, a complex environment.It was indeed a roller coaster journey. Be there to feel the real experience.

Glad to know that over 260 people have enrolled so far for the session and expected to be more in the coming days. If you have any upgrade plans in place or doubts over 11gR2 upgrade proceedings, do not let this opportunity go away, enroll yourself now here

Look forward seeing you (virtually)  people at the presentation. I would like to thank you James Murtagh, Marketing Manager Red Gate Oracle Tools for arranging this webinar.

Best Regards,

Jaffar

An easy way to obtain 10053 trace

I have just learnt a couple of new methods to obtain an Optimizer (10053) trace for any sql statement that is already in the cache, without actually executing it and also enabling 'events infrastructure'. With 11gR2 onwards, you can either use the DBMS_SQLDIAG.DUMP_TRACE package procedure or use new diagnostic events infrastructure to obtain the 10053 trace for a given sql_id.


Demonstration 1:


1. Find out the sql_id for the given statement:


SELECT sql_id,child_number FROM v$sql WHERE sql_text LIKE '%SQL TEXT%';


2. Input the sql_id to the DBMS_SQLDIAG.DUMP_TRACE package procedure:


execute DBMS_SQLDIAG.DUMP_TRACE(p_sql_id=>'sql_id',  p_child_number=>0, 
p_component=>'Compiler',
p_file_id=>'ABCD');


Trace file with ABCD post fix can be found under $ORACLE_HOME/diag/rdbms/dbname/instance_name/trace directory.


Demonstration 2: (excerpt from MOS Note)

SQL> alter session set max_dump_file_size = unlimited;
SQL> ALTER SESSION SET EVENTS 'trace[rdbms.SQL_Optimizer.*][sql:sql_id]';

SQL> --Execute the query --

To disable the trace

SQL> ALTER SESSION SET EVENTS 'trace[rdbms.SQL_Optimizer.*] off';





Refer to MOS ML: 
How to Obtain Tracing of Optimizer Computations (EVENT 10053) [ID 225598.1]





Advt: Sangam11 - All India Oracle User's Group annual conference

Sangam11, AIOUG's annual conference kicks off on 9th December 2011 for two days, a very good opportunity not to miss if you around in India! Third time in a row AIOUG is conducting the annual conference SANGAM with several world's best known Oracle speakers. Last year, it was Jonathan Lewis and this year it is going to be world renowned Expert Arup Nanda who will be the Key presenter and delivering 2 half day session for this conference.

Though I couldn't make it to present this year, I would recommend all who exists in India not to miss the opportunity to listen and meet the world best Oracle expertise on this conference.

For more details about the conference visit here.

Good luck and keep smiling...

Jaffer

Topic for RAC cookbook

Hi everyone,

Perhaps, I could be the first person(please excuse me if I am wrong in my perspective) who would ask the readers about what contents/topic they would like to foresee in a RAC cookbook. Well, I am planning to co-author a new RAC book, tentatively titled 'Oracle 11gR2 cookbook' and I would like you (my readers) to help me and yourself putting forward your inputs/views about the contents that you wanna have in the book.

I knew there are a several good books exists on RAC topic in the market, however, we would like to develop a cookbook which would be very handy, full of practical expertise and very rich in contents so that DBAs could use the book as a reference in their day-to-day practical life. Please take moment to express your thoughts on this point.

Look forward receiving your positive inputs.

Once again, wishing you and your family a very happy EID in advance...

Jaffer