Re: Delete rows is slow

TurkBear wrote:

> While more memory would help, you can speed this up by using the TRUNCATE
> command:
>
> truncate table Tab1 ;
>
> This effectively removes all rows from the table very quickly
> but, bear in mind, it is not reversible - once executed, the data is gone.....
> It is also only used for full deletes ( no where clauses allowed )...
>
> "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.
> >

64 too small for the NT !!!!! Oracle runs in swap !!! About what perfomance do u speak at all ?

> >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
> >
>
> To reply please remove the 'nospam' part of the address
Received on Fri Nov 20 1998 - 18:26:03 CST