Wednesday, November 17, 2010

Oracle Infogram This Week: Performance, Exadata, MOS, EBS, Linux, RDBMS,


Performance

I was helping a client this week with some performance problems and ran across a good source on using plan stability in 10g at the Oracle related stuff blog: Plan stability in 10g - using existing cursors to create Stored Outlines and SQL profiles.

From the Oraclue blog we have a reminder to take at look at 'Mr. Trace', former Oracle VP and guru of the mathematical/methodical approach to optimization, Cary Millsap.

Local Indexes

Jonathan Lewis has another installment on his series on Local Indexes at this Oracle Scratchpad blog.

Exadata

Some very useful info (and some constructive criticism) on the control interface for Exadata at Kerry Osborne's Oracle Blog: Cellcli Command Syntax – Top 10 List. Also on Kerry's blog, though more in the realm of performance, are several articles on SQL Profile. This is a technique I never used before, but after seeing a client use it tonight to resolve a major Sev 1 situation I am now a believer. Here is what Kerry's blog has on the subject.

MOS Listing

The Oracle BI By Bakboord blog regularly runs some useful updates of the latest MOS items. Here's one: Oracle MOS HTML Update 14112010

EBS

The latest from the Oracle E-Business Suite Technology blog:

EBS R12 Sparse Mid-Tier Template for Oracle VM Now Available

Two New Options for Signing E-Business Suite JAR Files Now Available

11gR2 11.2.0.2 Database Certified with E-Business Suite

Using Physical Standby for EBS 12 Environments on 11g Databases

Oracle BPEL 10.1.3.5 Certified with EBS 12 on IBM Linux on System z

Oracle Linux Blog

Oracle has a new Linux blog.

RDBMS

Arup Nanda maintains a great blog. He also maintains some really handy tools for other DBAs. Consider this one (remember to test thoroughly and all the usual due diligence, of course, as Arup says this is for educational purposes only):

Tool to Add Range Partitions Automatically to a Table

Also there at Arup's blog this week is a redirect in case you can't find the My Oracle New Features series we linked to some time ago here:

My Oracle New Features Series on OTN

Speaking of handy tools from renowned bloggers, Kevin Closson is Reintroducing SLB--The Silly Little Benchmark.

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

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.