<div>
Forced accept.<br />
<br />
Computer101<br />
EE Admin
</div>


<div>
<div class="content wysiwyg-content">
I am running Oracle 9i on Solaris 9 Sparc platform. Our server (Sun Fire E20K) has 64 Gigs of ram. We have 6 different instances of Oracle running. The sga_max_size for each database is set to 5 gigs. Our shmmax kernel setting is set to around 6 gigs. Should the shmmax be larger? In particular someone said that the shmmax kernel parameter should be set to the sum of the sga_max_size of the instances we have running. Is this true? I have thus been unable to find any documentation on this.<br />
<br />
Thank you
</div>
</div>


I am running Oracle 9i on Solaris 9 Sparc platform. Our server (Sun Fire E20K) has 64 Gigs of ram. We have 6 different instances of Oracle running. The sga_max_size for each database is set to 5 gigs. Our shmmax kernel setting is set to around 6 gigs. Should the shmmax be larger? In particular someone said that the shmmax kernel parameter should be set to the sum of the sga_max_size of the instances we have running. Is this true? I have thus been unable to find any documentation on this.

Thank you

With Multiple Instances Do I need to change shminfo_shmmax kernel value on Solaris 9?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.