ORA-4030 on W2003 SE

From: Uwe Weber <uwe.weber_at_teleos-web.de>
Date: Thu, 28 Jun 2007 12:56:56 +0200
Message-ID: <5ehi9sF38embaU1@mid.individual.net>

Hi all!

I have the following problem:

10.2.0.1 EE installed on W2003 SE 32 bit, which means a max memory alllocation of 2 GB per process. RAM total: 3,5 GB.

Whenever more than 350 sessions are opened, additonal session requests fail with
either ORA-4030 "out of process memory when trying to allocate %s bytes (%s,%s)" or TNS-12518 "TNS:listener could not hand off client connection". Windows event log says: "Unabe to begin another thread".

So, everything looks like we have hit the max 2 GB per process limit. Problem is: We have not.

Taskmanager shows about 800 meg of physical RAM allocated to oracle.exe during error time. VMSize is about 1.1 GB. About 1.5 GB phys. memory are shown as 'free'.

When executing (during max. load of course) the following query, oracle shows
ca. 600 MB as used.

 SQL> select sum(bytes)/1024/1024 Mb from 2 (select bytes from v$sgastat
3 union
4 select value bytes from
5 v$sesstat s,
6 v$statname n
7 where
8 n.STATISTIC# = s.STATISTIC# and
9 n.name = 'session pga memory'
10 );

MB

---

603.316505

sga_max_size is 572M and pga_aggregate_target is 388M. We have increased pga_aggregate_target to this value from 190M, but still we could not get more sessions nor could we move Oracle to allocate more memory.

Oracle support advises us to enable the /3 GB switch in boot.ini, but I do not think that this will do any good since we do not even get 2 GB allocated.

Any sugestions would be greatly appreciated.

Regards,
uwe Received on Thu Jun 28 2007 - 05:56:56 CDT