RE: Why is db slow after analyze?

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:cspence_at_FuelSpot.com]
> 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:sqlgreg_at_pacbell.net]
> 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: kirti.deshpande_at_verizon.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: Christopher Spence
  INET: cspence_at_FuelSpot.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).