Re: Delete is very slow

Hi,
Depends on how you defined your table - the following issues will slow down delete:

1. Number of indexes
2. Number of extents
3. Number of constraints with CASCADE option set
4. Clustered tables

It looks like your Oracle server is too large. 64MB is minimum for a small database. M$ takes the first 32MB just to run NT - and if you have any other network services running that takes more ram. Try reducing your SGA size so your database does not cause memory swaps.

Look at the above areas.
If you have had a lot of rows in your table and keep deleting them, remember to recreate your indexes too. Truncate might help you, but won't always be available depending on how you have defined your database constrants. Remember, Oracle does NOT deallocate index entries on delete - the index keeps growing until you truncate/delete it.

• Peter Larsen Senior Oracle Consultant

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 - 08:09:52 CST