Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> drop table very slow in busy system EE 9.2.0.3
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
-- +--------------------------------------------------------------------+Received on Thu Jul 24 2003 - 07:15:11 CDT
| 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
+--------------------------------------------------------------------+
![]() |
![]() |