CBO Days in Zurich December 11-12 , Switzerland

My dear colleague from OakTable Christian Antognini is organizing an excellent event called "CBO Days 2012" which will take place in Zurich in Switzerland in December 11-12.

I am really honored to be speaking together with great names of the Cost Based Optimizer (CBO) like Jonathan Lewis, Randolf Geist, Mohamed Zait, Maria Colgan and Christian Antognini.

I remember being the attendee at the first CBO Days back in 2006. Mohamed Zait was at time  already involved in the developing of the CBO and had several excellent presentations. It was a great opportunity to discuss with him the actual problems we had with the CBO at that time like the bind variables peeking only at the parse time and run-away queries. At the OakTable dinner we suggested him several possible solutions which were in subsequent years built in the database.

Such kind of events are great opportunity to get the knowledge which one can't really get at one place. Internet is a great source of knowledge, but attending a detailed technical presentation is something quite different. 

I expect that this event will be simply the best event totally focused on the problems of the cost based optimization.  

My public appearances in autumn 2012

The era of different conferences before the end of this year is here.
Last week I was speaking at Slovenian Oracle User Group Conference in Ljubljana and later on in the same week at Croatian Oracle User Group Conference in Rovinj.

Here is the list of my forthcoming public appearances:

SANGAM12, All Indian Oracle Users Group conference, Bangalore, India, November 2-3 2012, http://www.aioug.org/sangam12.php

BGOUG, Bulgarian Oracle User Group Conference, Pravets, Bulgaria, November 16-18 2012, http://www.bgoug.org/en

DOAG, German Oracle Users Group Conference, Nurnberg, Germany, November 20-22 2012, http://www.doag.org

UKOUG, UK Oracle User Group Conference, Birmingham UK, December 3-5 2012, http://2012.ukoug.org

Trivadis CBO Days 2012, Zurich, Switzerland, December 11-12 2012, http://www.trivadis.com/training/oracle-trainings/cbo-day.html

 

Oracle XML Training with Marco Gralike in Ljubljana

In last two years I have been involved in many cases when we had to troubleshoot performance for processing XML files. Due to this reason I decided to organize specialized training with the best expert for processing XML in Oracle database - Marco Gralike, my fellow from OakTable and also Oracle ACE Director.
The training is organized by my company DbProf d.o.o in cooperation with Slovenian Oracle User Group - SIOUG. The training will take place in Ljubljana, March 27th and 28th 2012. More about training agenda and the pricing is available here.

My Presentation "Getting the Best from the Cost Based Optimizer" at Oracle Open World 2011

Today (Tuesday, October 4th 2011) I had my presentation at OOW 2011 in Hotel InterContinental at 13:15 titled "Getting the Best from the Cost Based Optimizer". The room was already sold out on Thursday and I really expected to have a full room - cca 270 people. The room was too small for all who want attending the presentation. Although there were no seats available quite a lot of them were standing in the back.

This time my presentation was not very technical one (in my eyes). I just wanted to point out problems I see many times in real life when people don't really know about some features or behavior of the CBO. Unfortunately one hour was not enough to explain in details why things are going wrong and also show all relevant details. But as I said, the aim was to point out the problems and also give directions what one has to do to get rid of them and according to the reactions of the audience after the presentation the goal was achieved.

After the presentation I was answering the questions more than half an hour so I almost missed the meeting for the beta program of next release of the database. Because so many were interested to get the presentation slides I have uploaded it to my home web page immediately upon arrival at SFO airport.

Here is the abstract for "Getting the Best from the Cost Based Optimizer":
Oracle Database 11g brings many new enhancements to PL/SQL. These will improve the performance, functionality, and security of your applications and will increase your productivity as a developer. This session will present the Oracle database 11g new PL/SQL language features and enhancements that can be used to improve programming functionality, performance and usability. Participants will learn about new trigger options, PL/SQL function result cache, bulk binding, new security features and more.

The agenda was:

• Misused Initialization Parameters & System Statistics
• Extended Statistics
• Cost of execution of PL/SQL functions
• Constraints
• SQL Plan Management
• SQL Monitoring
• Automatic Cardinality Feedback Tuning

The presentation is available here for download, but you must be registered.

Flying over Golden Gate bridge

Saturday was perfect day for activities not related to the Oracle Open World 2011 event. So I decided to do my first flying in USA. The details about this 1h20 long flight are available in my blog about flying.

Flying Over Golden Gate at OOW2011

Oracle Open World 2011

This year I have the opportunity to attend Oracle ACE Directors briefing before the Oracle Open World 2011 event which is taking place at Oracle Headquarters. It is great to get almost all important things which will be announced in several days packed together and communicated by those responsible people in Oracle. So I am really thankful for this opportunity. A lot of ACE Directors gathered here and it is nice to meet old friends and make personal contacts with all those who we know only by name.


My presentation titled "Getting The Best From The Cost Based Optimizer" is on Tuesday, October 4th at 1:15 PM in InterContinental - Grand Ballroom B and it looks like the room will be full so come there on time to get your seat.

Update on Chris Date's Seminar in Ljubljana May 23-24 2011

The registration for the seminar is now open and there is a substantial early bird registration discount. Beside this the members of Slovenian, Croatian and Serbian Oracle User Group have additional discount. Please see the details on www.dbprof.com about the seminar registration.

I tried really hard to organize this unique event at the affordable prices for everybody especially in times when the financial crisis is still striking the budget for education.

Interesting opinion about Chris Date's seminar in Ljubljana was published today by Dejan Sarka, worldwide known Slovenian expert for Microsoft SQL server . He wrote: "Well, IMHO C. J. Date is the most important contemporary theorist on the Relational Model. If there is a single person in the world I would like to listen, this is Date." ..."If you have opportunity to join the Date's seminar, do not hesitate! it is a unique opportunity, and I find the price, thanks to great organization of the DbProf company, very attractive." Details here. Because he is a speaker at Slovenian NT Conference which is unfortunately taking place at the same time, he is not able to attend this unique event.