Re: ORA-4030

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Fri, 21 Feb 2003 19:31:36 +0100
Message-ID: <srrc5vcde59o0j42jtkts0jdbiv9l2h8vj@4ax.com>

On 21 Feb 2003 16:13:07 GMT, Chuck <chuckh_at_softhome.net> wrote:

>Oracle 8.1.7 on Windows 2000 Advanced Server.
>
>I recently increased the sort_area_size on a Win2k instance from 64k to
>10m. Shortly afterwards I started getting sporadic ORA-4030 (out of process
>memory) errors. There should be plenty of memory. The box has 3g installed.
>The oracle.exe process only has 1800m allocated Anyone else run into this?
>How'd you get around it?

sort_area_size is a per user limit.
This means all your connected sessions get 10M sort_area_size per session.
Your Oracle process gets way too much memory. You shouldn't allocate more than one third of physical memory. Allocating more will result in excessive paging. Also by design of the Winblows O/S no process will get more than 2G *ever*, even if you have Advanced Server installed.

Hence, you have basically 2 options
1 start reading the Performance Tuning Guide and tuning your application NOW (recommended, you shouldn't even consider increasing the memory usage of Oracle to 1800M)
2 switch to a *real* O/S

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Feb 21 2003 - 12:31:36 CST