Re: memory allocation failure

On open systems, process memory for each session in not allocated dynamically, but rather upon instance startup. The initilization parameter 'processes' will dictate how many processes can be used while the instance is running. Upon instance startup, the 'processes' parameter is referenced to determine how much memory will be allocated.

-D

On 5 Dec 1996 06:22:02 GMT, avisha_at_ix.netcom.com(Shah Vijay) wrote:

>
>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.
>
>

################################################################

Email: darryl.snedeker_at_fmr.com

Disclaimer: The opinions expressed herein are my own and in

             no way reflects the same of my employer.
             All recommendations and advice must be verified
             to be accurate by the recipient before implementation.

Quote Du' Jour: !Whew! I'm tired.

#############################################################################