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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Problem with DBMS_UTILITY.ANALYZE_DATABASE

RE: Problem with DBMS_UTILITY.ANALYZE_DATABASE

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Mon, 21 May 2001 00:47:04 -0700
Message-ID: <F001.00308FF9.20010521003521@fatcity.com>

Oracle itself suggests to analyze "ALL SYS OBJECTS" before an upgrade to 8.1.6 from 7.x or 8.0.x versions. This is because of default DB_BLOCK_CHECKING for SYSTEM tablespace.

Just have a look at metalink note 100419.1

HTH,
Rajesh

-----Original Message-----
C.S.Venkata
Subramanian
Sent: Monday, May 21, 2001 9:15 AM
To: Multiple recipients of list ORACLE-L

 Upto my knowledge, u can't analyse sys objects.

HTH

--

On Fri, 18 May 2001 08:17:08  
 Khedr, Waleed wrote:

>Set sql_trace on before running it and see which sys sql fails.
>
>Regards,
>
>Waleed
>
>-----Original Message-----
>Sent: Friday, May 18, 2001 10:31 AM
>To: Multiple recipients of list ORACLE-L
>
>
>unfortunately no other result with ... grant analyze any
>
>> -----Ursprüngliche Nachricht-----
>> Von: Connor McDonald [mailto:hamcdc_at_yahoo.co.uk]
>> Gesendet: Freitag, 18. Mai 2001 15:36
>> An: Multiple recipients of list ORACLE-L
>> Betreff: Re: Problem with DBMS_UTILITY.ANALYZE_DATABASE
>>
>>
>> grant analyze any to sys;
>>
>> hth
>> connor
>>
>> --- "Bachmann, Henrik"
>> <Henrik.Bachmann_at_bim-consulting.de> wrote: > Hi there,
>> >
>> > I have a problem to analyze my whole database as
>> > user sys:
>> >
>> > Oracle8 Enterprise Edition Release 8.0.5.0.0 -
>> > Production
>> > PL/SQL Release 8.0.5.0.0 - Production
>> >
>> > SQL> BEGIN
>> > 2
>> >
>> DBMS_UTILITY.ANALYZE_DATABASE('COMPUTE',NULL,NULL,NULL);
>> > 3 END;
>> > 4 /
>> > BEGIN
>> > *
>> > FEHLER in Zeile 1:
>> > ORA-20000: You have insufficient privileges for an
>> > object in this
>> > database.
>> > ORA-06512: in "SYS.DBMS_UTILITY", Zeile 282
>> > ORA-06512: in Zeile 2
>> >
>> > Anybody out there who can give me a hint?
>> >
>> > Best regards
>> >
>> > Henrik
>> >
>> > Henrik Bachmann
>> > mailto:Henrik.Bachmann_at_bim-consulting.de
>> >
>> > B.I.M.-Consulting Magdeburg
>> > http://www.bim-consulting.de/
>> > D-39108 Magdeburg
>> >
>> >
>> > --
>> > Please see the official ORACLE-L FAQ:
>> > http://www.orafaq.com
>> > --
>> > Author: Bachmann, Henrik
>> > INET: Henrik.Bachmann_at_bim-consulting.de
>> >
>> > Fat City Network Services -- (858) 538-5051 FAX:
>> > (858) 538-5051
>> > San Diego, California -- Public Internet
>> > access / Mailing Lists
>> >
>> --------------------------------------------------------------------
>> > To REMOVE yourself from this mailing list, send an
>> > E-Mail message
>> > to: ListGuru_at_fatcity.com (note EXACT spelling of
>> > 'ListGuru') and in
>> > the message BODY, include a line containing: UNSUB
>> > ORACLE-L
>> > (or the name of mailing list you want to be removed
>> > from). You may
>> > also send the HELP command for other information
>> > (like subscribing).
>>
>>
>> =====
>> Connor McDonald
>> http://www.oracledba.co.uk (mirrored at
>> http://www.oradba.freeserve.co.uk)
>>
>> "Some days you're the pigeon, some days you're the statue"
>>
>> ____________________________________________________________
>> Do You Yahoo!?
>> Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
>> or your free @yahoo.ie address at http://mail.yahoo.ie
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: =?iso-8859-1?q?Connor=20McDonald?=
>> INET: hamcdc_at_yahoo.co.uk
>>
>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>> San Diego, California -- Public Internet access / Mailing
Lists
>> --------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Bachmann, Henrik
> INET: Henrik.Bachmann_at_bim-consulting.de
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Khedr, Waleed
> INET: Waleed.Khedr_at_FMR.COM
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: csvenkata_at_lycos.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: Rajesh_at_ohitelecom.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Received on Mon May 21 2001 - 02:47:04 CDT

Original text of this message

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