Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> RE: Dropping Tables - SLow Performance - a Solution ?

RE: Dropping Tables - SLow Performance - a Solution ?

From: Rodgers, Tony (CEI-Atlanta) <Tony.Rodgers_at_cox.com>
Date: Wed, 3 Feb 1999 16:09:09 -0500
Message-ID: <529B47EE34C4D1118D0800A0C99ABC98328D28@EATL0S04>


> This little snippet from an Oracle Bug may explain the slow
> table drops vs. Truncate+Drop ...
>
> Oracle Bug 385242 affected 7.3.2.x databases. The symptom was
> much slower response dropping tables or doing analyze on tables
> compared to previous releases. The explanation is ...
>
> This is due to repeated full table scans on a new system table
> HIST_HEAD$ which does not have an index. This causes dramatically
> slower run times for jobs running ANALYZE TABLE, DROP USER, or DROP
> TABLE as opposed to the run times observed in versions 7.1.x or 7.2.x.
>
> This bug was corrected in 7.3.3. releases and later, which may
> explain why people testing this on some releases haven't seen the
> behavior.
>
> BTW, there is a workaround for those who are still on a 7.3.2.x
> database ... refer to the bug description.
>
> Regards,
> Tony Rodgers
Received on Wed Feb 03 1999 - 15:09:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US