Lock SGA in memory

Hi lists,

Anybody knows how to make SGA locked in memory for Oracle on Solaris ?

Thanks.

You did not worry about lock the SGA in memory,
As soon as you start the database instance, the oracle
it self occupy the required space in memory(by using init.ora).
it will not release until you shutdown the database.

Good Luck.

You can use init.ora parameter LOCK_SGA=TRUE and Oracle will never allow OS to put SGA in a swap area.

Sergey.

LOCK_SGA is OS dependant. It may be available for all environment.

Thank you for the helps.

But, does Solaris kernel parameter has something that must be set ? I heard that on Sequent Unix, there are some kernel parameters that enable shared memory locking: SHM_LOCK_OK, SHM_LOCK_UID, and so on.

Thanks.