Re: problem with dbms_stats.gather_schema_stats ...

I haven't run into this exact problem, but you might find it helpful to look at the following scripts I have created:

To gather stats:
http://www.dotcomsolutionsinc.net/products/installgen/sol_901_32bit_files/in stallgen_sol901_59_.html

To use the stats:
http://www.dotcomsolutionsinc.net/products/installgen/sol_901_32bit_files/in stallgen_sol901_57_.html

You can download all of the scripts here (the Installgen file): http://www.dotcomsolutionsinc.net/downloads/demo_software/index.html

David Simpson
www.dotcomsolutionsinc.net

"slim" <sfar_selim_at_excite.com> wrote in message news:491f65ba.0206050357.7a80febb_at_posting.google.com...
> Hi,
> I often have this exception 'ORA-00060 deadlock detected while waiting
> for resource', when I execute the procedure
> dbms_stats.gather_schema_stats(...)
> Is there a possiblity to avoid this exception? If there is locked
> table is it possible to get the sid and the serial# of the locker
> session and kill it before I launch the procedure?
> thanks
Received on Wed Jun 05 2002 - 13:03:32 CDT