Re: dbms_utility.analyze_schema('SYS', 'COMPUTE')

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 19 Nov 1998 18:05:24 GMT
Message-ID: <01be13e6$73dfdf90$0300a8c0@WORKSTATION>

Rich Woods <rawoods_at_concentric.net> wrote in article <36536E21.454967D6_at_concentric.net>...
> Vic,
>
> As the Analyze command updates the data dictionary with information
extracted
> from the specified table/index/schema, a deadlock will most likely
occur when
> the Analyze command attempts to gather this information from the
data dictionary
> table where statistics are stored.
>

Specifically - when you analyze a table you may need to perform some space
management operations for the sorts etc; i.e. inserts/deletes on fet$ and uet$,
so if analyze these two tables and they are large, you could hit a deadlock. Received on Thu Nov 19 1998 - 12:05:24 CST