RE: Why is db slow after analyze?

[Christopher Spence]

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.