Re: dbms_utility.analyze

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Mon, 4 Oct 1999 23:14:12 +0100
Message-ID: <dD9lSAA0aS+3Ew2Z@ahardy.demon.co.uk>

In article <7tamdk$68g$1_at_schbbs.mot.com>, jawa <Jim.Wadas_at_motorola.com> writes
>Has anyone experienced problems running dbms_utility.analyze_schema() ?
>About 100 years ago in an Oracle ILT DBA class (circa RDBMS version 7.2),
>the instructor recommended not to run this procedure as it results in "...
>unresolvable locks in the data dictionary."

I think that this was only if you ran is against SYS - not sure if it is still true.

Andy
>
>--
>Jim Wadas
>Information Technology Solutions and Services (ITSS)
>Motorola Systems Solutions Group (SSG)
>Scottsdale, AZ 85257
>(480) 441-8196
>Jim.Wadas_at_motorola.com
>
>
>

--
Andy Hardy. PGP key available on request

Received on Mon Oct 04 1999 - 17:14:12 CDT

Re: dbms_utility.analyze_schema()