Wednesday, April 27, 2011

Oracle Priority Service Infogram This Week - 27-APR-2011

Star Transformation

No, it's not what happens to participants in American Idol, it involves warehouse work. One of the key concept's of Oracle data warehousing SQL is star transformation. Read some of the details over at Jonathan Lewis' Oracle Scratchpad blog (as with most things involving the optimizer, things get a bit complex): Star Transformation.

Also in the realm of data warehousing is this item on OWB 11gR2 – XML at the Oracle Warehouse Builder (OWB) Weblog


Oracle offers a variety of webcasts every week on OEM. Here's a link to the latest: Increase the ROI of Your SOA Infrastructure with Oracle Enterprise Manager 11g.


Now that is out people are starting to work with it and coming up with great postings like this Planning - Exporting metadata over at the More to life than this... blog.


Need to impress people at a cocktail party? Discourse on delayed block cleanout. But don't dwell on it a lot or you'll lose the crowd. You can research it at the Oracle related stuff blog: Delayed Block Cleanout / ORA-01555.


Some coding knowledge for PL/SQL users over at Andrejus Baranovskis's Blog: Invoking Stored Procedures and Functions with Named Variable Parameters.

Lifetime Support for Sun

Soporific but useful, the official word on Oracle's Lifetime Support for Oracle Sun System Products.


Some useful items on WLS security. This one from Oracle Fusion Middleware Security on SSL offloading and WebLogic server.

And from Middleware magic: Securing the WebLogic Server .

Sequences vs. Sequence Tables

Those of us who have been working with Oracle for some time know that there are sometimes transaction systems that absolutely, positively, have to keep assigned sequences in order and without dropping numbers out. That can be difficult with Oracle sequences. But if you use a sequence table you build yourself you are blown into the dangerous waters of very high volumes of commits and a potential I/O hotspot on the table. So what do you do? I did some preliminary research on just that this week for a client and wanted to pass along pointers to the discussions I found of the most interest:

Old, but from the grand master, Tom Kyte:

A newer discussion involving and recommending Streams on the picture:

A related discussion from Charles Hooper, an Oak Table performance guru:

The most interesting link I've found so far:

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.