Re: Sartup failure due to init parameter: LOCK_SGA

The error is telling you the truth

Linux Error: 1: Operation not permitted

Some O/S do not allow this parameter to be set.

The only OS i have looked at using this parameter was Windows NT due to some nasty memory/paging allocation habits i.e the O/S stealing memory pages even under low memory load conditions.

Check the linux doco on the disk caching/paging algorithm, you might find that you can limit the amount of memory which can be used by linux to cache physical files in memory and therefore limit the chance of Oracle's memory area being paged to disk. We use a limit on our dedicated database unix server for similar reasons.

Have Fun

--
Posted via http://dbforums.com