Re: dbms_utility.analyze_schema()
From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Mon, 4 Oct 1999 23:14:12 +0100
Message-ID: <dD9lSAA0aS+3Ew2Z_at_ahardy.demon.co.uk>
Date: Mon, 4 Oct 1999 23:14:12 +0100
Message-ID: <dD9lSAA0aS+3Ew2Z_at_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 Tue Oct 05 1999 - 00:14:12 CEST