Re: ORA-4030

From: Yong Huang <yong321_at_yahoo.com>
Date: 22 Feb 2003 15:46:37 -0800
Message-ID: <b3cb12d6.0302221546.3d181670@posting.google.com>

Chuck <chuckh_at_softhome.net> wrote in message news:<Xns9329721F15F91chuckhsofthomenet_at_130.133.1.4>...
> 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?

Can you look at v$sysstat and v$sesstat for session uga memory and memory max, session pga memory and memory max? Maybe you can identify other sessions that take too much private memory. Also watch the session that gets ORA-4030 for these statistics. When the error occurs, does the OS show severe paging or swapping?

Yong Huang Received on Sat Feb 22 2003 - 17:46:37 CST