Last Friday I wrote about a client query that could be rewritten in a much more optimized manner. However rewriting it was a little tricky, involving a hierarchical query and a column that needed to calculate a value based on it’s parent, grand-parent, great-grand-parent, etc. Raj posted a very smart solution that used sys_connect_by_path to [...]
Accessing Arbitrary Ancestors in Hierarchical Queries
May 23rd, 2007 § 2 Comments
Encyclopedia Spine Problem
May 21st, 2007 § 4 Comments
Dominic just posted a hint to the encyclopedia spine problem he posted last week. Sheesh… personally I think the hint totally gave it away. Or at least it gave away one solution. Here’s what I came up with. I wonder if this is how Dominic solved the problem:
Combining Hierarchical Queries With Analytics
May 18th, 2007 § 9 Comments
Just a few days ago I was reading Dominic’s challenge to write a query that would give results like an Encyclopedia Spline. It apparently took over the entire day for another Dominic and I was planning to take it on myself too as soon as I had the time… but today another challenge came my [...]
Doug Burns on Oracle User Groups
May 17th, 2007 § 1 Comment
Just read Doug Burns’ interview from the Autumn 07 edition of AUSOUG‘s Foresight magazine. It’s a fun read; Doug talks about how he got into technology and Oracle, the strengths and weaknesses of the Oracle RDBMS, and his addiction to the command line. But the part that jumped out at me the most was his [...]
Chicago Oracle Users Group Meeting
May 16th, 2007 § 1 Comment
So we just had the spring COUG meeting. Two speakers this time, Charlie Garry from Oracle and Dean Richards from Confio. Oracle volunteered a meeting room; their offices are in the Sears Tower downtown. They also provided food. (Very cool!) Toward the end – after 5 or 6 people took off – I counted 24 [...]
Controlfile Recovery WITHOUT Resetlogs
May 15th, 2007 § 2 Comments
Well last week I had a few posts about controlfile recovery; one about recovering without a backup and one about recovering with a backup using RESETLOGS. In the second post I showed how when you restore a backup controlfile Oracle will always require you to recover then open the database with RESETLOGS. Hemant Chitale pointed [...]
Redo Log Filename Extension
May 11th, 2007 § 1 Comment
I have to say that I really like the oracle-l mailing list. It tends to stay pretty focused on DBA stuff, there’s a low volume of spam and there are a lot of really smart guys who post there. I was just catching up on some threads from last week and a comment about how [...]