Thursday, February 11, 2010

Hyperion, EBS, RDBMS, BI, PeopleSoft, Performance, Indexing


The "in 2 Hyperion" blog is offering a tool to its readers for Generating Random Sample Data. That's a handy thing. The trick is getting management to believe that the random data is actually your company's data and that things are really looking up. So perhaps you should just use it for simulating data.

Tim Tow found a 'touchy spot' in Essbase that he is sharing. It's a point in the API where a space, or the lack thereof, actually makes a difference. Such moments make me remember why I moved from developer to DBA. Though I've found plenty of touchy spots in database scripts, etc. over the years as well.

Over at Essbase Labs they are continuing their excellent series of tips on Smart View Features You Never Knew Existed: NumericZero.


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


One of the best Oracle resources on the Web is AskTom. If you haven't used it, your really should. You can usually find what you need in the archives. But on the off chance that your question has not been addressed before you can Ask Tom (as in Tom Kyte, Oracle VP and uber-guru). Here is a sample exchange from the recent


Over at A BI Publisher developer's diary... there is a good hint to be found on Can we recover the failed Bursting cases? (wow, that sounds painful).


A new blog in the PeopleSoft realm, JRE Consulting, looks to have some interesting material. For instance: Using setup manger to generate a GP task list

Book Review: Application Performance

Christian Antognini has good things to say about The Art of Application Performance Test from O'Reilly. Have a look at his review here. As always, there is plenty of interesting performance lore to be found at Christian's blog, such as this article on Query Optimizer Cost PX Distribution Methods.

Speaking of performance books, there's a new book out, Expert Oracle Practices: Oracle Database Administration from the Oak Table, and it's getting good reviews so far: Expert Oracle Practices: Oracle Database Administration from the Oak Table


Richard Foote is starting another excellent series on indexes. First he is preparing the ground with some information on Index Block Dumps and Index Tree Dumps

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.