The yearly ODTUG Kaleidoscope is one of my favorite conferences to go to. Besides the really good sessions, there is always lots of time for networking.
This year it will be held in Washington, D.C..
Analytic Functions Revisited
Even though Oracle has enriched SQL with Analytic Functions a long time ago, they are still relatively unknown. Analytic Functions add inter-row calculations, aggregates over multiple dimensions, or rank assignment based on values within a group of values - all without a GROUP BY clause. They can make your life as a developer a lot easier once you get Analytic Functions in your fingertips. Even though the syntax may seem daunting at first, it becomes second nature very quickly. Oracle 11gR2 brings you new and exciting Analytic Functions.
This presentation will cover the syntax and is packed with real life examples of how to apply them on a daily basis.See the performance increase with just a few lines of code and bring you sheer development joy.
SQL Holmes - The Revisited Case of the Missing Performance
During Kaleidoscope 2009 a case study was unfolded to investigate the cause of a slow performing query. In this presentation we will revisit this case and investigate further possibly leading to a solution for the Missing Performance.
Did the database just "have a bad day"? Was the evil DBA to blame? The PL/SQL developer who didn't get enough coffee? Or was it the application sending the "wrong" query in the first place?
In this classic "whodunnit" you will take a tour past the crime scene. Investigate the query, use the tools of the trade and collect all the relevant information. Follow the trail to uncover the truth and nothing but the truth...
We'll see if I have to prepare for one or two presentations when the time comes....
Hope to see you there.