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 -> The Perfomance Problem while deleting records in Oracle 8

The Perfomance Problem while deleting records in Oracle 8

From: Kozlitin V.V. <kozlitin_at_menatep.vrn.ru>
Date: Wed, 15 Sep 1999 17:11:32 +0400
Message-ID: <7ro5up$jft$1@serv.vrn.ru> 





Hi all.



I have the perfomance problem  - the deleting time of 4000 records from
table,


that contain about 300000 records exceeds 10 minutes.



The table has 2 index (on date and on internal_code)
Server configuration: PII-450, 96 RAM, 9G HDD, Oracle 8.0 on Solaris 7



Any ideas?



Vladimir


E-mail: kozlitin_at_menatep.vrn.ru



Received on Wed Sep 15 1999 - 08:11:32 CDT












Original text of this message













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