Thursday, November 13, 2008

Indexing, Hotsos, Optimizer, JavaScript, PeopleSoft, EBS, RPM


Indexing

As is often the case, Richard Foote has a posting at his Oracle blog that gives some great insights on indexing, specifically fragmentation and duplicate entries.

Speaking of indexing, Mark Rittman at the Rittman Mead Consulting blog has a great article on bitmap indexes with some links to further reading.

Hotsos

The Striving for Optimal Performance blog reminds us that March of 2009 is on the horizon, that time of the year when all the performance gurus converge on Dallas for the Hotsos symposium. That's why that week is known as 'slow DB week'.

Optimizer Modes

First_rows_n for an OLTP system or all_rows? Which do we use for our Oracle optimizer? It's one of those great ontological questions like dry rubbed ribs or sauce (or both)? Well, Jonathan Lewis has some incite at his Oracle Scratchpad blog. I haven't linked to his blog in a while, so you may want to read down through some of the other postings, which are always top quality (like this posting on PX Buffer, with lots of grotty internal details).

JavaScript

A good tip on saving lots of time when working on a JavaScript local file over at Tyler Muth's blog.

PeopleSoft

The PeopleSoft Tipster blog gives us a glance at what the PeopleTools 8.5 future holds for us: Features!

And if you have some time to fill and really yearn to virtually install PeopleSoft the PSST0101 blog has the series for you.

EBS

Gareth Roberts over at the In Depth Apps - Oracle eBusiness Suite blog shows us how to turn loose Greasemonkey on your EBS homepage. He has a video, but I couldn't see any monkeys at all.

RPM

Alejandro Vargas brings us the good news that the Oracle validated RPM for Linux is available. Just add water and it will puff up like one of those little sponge dinosaurs, rearing up into a ferocious RAC-ready server.

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.