Re: Slow delete

Did the delete finally finish, or did you abort it? Are there any columns = in the table that are used as foreign references? Is there any reason that = you can't issue a truncate table? Are your rollback segments large enough = to hold all the data in all 30000 records?

>>> David Turner <dturner_at_linuxcare.com> 06/26/00 11:11AM >>>
Any idea why a delete of all the rows in a table might take hours when there are only 30,000 rows? There are no other users on the system. Rowlength is about 120.

Dave Turner

--
Dave Turner, Senior Database Administrator, Linuxcare, Inc.
913.383.3052 tel, 913.579.3803 cel, 913.652.0687 fax, 877.443.9553 pager
dturner@linuxcare.com, http://www.linuxcare.com/=20
Linuxcare. Support for the revolution.