| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Analyze
I have experienced that behavior like this depends on the order of
analyzed tables. Sometimes I run into similar problem and
analyzing the tables in different order, related to integrity
constraints, solved the problem.
I never had the time to find out exactly what was the reason but the solution worked...
Witold
On 3 Oct 2000, at 14:25, Hamid Alavi wrote:
> Dear all,
> I have a big problem and need urgent help, i have run analyze table compute
> statistics on few tables yesterday and today one of my process which normaly
> finished in 1 hour still running after 10 hours, any body have any idea???
> it is very urgent..what's the solution????
>
> Hamid Alavi
> DDI 3610148
> FAX 3610102
> 111 Franklin RD Freemans Bay Auckland
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hamid Alavi
> INET: HamidA_at_aimdirect.co.nz
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
 |
 |