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 -> drop table very slow in busy system EE 9.2.0.3

drop table very slow in busy system EE 9.2.0.3

From: Anton Dischner <nospam_at_nospam.org>
Date: Thu, 24 Jul 2003 14:15:11 +0200
Message-ID: <240720031415111663%nospam@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 - 07:15:11 CDT

Original text of this message

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