XPost: comp.databases.oracle.server   
   From: hendrix_erik@hotmail.com   
      
   Hi,   
      
   I have a question regarding Oracle 10g and it's dynamic SGA. We are   
   currently evaluating different hardware platforms as well as database   
   platform. Dynamic configuration is an important part for us.   
   I understand that on Solaris, one can set a Oracle parameter (SGA_MAX_SIZE?)   
   to a maximum value. Oracle can then use DISM to pin into memory what it   
   currently needs and leave in swap space what it does not need.   
   This would allow us to set it for example to 32GB but only use 4GB. When we   
   then give the host more memory, we can then increase Oracle's active SGA and   
   it will start pinning more memory into RAM.   
      
   I'm wondering what the deal is on AIX and HP-UX? Does Oracle pin the SGA   
   into RAM on these platforms? If it does, how does it work with dynamic   
   configuration? Will it like on Sun allocate all the memory but only pin what   
   is currently required?   
      
   Thanks.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)