FIX - Fw: Re: Perforamance problem on an Application running on top of Oracle 9
- From: patrick obrien <po04541@xxxxxxxxx>
- To: Oracle L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 24 Nov 2010 13:21:08 -0800 (PST)
Paul,
the fix was per one of your recommendations.
This was new hardware then a 13 gig oracle import onto win 2003 oracle 9*
system.
Per Paul, I replaced the deprecated analyze with the gather_schema_stats
tool which changed my application process from 20 minutes to 2 minutes.
Thank you all!
eat turkey,
POB.
Other related posts:
- » FIX - Fw: Re: Perforamance problem on an Application running on top of Oracle 9 - patrick obrien