Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dropping analyze objects from data dictionary

Re: dropping analyze objects from data dictionary

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Tue, 29 Jul 2003 17:26:36 GMT
Message-ID: <3F26AE4C.2E006915@remove_spam.peasland.com>


I had heard the same thing about 9i. And I also heard a rumor that in a future version (10?) that analyzing SYS objects would be required. This makes sense in the demise of RBO.

Cheers,
Brian

Norman Dunbar wrote:
>
> <Dons Nomex suit and prepares for a flame fest>
>
> I believe that you *can* safely analyze SYS objects under 9i (could be
> Release 2 only though !) without any ill effects.
>
> Not that I have done it.
>
> Nor will I be doing it - unltil I get advice from Oracle, but I have
> read (on Metalink) something that says 'it makes no difference' under
> 9i. Of couse, I cannot find the damned note when I'm looking for it, but
> when I do, I'll repost !
>
> Cheers,
> Norm.
>
> (Going home before the flames start !!!)
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Tue Jul 29 2003 - 12:26:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US