Re: Processes and shared memory

Hi,

I think we have enough memory,about 4Gb. We have tried different size of the shared_pool_size area but it fails with the same error. E.g, processes = 9550, shared_pool_size = 300000000 OK proccess = 9555, shared_pool_size = 800000000 FAILED.

Could there be a limit in Oracle ?.

Regards,
Joakim Hartikainen

In article <36B60CF4.DA413BF0_at_us.oracle.com>,   Peter Sharman <psharman_at_us.oracle.com> wrote:
> Joakim
>
> Looks like your machine doesn't have enough memory to build the SGA. Check
your
> memory utilization out.
>
> HTH
>
> Pete
>
> joakimh_at_hem.passagen.se wrote:
>
> > Hi,
> >
> > we a have a application that needs processes be set to 10000,
> > but I can only set it to 9550 other wise I got an Oracle error,
> >
> > SVRMGR> connect internal
> > Connected to an idle instance.
> > SVRMGR> startup
> > ORA-04031: unable to allocate 16949520 bytes of shared memory ("unknown
> > object","sga heap","sessions")
> > SVRMGR>
> >
> > which tells me to increase shared_pool_size and I have tried that but
without
> > success
> >
> > We are running Soalris 2.5.1 and Oracle 7.3.4.0.1
> > our parameters in /etc/system are,
> >
> > set shmsys:shminfo_shmmax=2147483648
> > set shmsys:shminfo_shmseg=200
> > set shmsys:shminfo_shmmni=200
> >
> > Anyone have any experience with that many processes that can help ?.
> >
> > Regards,
> > Joakim Hartikainen
> > Föreningssparbanken
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
> --
>
> Regards
>
> Pete
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Peter Sharman Email: psharman_at_us.oracle.com
> WISE Course Development Manager Phone: +1.650.607.0109 (int'l)
> Worldwide Internal Services Education (650)607 0109 (local)
> San Francisco
>
> "Controlling application developers is like herding cats."
> Kevin Loney, ORACLE DBA Handbook
> "Oh no it's not! It's much harder than that!"
> Bruce Pihlamae, long term ORACLE DBA
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Feb 02 1999 - 06:45:46 CST