Message-Id: <10540.110418@fatcity.com> From: "Igor Neyman" Date: Mon, 26 Jun 2000 10:39:47 -0400 Subject: Re: Slow delete This is a multi-part message in MIME format. ------=_NextPart_000_0066_01BFDF5A.D92E3CC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Check if Primary Key of your table is referenced by Foreign Keys in = other tables and if these Foreign Keys have appropriate indexes. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 ineyman@perceptron.com =20 ----- Original Message -----=20 From: David Turner=20 To: Multiple recipients of list ORACLE-L=20 Sent: Monday, June 26, 2000 11:11 AM Subject: Slow delete 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.=20 = Dave Turner=20 -- 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/ Linuxcare. Support for the revolution. -- =20 ------=_NextPart_000_0066_01BFDF5A.D92E3CC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Check if Primary Key of your table is referenced by = Foreign=20 Keys in other tables and if these Foreign Keys have appropriate=20 indexes.

Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
ineyman@perceptron.com
&nbs= p;=20

----- Original Message -----

From:=20 David=20 Turner

To: Multiple recipients of list ORACLE-L =

Sent: Monday, June 26, 2000 = 11:11=20 AM

Subject: Slow delete

Any idea why a delete of all the rows in a table might = take=20 hours when there are only 30,000 rows? There are no other users on the = system.=20 Rowlength is about 120.=20 =

&nbs= p; = ; = &= nbsp; &n= bsp; &nb= sp; =20 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/
Linuxcare. Support for the revolution.