Thursday, February 28, 2008

BI on JDE, Oracle Patching, Scripts, Optimizer

BI on JDE

The JD Edwards blog has a link to a free seminar on setting up BI on JD Edwards.

Patching

The actor David Niven gave an interview once where he said: 'After you reach 50, it's just patch, patch, patch.' Software doesn't even have to wait that long.

Chris Warticki noticed that a very important document on Oracle patching policy has been updated. This is good one to print out and refer to (it also has a good glossary of the sometimes arcane terminology used in the patching process). It's on his Oracle Support blog here.

Scripts

No matter how 'webby' you get, good old honest command line scripts are still key elements in the DBAs toolbox. Kevin Closson's blog reminds us this week of an excellent source of those scripts, Morgan's Library.

Mysteries of the Optimizer Unveiled

The Inside the Oracle Optimizer blog has a pointer to a new whitepaper on OTN about what to expect from the optimizer when moving from 9i to 10g. I've seen a lot of clients over the years go through this changeover, and I wish I'd had this paper to give them to work with up front. If you're about to move, or you already moved and wonder why some peculiar things are going on with some of your query plans, please give this paper a read.

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.