Thursday, January 21, 2010

PeopleSoft, SOA, EBS, Index Rebuilds, Performance

PeopleSoft

I just noticed a PeopleSoft Wiki out there. The wiki is one of the better concepts of the new Web 2.0 apps (think of how many times you've used Wikipedia in the last month and you'll see what I mean). So I submit for your consideration the (unofficial) PeopleSoft Wiki

Another item of interest this week is Performance Metrics and XML Reporting in PeopleSoft

 over at the PeopleSoft DBA blog.SOA

I'm happy to note that there are more SOA blogs out there by the day. Many of them are internal blogs with lots of nice grotty technical details. Example: A posting on How does Restricted Task Reassignment Work in SOA 11g at the Oracle SOA Best Practice And Troubleshooting blog.

EBS

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

Microsoft Office 2003 and 2007 Certified with Oracle E-Business Suite

BPEL 10.1.3.5 Certified for Prebuilt E-Business Suite 12 SOA Integrations

Deploying E-Business Suite on Amazon Elastic Compute Cloud (Elastic clouds? Sure hate to see a non-elastic one. It would be a great challenge to air travel)

Oracle Internet Directory 11g (11.1.1.2) Certified on Eight New Platforms for EBS

Index Rebuilds

I was going to title this 'Index Rebuilds, For or Against', but I can't really find articles and discussions from Oak Table members favoring regular rebuilds. Of those who do advocate them, some seem to be in a very limited subset of large data warehouses with very specific load routines that do benefit from the rebuilds. the prevailing sentiment of other postings seems mainly along the lines of: Well, we've always done that, and it's certainly no harm. Well, I'm not sure it's no harm. If you are doing regular index rebuilds please dig around in the following articles and discussions and judge for your yourselves:

http://richardfoote.wordpress.com/2009/11/12/1094/

http://richardfoote.wordpress.com/2009/10/28/rebuilding-indexes-every-sunday-afternoon/

Options from Jonathan Lewis:

http://jonathanlewis.wordpress.com/2009/09/15/index-explosion-4/#more-2096

http://jonathanlewis.wordpress.com/2009/01/04/index-rebuild-again/

http://jonathanlewis.wordpress.com/2007/09/16/index-rebuild/

Performance

Want to see the leading lights in Oracle performance gathered in one place, many of them holding beers and eating BBQ? Consider the Hotsos 2010 Symposium. This is always one of the best conferences of the year. Remember that it is limited to 500 participants, so you may want to sign up sooner rather than later.
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.