Re: how to decide SHMMAX,SHMMNI and SHMMIN

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 11 Aug 2006 06:06:15 -0700
Message-ID: <1155301575.176111.138560@75g2000cwc.googlegroups.com>

peter wrote:
> Please tell me, how to decide SHMMAX,SHMNI and SHMMIN in Linux Kernal
> version 4 for Oracle 9i installation when my database will be very
> huge, somewhere 1/2 Terabytes.

What does the Oracle installation materials say about sizing these parameters?

Just because the database is huge does not mean the SGA needs to be huge. The size of the SGA is dependent more on the concurrent user load and how the applications will work than the amount of total data.

HTH -- Mark D Powell -- Received on Fri Aug 11 2006 - 08:06:15 CDT