I am running the "Gather Schema Stats" concurrent request every night with ALL schemas on a 10% estimate. The entire database is gathered in about 40 minutes.

have you tried gathering this one table on it's own to see what the problem is?

Paul

*********** ORIGINAL MESSAGE ***********

On 31/12/2004 at 9:59 AM ¿¨ÌØ wrote:

hi, gurus.
I have a request 'gather schema statistics ' for AR have been runing
a weeks .
but still can't complete. i query all tables in AR schema . the largest
table
only have 434926 records . anyone can tell me . how long will complete
this request
is normal. thanks.



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page