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.
<FONT face=Arial color=#0000ff
size=2> 
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 <FONT
face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS" size=2>Fuelspot

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Greg Moore   [mailto:sqlgreg_at_pacbell.net]Sent: Tuesday, June 12, 2001 9:41   PMTo: Multiple recipients of list ORACLE-LSubject: Why   is db slow after analyze?
  I ran dbms_stats.gather_database_stats(   ); on a test machine with no other users.  <FONT   face=Arial size=2>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.
 

  <BLOCKQUOTE dir=ltr
  style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">