Wednesday, March 19, 2008

New Blogs, Index Storage, Performance, Storage

New Blogs

Richard Foote found a new Oracle-related blog, the Oracle Multimedia Blog. Great photo there. Something along the lines of 'Tony Soprano manages the DB'.

Scott Spendolini points us to a new APEX blog, from Jason Straub.

Index Storage

Ok, get ready for a major battle between the performance folks over this. Many authors of performance books maintain that storing indexes in larger block tablespaces will get you a performance boost. Richard Foote bursts that bubble, and backs it up. Expect a mild-to-medium roast flame war to arise on the subject.

Performance: Bind Peeking

The Pythian Group blog brings us a very useful article called Stabilize Oracle 10G’s Bind Peeking Behaviour by Cutting Histograms If you are experiencing unstable optimizer plans in 10g this is definitely worth investigating.

Storage: Flash

Flash memory, otherwise known as SSDs (Solid State Disks) have been in the wings for years. Large DB operators with massive transaction rates have used them (in spite of the heavy cost) to manage high demand spots in the system like redo logs. Everyone else has been conjecturing about how nice they would be to use if 'normal' companies could afford them. The Storage Mojo blog brings us an excellent summation of the situation now with a glance to the future.

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.