Thursday, March 6, 2008

Dynamic SQL , Performance

11g New Features

A nice update on dynamic SQL enhancements in 11g at


Several new items available from Richard Foote of late. More than most humans can comprehend on index compression, Part IV is here (and of course you can track back up the b-tree to the root article from there).

And a long and engaging article on Oracle diagnostic tools and their metaphors in life (with many links to other articles of interest along the way). The only thing I would add to the discussion is an aphorism from medical diagnostics that is my favorite reminder to myself when looking at a performance problem: 'When you hear hoof beats, think horses, not zebras'. In other words, no, it's not usually the freelists or the underscore parameters causing a problem, it's shaky SQL, or a database built on the sand foundation of a blatantly non-relational design.

No comments:

Official, Youbetcha Legalese

This blog is provided for information purposes only and the contents hereof are subject to change without notice. This blog contains links to articles, sites, blogs, that are created by entities other than Oracle. These links may contain advice, information, and opinion that is incorrect or untested. This blog, links, and other materials contained or referenced in this blog are not warranted to be error-free, nor are they subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this blog, links and other materials contained or referenced in this blog, and no contractual obligations are formed either directly or indirectly by this blog, link or other materials. This blog may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. The opinions and recommendations contained in this blog(including links) do not represent the position of Oracle Corporation.

Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.