OraFAQ Forum: Performance Tuning » lock_sga parameter cause out of memory error

Home » RDBMS Server » Performance Tuning » lock_sga parameter cause out of memory error

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

lock_sga parameter cause out of memory error [message #110537]

Tue, 08 March 2005 09:16

Bhavindshah34
Messages: 8
Registered: February 2005
Location: Ahmedabad

Junior Member

Hi, gurus

I have oracle 9.0 on windows 2k server.

my sga size = 470M

pga size = 50M

PHY-MEMORY(RAM) SIZE =1 Gb.

When I have configure lock_sga=true I got the out of memory error when i
startup the database using that parameter..

I want to configure this paramter in my db..please help to solve this prob..

Bhavin

Report message to a moderator

Re: lock_sga parameter cause out of memory error [message #116344 is a reply to message #110537]

Tue, 19 April 2005 10:19

Frank Naude
Messages: 4565
Registered: April 1998

Senior Member

This is documented as Oracle BUG 642267:

Problem statement: LOCK_SGA=TRUE RESULTS IN ORA-27102: OUT OF MEMORY
Fixed in Product Version: 9.2
Workaround: Don't use the parameter

This part is worrying me: "I think this parameter is supposed to be ignored on NT but it gives an 'out of memory' error. Thanks."

Best regards.

Frank

Report message to a moderator

Re: lock_sga parameter cause out of memory error [message #116345 is a reply to message #110537]

Tue, 19 April 2005 10:21

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

In case it helps, I find the lock_sga parameter very useful on my local windows xp 10gR1 database.

Report message to a moderator

Previous Topic:	large sort
Next Topic:	this query is taking 58 seconds to execute

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Oct 01 03:10:47 CDT 2020