Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Processes and shared memory
Joakim
Correct me if I'm wrong, but the two statements you've used are:
> E.g, processes = 9550, shared_pool_size = 300,000,000 OK
> proccess = 9555, shared_pool_size = 800,000,000 FAILED.
i.e. you've just increased the shared pool by 500,000,000. You're still looking at an out of memory error. The increase in processes will have minimal impact, but you're nearly tripling the size of the SGA by the shared_pool_size increase. Have you looked at how much memory is available (NOT how much there is total)?
Pete
>
>
> 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
--
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