Re: analyze script

Hegyvari Krisztian wrote:
>
> Greetings,
>
> I tried to write a small pl/sql procedure to analyze the database on a
> timely basis. No matter how I wrote the script I received snapshot too
> old errors at various points of the script. I tried to use straight
> analyze table commands, use the dbms_stats package in several ways to no
> avail.
>
> Any ideas how to make this? I wanted to have a method where no client
> computer is involved in the analysis.
>
> Best Regards,
>
> Hegyvari Krisztian

snapshot too old suggests that you want to increase the amount of undo you've got, or to try run the analyze / dbms_stats at a less 'active' time

there's some sample scripts for calculating stats on my site

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"