OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » memory error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

memory error [message #158969]

Wed, 15 February 2006 04:53

vimal_vpsk
Messages: 18
Registered: March 2005

Junior Member

Hi All,
I am getting following error in our database

ERROR at line 1:

ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","unknown object","kgl simulator ","kglsim object batch")

Can anyone give me the solution for this one.

Regards
Vimal

Report message to a moderator

Re: memory error [message #158971 is a reply to message #158969]

Wed, 15 February 2006 04:56

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please search the board for ORA-04031.

Report message to a moderator

Re: memory error [message #159550 is a reply to message #158969]

Mon, 20 February 2006 04:25

dba_rashed
Messages: 3
Registered: February 2006
Location: uae

Junior Member

Hi,

I face this problem before. when i checked my system
i found 600 open coonection to the database eating all memory.
you have to manually kill the old one or you can setup
a timeout for each connection

Regards,

Rashed

Report message to a moderator

Previous Topic:	End of file on comm channel
Next Topic:	do we have only one redo log file?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:20:19 CDT 2024