memory allocation failure

From: Shah Vijay <avisha_at_ix.netcom.com(Shah>
Date: 1996/12/05
Message-ID: <585pma$3gm@sjx-ixn5.ix.netcom.com>#1/1

comp.databases.oracle.serverAll,
I would like to know how much of sga area gets allocated to each session at login. We are running oracle 7.3 with the default instance initorcl.ora set for LARGE default options. There is 64MB of memory on the NT box and every time the number of sessions exceeds 15, the new connection fails and listner log shows a malloc failure. Has anyone experienced this?
This is the error message in the orclALRT.log. KCF: write/open error dba=0x602962f block=0x2962f online=1

     file=6 D:\ORANT\DATABASE\SYSORCL3.ORA
     error=9205 txt: 'OSD-04100: malloc() failure, unable to allocate

memory (OS 8)'

Is adding more memory the only solution? If not how do I control the amount of memory each session takes up.

Thanks in advance. Received on Thu Dec 05 1996 - 00:00:00 CST