Thursday, January 8, 2009

Indexes, Security, Internals, EBS, PUP, Workflow


Indexes

Yes, more answers on the mysteries of the inner workings of Oracle indexes from Richard Foote, doctor emeritus of indexology (some would call it indexomancy).

Security

It's a new year, and a good time to do a quick security audit. Pete Finnigan's blog is always a place to find some good tools to hammer your own system before someone else does. And Slavik's Musings on Database Security has a Fuzzer utility to play with. As he notes ONLY TO PLAY WITH ON A TEST SYSTEM YOU DON'T CARE ABOUT LOSING.

Internals

When you want to get inside Oracle and shine a flashlight around (torch for our UK readers), Tanel Poder is the man to lead the way. In this posting he gives us a quick intro to a very powerful analysis tool used by Oracle Support: Heapdump analysis, including a script to parse the heapdumps. Ok, you're still going to need Oracle Support to confirm your diagnosis and Oracle Development to fix bugs in the code, but if you can find details yourself going into an SR that gives you a major tactical advantage; not to mention the bragging rights. It's like someone who pops open the hood of the car and speaks directly with the on-board electronics. Sure the car still doesn't run, but everyone around you is deeply impressed.

EBS

From the Oracle E-Business Suite Technology blog this week:

Ready for Internet Explorer 8? Well man the bastions, because it's likely to break even more stuff than IE 7: Block Microsoft Internet Explorer 8 for EBS Users

In other EBS news:




PUP

PUP, the Product User Profile table is an interesting 10g feature I'd not heard of. This posting at the Global Oracle Contractors Blog goes through it in some detail. If you need to grant some heavy duty privileges but still need to sleep well at night it might be something to look into. You can restrict drop table, for instance.

Workflow

Workflow, the process that leads to profit, is a vital Oracle product for your business. The AMIS Technology Blog has a series going on learning Workflow. Part two is out there now, and you can find part one right here. 


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.