Why is db slow after analyze?

From: Greg Moore <sqlgreg_at_pacbell.net>
Date: Tue, 12 Jun 2001 17:34:52 -0700
Message-ID: <F001.00326D21.20010612174104@fatcity.com>

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="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

Received on Tue Jun 12 2001 - 19:34:52 CDT