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.

Organizing Chris Date's seminar in Ljubljana May 23-24 2011

I have invited Chris J. Date, an independent author, lecturer, researcher, and consultant of international renown, specializing in relational database technology, to have a 2 day seminar "How to Write Correct SQL and Know It: A Relational Approach to SQL". The 2-day seminar will take place in Ljubljana, Slovenia, on May 23-24 2011.

Chris is best known for his book "An Introduction to Database Systems" (eighth edition, Addison-Wesley, 2004), which has sold some 725,000 copies and is used by several hundred colleges and universities worldwide.
For more details about this seminar please read on my home page.

Why this seminar? So many times I am involved in performance troubleshooting and in more than 80% of all cases the fault is bad design and poorly written SQL statements. With organizing this event I would like to give a good opportunity to all developers (either on Oracle database or any other database) to get more theoretical knowledge about SQL.