Thursday, February 12, 2009

Optimizer, EBS, APEX, MIX, Indexing, PL/SQL, Hyperion and OBIEE, RDBMS

Optimizer

After concluding a great series last week, the Inside the Oracle Optimizer blog is keeping up the quality, this week with a posting on  Maintaining statistics on large partitioned tables.

This week from the Oracle E-Business Suite Technology Blog:


APEX

The David Peake on Oracle APEX blog announces that: 


MIX

Are you in Oracle Mix? It's a great place to share ideas with other users and Oracle, praise, complain, network, you name it. https://mix.oracle.com/

Indexing

Richard Foote's Oracle Blog has some wisdom on Updates and Indexes, Part 1 here, and Part 2 just came out.

PL/SQL

Tyler Muth is looking for some help testing a very useful piece of code at this blog:


Why not help out?

also in the realm of PL/SQL this week, there's a discussion of the performance impact of the NOT NULL constraint in PL/SQL over at The Momen Blog.

Hyperion and OBIEE

The Ritmann Mead Consulting blog details some experiences with combining Hyperion and OBIEE, a pretty common scenario these days.

Another great article recently from Ritmann Mead was this one on OBIEE High Availability - Presentation Services and Scheduler.

RDBMS

Tanel Poder's blog has a good posting on When was a table last changed?

Make sure you look down in the comments, too, where there are some other valuable pointers on getting this done faster and in various versions of the DB.

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.