Oh, hehe I have a habit of just skiming things, get too many emails per day
:)
"Walking on water and developing software from a specification are easy if
both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-----Original Message-----
Sent: Tuesday, June 12, 2001 10:36 PM
To: Multiple recipients of list ORACLE-L
I thought of the same thing.
But how can this explain his statement "Bouncing the db brings things back
to normal" ?
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
> -----Original Message-----
> From: Christopher Spence [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, June 12, 2001 9:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Why is db slow after analyze?
>
> If you analyze SYS/SYSTEM you will cripple the performance of the
> database, namely the table you mentioned and exports.
> Drop the statsistics as soon as possible off the SYS/SYSTEM objects.
>
> This bug was suppose to be fixed in 8.1.7 and existed for some time, I am
> not sure if it ever got fixed as I have not tested lately.
>
>
>
> "Walking on water and developing software from a specification are easy if
> both are frozen."
>
> Christopher R. Spence
> Oracle DBA
> Fuelspot
>
> -----Original Message-----
> From: Greg Moore [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 12, 2001 9:41 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Why is db slow after analyze?
>
>
> I ran dbms_stats.gather_database_stats( ); on a test machine with no
> other users. After this, running a simple query on dba_extents was
> extremely slow.
>
> Does anyone have an idea on what's the likely cause of this? I'd
> like to check after gathering stats, but am not sure what to look at to
> verify why the simple query runs so, so slowly. (Bouncing the db brings
> things back to normal, but doesn't help me understand what the holdup
> was.)
>
> Thanks.
>
>
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Christopher Spence
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).