Oracle Scratchpad

July 13, 2008

Sorted Hash Clusters

Filed under: Execution plans, Infrastructure, Tuning, trace files — Jonathan Lewis @ 9:25 pm UTC Jul 13,2008

[Forward to Part 2]

Towards the end of April, I published a note about manual optimisation,  and mentioned in one of the comments (#19) that as part of the discussion of the (slightly suspect) mechanism I had introduced I would eventually get around to talking about sorted hash clusters. So I’ve finally managed to make a start.

(more…)

Interesting notes

Filed under: Uncategorized — Jonathan Lewis @ 7:35 pm UTC Jul 13,2008

This (Oracle-related) blog site caught my eye a few days ago. There isn’t much on it at present, but what’s there is worth reading, so I thought I’d post a pointer to it for a few days.

 Updated 13th July.  Randolf Geist has started to work his way through the test scripts that I supplied with my book Cost Based Oracle – Fundamentals, posting details of any interesting changes on his blog.  The first results are on a posting dated 27th June – currently the second posting.

Blog at WordPress.com.