Home » RDBMS Server » Performance Tuning » lock_sga parameter cause out of memory error
icon11.gif  lock_sga parameter cause out of memory error [message #110537] Tue, 08 March 2005 09:16 Go to next message
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
Re: lock_sga parameter cause out of memory error [message #116344 is a reply to message #110537] Tue, 19 April 2005 10:19 Go to previous messageGo to next message
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
Re: lock_sga parameter cause out of memory error [message #116345 is a reply to message #110537] Tue, 19 April 2005 10:21 Go to previous message
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.
Previous Topic: large sort
Next Topic: this query is taking 58 seconds to execute
Goto Forum:
  


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