Re: drop table very slow in busy system EE 9.2.0.3

Hi!

First things that come into my mind: you were using locally managed tablespaces in 8.1.7, but are using old dictionary managed ones in 9i and the segment has many extents to drop.

Or, you have old dictionary managed tablespaces in both 8i and 9i, but in 9i the extent sizes are lot smaller (thus number of extents bigger), that again the drop needs to do lots of dml in data dictionary.

Tanel.

"Anton Dischner" <nospam_at_nospam.org> wrote in message news:240720031415111663%nospam_at_nospam.org...
> Hi,
>
> we are running Oracle EE 9.2.0.3 on Linux 8.2 kernel 2.4.20-64GB-SMP
> Fujitsu-Siemens dual Xeon 2,8 GHz, 2 GB RAM, RAID 5.
> Shared pool standard 240 MB, Buffer cache 608 MB standard, no
> archivelog.
>
> If the system is busy (huge import)
> a drop table takes from 5 minutes to 20 minutes?
>
> In Oracle 8.1.7 it was done in 1-20 seconds!
>
> Anything wrong with undo time 10 hours?
>
> How much do you enter here?
>
> thanks in advance,
>
> Toni
> --
> +--------------------------------------------------------------------+
> | Anton Dischner, Unix admin, Oracle-DBA Phone: +49 89 70953202
> | Institut fuer Klinische Chemie Fax : +49 89 70958888
> | Klinikum Grosshadern Home : +49 89 69708766
> | Ludwig Maximilians Universitaet Muenchen Mobil: +49 172 8388880
> | 81366 Muenchen Germany
> | Marchioninistr. 15 dischner at klch.med.uni-muenchen.de
> +--------------------------------------------------------------------+
Received on Thu Jul 24 2003 - 12:15:17 CDT