Should the SHMMAX be the same as the physical memory?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Should the SHMMAX be the same as the physical memory?

  1. #1
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258

    Should the SHMMAX be the same as the physical memory?

    We use ORacle 9i on a HP UX 11.11 server. Should you configure the SHMMAX kernal parameter the same size as the physical memory? i.e. we have 2GB of RAM and the SHMMAX is set to 2GB, but the SGA is only 240Mb.

    Thanks.

  2. #2
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Smile

    You can give the size of the SHMMAX variable to 2 GB. SHMMAX means continuous memory allocation to a single program. In this case yr SGA size can go upto 2 GB but beware of Paging if SGA is given too big on a 2 GB server.
    There Nothing You cannot Do, The problem is HOW.

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