Wednesday, September 29, 2010

Oracle Infogram This Week: EBS, Chrome, DB Stories, Scripting, DBA Tasks


Some valuable links at the E-Business Suite Technology blog:

E-Business Suite TechnologyStack Roadmap (Sept 2010) Now Available

Upgrading From EBS R11i to R12 Using a Staged System

Something you learn early on as a DBA is that there are a lot of IT people who think indexes solve everything, therefore more indexes are automatically good. This simplistic approach sometimes creates monsters, tables bedecked with layer upon layer of optimizer-confusing, I/O-slamming, unneeded indexes. Here is an interesting posting of some basic tests on EBS indexing by someone studying the specific question of custom indexes in EBS.

Search Utilities

Eddie Awad has a good update to his Oracle related search engines in Google Chrome at his blog.


Oracle Musings brings us a tale of woe and redemption in the world of accessing the DB: Locked Out.


Charles Hooper has a very valuable article on setting up an easy method for building Oracle database test case scripts at his Oracle Notes blog.

DBA Tasks

One of the items that sometimes causes DBA angst is covered over at the Oracle related stuff blog: Cleanup of partitioned objects residing in offlined tablespaces.

Over at the Oracle Sponge we have a posting on another topic that often plagues designers and DBAs (often plaguing the designer, who in turn plagues the DBA):

Generating A Gap-free Series Of Numbers — Not Always A Problem

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.