Wednesday, March 26, 2008

OraPerf, 11g Optimizer Tool, Delete vs. Truncate


Doug's Oracle Blog notes that is showing signs of life, after a long and painful hiatus. This was a very useful site where you could upload statspack reports and have them analyzed for free run by Anjo Kolk, renowned Oracle performance pubah (a pubah is one level above a guru, and normal gurus are required to say: "Ahhh! {insert pubah name}! Yeah, they're good." whenever one is mentioned). The good news so far is that I was able to register an account and confirm it. The bad is that the mechanism for submitting performance reports to analyze is still among the missing.

11g Optimizer Tool

Need another reason to consider 11g? How about the SQL Test Case Builder? You can read all about it over at the always-excellent Inside the Oracle Optimizer blog.

Delete or Truncate?

Both sound painful, but if you want a list of some of the less-encountered depths of the age-old question, see the Oracle Sponge Blog.

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.