Thursday, April 30, 2009

BI, Performance, PL/SQL, EBS, 11G I/O, PeopleSoft, DW


BI


Performance

Another great performance item from Tanel Poder, this time on using DTrace for t.racing Oracle SQL plan execution.

APEX

When in doubt, just start churning out your own code, right? Why reinvent the wheel? Scott Spendolini found what he wanted to do was already in the APEX API and discusses it in Returning a Value from a Popup Page.

PL/SQL

Bulk collect is a method for gathering processing, increasing efficiency. Over at the Systems Engineering and RDBMS blog there is a posting on Bulk collect record collection of interest. What do you think? Agree? Find some hidden problems with the method? Please put comments in our Infogram blog or at the original blog site of the posting.

EBS

This may be old hat to experienced EBS DBAs, but if you are looking for a good series on patching, this one over at The Pythian Group blog has some good info on keeping track of patching: Oracle E-Business Suite: Querying Patches, Part 2

This week at the Oracle E-Business Suite Technology blog:


11G I/O

Kevin Closson has some words of wisdom on How To Produce Raw, Spreadsheet-Ready Physical I/O Data With PL/SQL. Good For Exadata, Good For Traditional Storage. As reflected in the comments, this method is intended for 11G. 

PeopleSoft

Over at the PeopleSoft Tipster there's a good techie article on Applying homepage pagelets to others.

And on the DBA side of the house there is this posting on Reducing Unnecessary Instances of Temporary Records over at the PeopleSoft DBA blog.

DW

The Rittman Mead Consulting blog has some advice to bring DW designers back to earth on ETL design in this posting on Simple Steps to Sustainable ETL. Essentially, yes, you still need to design it, not just throw everything in product XYZ which the sales and marketing people insist will organize everything for you (and pick up your dry cleaning, and mow your lawn). It's an old, tired saying, but it applies in IT too: If it sounds too good to be true, it probably is.

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.