The Oracle Sponge

Oracle Data Warehouse Design and Architecture

Archive for April 15th, 2005

“Open Source” Oracle Books

Posted by David Aldridge on 2005-04-15

I’m thinking (well, actually planning) of getting a project started to electronically publish a series of manuals/books on Orlacle* subjects along an “open source” framework. So we’d start off with some small-ish basic books on specific subjects (partitioning, installation, SQL tuning etc) and allow further development on them in an open fashion, with full credit given for enhancements.

Any ideas on feasibility/licensing/anything else gratefully received, offers of interest for authoring even more so.

* Tom Kyte (who he?) questions the spelling of this word. I’m going to credit him in this footnote with being a nit-picker and a busy-body, and also with demonstrating the exact principle which I think would make this idea work :)

Posted in Uncategorized | 16 Comments »

Back On Burleson!

Posted by David Aldridge on 2005-04-15

Don has restored my access at his forum — see you there, men.

Posted in Uncategorized | 5 Comments »

Why Large Segment != Large Block Sizes (necessarily)

Posted by David Aldridge on 2005-04-15

Because if a session is going to read a high proportion of the table/index/partition thereof then it ought to be using parallel query, and that bypasses both the buffer cache and the regular read mechanism.

With index-based access this doesn’t apply of course, but with index-based access the number of LIO’s on the table is not reduced anyway.

How does that sound for succinctness?

Posted in Uncategorized | Leave a Comment »