Search

Top 60 Oracle Blogs

Recent comments

#ClubOracle

Oracle Midlands : Event #14 – Summary

Last night was Oracle Midlands Even #14 with Lothar Flatz.

The session started with “Raiders of the Data Dictionary I: Indexing for the Workload” where Lothar discussed a project he worked on based around completely revamping the indexing of a system. I guess the best way I can describe it is to say it’s a more scientific approach to indexing, using the contents of the dictionary to provide information about columns and column groups used in queries to determine the indexes to create. In some ways the approach was quite extreme (throw everything away and start again), but I also admire the bravery of that approach!

Oracle Midlands : Event #14

Tomorrow is Oracle Midlands Event #14.

om14

Please show your support and come along. It’s free thanks to the sponsorship by RedStackTech.

Cheers

Tim…


Oracle Midlands : Event #14 was first posted on March 14, 2016 at 11:33 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Oracle Midlands : Webinar

Just a quick reminder about tonight’s Oracle Midlands Webinar.

om-webinar

Cheers

Tim…


Oracle Midlands : Webinar was first posted on February 22, 2016 at 10:48 am.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

Oracle Midlands : Event #11 – Summary

oracle-midlandsLast night was Oracle Midlands event #11 with Chris Antognini.

The lead up to this event was not the best for me. I had been on the verge of a headache all day. By 14:00 I gave up, went home and went to sleep for a couple of hours. It wasn’t great, but it was just enough to take the edge off, so when the time came, I felt sort-of OK to head out for the event. The drive started to convince me this wasn’t the best move, but once I got to the event and sat down I figured I was going to make it. :)

Chris did two talks at the event.

Oracle Midlands : Event #10 Summary

oracle-midlands Last night was Oracle Midlands Event #10 with Jonathan Lewis.

The first session was on “Five Hints for Optimizing SQL”. The emphasis was very much on “shaping the query plan” to help the optimizer make the right decisions, not trying to determine every single join and access structure etc.