-
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<sid>.ora).
it will not release until you shutdown the database.
Good Luck.
Chan
OCP7.3/8.0/8i/9i
Sun Certified Sys. Admin
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|