Re: Delete rows is slow

From: Niall McPhillips <nmcp[nospam>
Date: Thu, 19 Nov 1998 17:41:27 +0100
Message-ID: <MPG.10be68a3293a7e5a989685@news.iprolink.ch>

Hi,

If you are really trying to delete *ALL* the rows in the table try   TRUNCATE TABLE my_table;

Be careful, you can't rollback this command (DDL).

Niall.

In article <01be13ab$08801660$6d6464c3_at_kom>, loyhutz_at_dinx.de says...
> 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
>
>

--

Note: remove [nospam] from e-mail address for correct address

---

Niall McPhillips
Stephenson and Associates
chemin des Coquelicots 20
1214 Vernier-Geneva
Switzerland.

Tel: 	+41 (22) 341.5001
Fax: 	+41 (22) 341.5004

e-mail: nmcp[nospam]@s-and-a.com
Web: http://www.s-and-a.com Received on Thu Nov 19 1998 - 10:41:27 CST