Re: Designing indexes

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 9 Feb 2006 10:43:20 -0800
Message-ID: <1139510600.882329.253930@z14g2000cwz.googlegroups.com>

Hans gave you a good answer and unfortunately it's the only one we really have right now.

Have you read Cary Millsap's book Optimizing Oracle Performance? Cary has a proven methodology to help drill into performance problems.

With so many tables in your environment, you need to prioritize somehow and start drilling into "only" the jobs/batch processes/extraction and load that are important enough to spend time and money improving.

Again Cary's book is recommended in this area also.

The new oracle tool may help somewhat.

I think there are oracle bugs with the agent perhaps at your release level and environment. Received on Thu Feb 09 2006 - 12:43:20 CST