Re: memory allocation failure (listner control log)

Vijay Shah wrote:
> 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?
> Is adding more memory the only solution?
> If not how do I control the amount of memory each session takes up.

  You can increase the SHARED_POOL_SIZE in the parameter file. Moreover, try to decrease the value for the maximum roles as each will occupy four bytes.

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841