Re: Delete is very slow

From: <tmahmood5315_at_my-dejanews.com>
Date: Mon, 23 Nov 1998 17:41:11 GMT
Message-ID: <73c6nj$uh3$1@nnrp1.dejanews.com>

Try Truncate Table if u wanna delete all rows! It is fast!

In article <01be13aa$451625c0$6d6464c3_at_kom>, "Loy&Hutz" <loyhutz_at_dinx.de> wrote:
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 23 1998 - 11:41:11 CST