Re: Delete rows is slow

Yes, 64 Mb definitely is too small. How big is your SGA (system global area). You can verify that by issuing the command show sga in svrmgr80. Usually it is at least 16M. This will result in the system paging and swapping continuously. In my experience 256 M of RAM is the absolute minimum.

Hth,

Sybrand Bakker, Oracle DBA

Loy&Hutz 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

Received on Thu Nov 19 1998 - 06:53:04 CST