Re: Help : Sessions limit

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Wed, 03 Apr 2002 14:05:30 GMT
Message-ID: <K_Dq8.161359$ZR2.76725@rwcrnsc52.ops.asp.att.net>

The error message says you need to make your large pool larger. You are running out of room there.

ORA-04031: unable to allocate 8984 bytes of shared memory ("large
> pool","unknown object","Alloc environm","alloc server hndl")

Jim
"Eric Bonnet" <erbon_at_gengenp.rug.ac.be> wrote in message news:3CAAF78D.7FB08232_at_gengenp.rug.ac.be...
> I got a problem with an Oracle 9 database running under Solaris.
> I can't open more than 110 sessions.
> The message is (I simulate connections with a small Java program) :
> --------------------------------------------------------------------------

--


>

> Exception in thread "main" java.sql.SQLException: ORA-00604: error

> occurred at recursive SQL level 1

> ORA-04031: unable to allocate 8984 bytes of shared memory ("large

> pool","unknown object","Alloc environm","alloc server hndl")

> ORA-06512: at "LBACSYS.LBAC_CACHE", line 517

> ORA-06512: at "LBACSYS.LBAC_EVENTS", line 82

> --------------------------------------------------------------------------

---


>

> init parameters :

> processes is set to 500

> large_pool_size is set to 2048000

>

> kernel parameters :

> shminfo_shmmax=4294967295

> shminfo_shmmin=1

> shminfo_shmmni=100

> shminfo_shmseg=10

> seminfo_semmns=2000

> seminfo_semmsl=1000

> seminfo_semmni=100

> seminfo_semopm=100

> seminfo_semvmx=32767

>

> Could you help me ?

>

> Thanks in advance,

>

> Eric

>

Received on Wed Apr 03 2002 - 08:05:30 CST