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 -> Too slow to delete a long raw table

Too slow to delete a long raw table

From: Éric Dantie <edantie_at_rcanaria.es>
Date: Thu, 2 Dec 1999 09:05:25 -0000
Message-ID: <38463687.0@news.ll.iac.es> 





I'm working with Oracle8.1.5 on solaris sparc.
To delete a row of a table with a long raw column, it takes half a minute.
The long raw data is no more than 1Mb!



So I've tried to update the long raw data to null before deleting it, but
it's the update which is so long...



The operation use half CPU/IOwait.



What's wrong?!?



Eric






Received on Thu Dec 02 1999 - 03:05:25 CST












Original text of this message













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