This blog is about understanding how Oracle database works.The learning process never ends and this is espeacially true when one tries to understand what is hidden in the magic box called Oracle database.

Wednesday, 5 October 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.

Sunday, 2 October 2011

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.

Friday, 30 September 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.

Thursday, 24 March 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.

Saturday, 26 February 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.

My training seminars

About Me

I have more than 20 years of experience in working with Oracle products. I began in 1988 with Oracle Database version 4 while working for the City of Ljubljana, where I had charge over the city's municipal and geographic information systems.

More recently, I have specialized in performance optimization, having developed my own tool set for monitoring performance and analyzing trace files.

In addition to sharing my knowledge through conference talks, I am conducting technical seminars organized either by Oracle University or myself.

I am very proud of two highly respected memberships: OakTable network in 2005 and Oracle ACE in 2009 and Oracle ACE Director in July 2010.

When not working with Oracle products I enjoy flying as private pilot (PPL(A) with night rating) with my Mooney M20E year 1966, call-sign G-ATOU. Prior Mooney I had an old Piper PA-28-140B Cherokoee, call sign D-EHFK and I have crossed almost all Europe with her.