Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Diagnostic & tuning pack
Small correction
make that
- don't run dbms_utility.analyze_database
- if you did, run dbms_utility.analyze_schema('SYS','DELETE') -- instead of
DROP STATISTICS
Regards
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail address "RSH" <RSH_Oracle_at_worldnet.att.net> wrote in message news:DbEw8.43068$QC1.2980127_at_bgtnsc04-news.ops.worldnet.att.net...Received on Sun Apr 21 2002 - 15:14:38 CDT
> Oh, yeah. Don't ever run the DBMS_UTILITY package that analyses all
schemas
> in the database; unless they fixed it or replaced it with something else,
it
> analyzes the schemas for SYS and SYSTEM, which Oracle tells you NEVER to
do.
> (If you accidentally have, use the DROP STATISTICS option.)
>
> RSH.
>
>
> "MauMau" <gitaya_at_hotmail.com> wrote in message
> news:1391a36e.0204210303.2e2d94cf_at_posting.google.com...
> > Hi,
> > How do I get these packs for 8i?
> > Tia
> > MauMau
>
>