Wednesday, December 23, 2009

Podcasts, Optimizer, PeopleSoft, APEX, DBFS, Index Performance, Performance, EBS, Charity

Oracle Podcasts

It's three AM. You can't sleep. You need to do something useful that will also help you sleep. Subscribe to Oracle podcasts!

Just kidding. There are a lot of really good podcasts listed here, including some by suchleading lights of our technical realm as Tom Kyte.

Optimizer: Moving from 9i to 11g

A lot of production systems are moving to 11g and one of the key factors, particularly when moving from older versions of the RDBMS, is changes in optimizer behavior. The Inside the Oracle Optimizer blog has an excellent posting on the subject.


This posting at the The PeopleSoft DBA Blog is on an aspect of SQL tuning of particular interest to PeopleSoft DBAS: Hinting Sub-Queries on Oracle.


David Peake lets us know that APEX 4.0 early adopter is now available.

And Joel Kallman has a few notes on the new release for us at his blog here.


Kevin Closson is embarking on a series of postings about the 11g feature DBFS, starting with The Oracle Database File System (DBFS). It’s Not An “Exadata Feature.” – Part I.

Index Performance

Some fine points of index statistics over at the Striving for Optimal Performance blog, particularly interesting if you are using partitioning.


From the specific to the general, Tanel Poder has some thoughts on a posting from Cary Milsap we linked to previously here at the Infogram.

Continuing the performance vibe, Alejandro Vargas has some scripts for assessing IO for us here.

And one last performance article, this time on data warehouses over at the Structured Data blog: The Core Performance Fundamentals Of Oracle Data Warehousing – Balanced Hardware Configuration.


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


Each year at the holiday season I bring my favorite charity to my readers' attention. This year that charity got an incredible boost from CNN. After CNN ran an article on Modest Needs the charity got a flood of contributions. With the economy what it is, more money is going to be needed and appreciated. You can give once or set up a monthly contribution, and Modest Needs is often able to double, sometimes even triple that donation through matching grants. Please have a look!

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.