Thursday, August 14, 2008

Dynamic Sampling, Performance, BI, EBS, Cache Protect , Indexing, Agility, SOA

Dynamic Sampling

Two good items this week on dynamic sampling, one at the Momen blog on using dynamic sampling with partitions.

and another from
the H.Tonguç Yılmaz - Oracle Blog on dynamic sampling and OLAP.

Performance in a Small Bundle

This single line script from Tanel Poder will get you a good start at seeing what's happening on performance for an Oracle instance:

event, state, count(*)
group by
event, state
order by
3 desc;
Very neat, and there's a prettified version with some explanations here at Tanel's blog.

BI Publisher

There's a new BI Publisher Consulting Blog out there, and they have a useful article on RTF Template Development.

EBS Patching and 11.5.9

A very handy post nailing down some aspects of patching as it relates to the end of
Premium Support for 11.5.9 in June 2008 at the Oracle E-Business Suite Technology blog here.

Cache Protect

Since we just got done setting the _db_block_cache_protect parameter paramater for an AIX customer to prevent redo corruption, I found it an interesting coincidence to find a blog entry today on precisely that rather obscure underscore parameter CAUSING problems for a Linux user. You can read about it here.


Like indexes? Richard Foote sure does. As I've said before he is Dr. Index. Here is his latest opus, on Indexes and NOT Equal.


A little Hyperion, a lot of business philosophy in this article by the Cubegeek.


I'll be highlighting several SOA blogs over the coming weeks. The first on is from Clemens Utschig - Utschig, one of the best SOA aces in the industry. Here's a link to his article on the patchset.

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.