Thursday, June 3, 2010

RDBMS Internals, Hyperion, EBS, I/PM, PeopleSoft/Unix, OPA

RDBMS Internals

In the course of researching a client problem I came across a good internals blog. Consider this article, which goes into how to examine the system state on a RAC system and concludes with some wisdom on caching in RAC sequences: Dynamic_plan_table, x$kqlfxpl and extreme library cache latch contention.
As always, Oracle internals is a realm that is somewhat abstruse, and when you have a problem the best thing to do is do a little MOS and Web research to see if there is an obvious solution and then open an SR at the appropriate level to get Oracle Support engaged. That way you are researching in parallel and, hopefully, will find a solution that much faster.


Over at Essbase Labs there's posting pointing out the advantages of a new Smart View function:


The Oracle ECM Alerts - Product News & Information has a new course announcement: First-Global-Teach for the Oracle Imaging and Process Management 11g: Administration: San Francisco | June 23-25

PeopleSoft and VIM

This is useful to any UNIX user, not just the PeopleSoft types: Using Vim to Count Patterns.


Oracle Policy Automation is another of those interesting products that we've acquired (it started out life called Haley). See more about it here at the SOA@Oracle SCA, BPEL, BPM & Service Bus blog: Oracle Policy Automation (OPA) on Linux


Richard Foote, the doctor of indexes, the professor of the vtree and guru of the mapping of bits, has a posting on the improvements to bitmap indexes from 10g forward: Bitmap Index Degradation Since 10g (Fix You)

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.