Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Delete is very slow

Re: Delete is very slow

From: mgyuri <mgyuri_at_freemail.c3.hu>
Date: Thu, 19 Nov 1998 13:26:03 +0100
Message-ID: <7312jb$h4m@helka.iif.hu>


if you want to delete all rows from a table it is better to use truncate table my_table.

it must be faster.

Loy&Hutz wrote in message <01be13aa$451625c0$6d6464c3_at_kom>...
>Hello everybody !
>
>I am new in Oracle world and have this problem:
>
>My test server (NT4.0 Server - Oracle 8.0.4-Server with Pentium 200 and
>only 64 MB RAM) needs very long for deleting rows.
>
>e.g.: Delete * from Tab1 (30000 rows, 200 Cols) needs arround 15 minutes.
>
>all that time the server has disk access.
>
>is it a ram problem ? is the server always swapping pages ? Task manager
>says 90MB RAM in use.
>
>Thanks
>
>Sven
>
>
Received on Thu Nov 19 1998 - 06:26:03 CST

Original text of this message

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