Lock SGA in memory
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Lock SGA in memory

  1. #1
    Join Date
    Aug 2000
    Location
    -
    Posts
    7

    Lightbulb

    Hi lists,

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

    Thanks.

  2. #2
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    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

  3. #3
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    You can use init.ora parameter LOCK_SGA=TRUE and Oracle will never allow OS to put SGA in a swap area.

    Sergey.

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    LOCK_SGA is OS dependant. It may be available for all environment.

  5. #5
    Join Date
    Aug 2000
    Location
    -
    Posts
    7
    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
  •  


Click Here to Expand Forum to Full Width