RE: kernel parameters in 10gR2

Your call. 256 is a recommended value (it seems to have grown from 128 in 9i). Try the installation and if you have problems then arrange a kernel change.

You may want to increase the value of the shm_seg attribute if a process attempts to attach a shared memory region exceeds the limit (the shmat function returns an EMFILE error).

From the guide - The kernel subsystem attribute values shown in this section are recommended values only. For production database systems, Oracle recommends that you tune these values to optimize the performance of the system.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Maureen English Sent: 29 November 2007 20:44
To: oracle-l_at_freelists.org
Subject: kernel parameters in 10gR2

We are upgrading our databases to 10gR2 (10.2.0.3.0) on HP Tru64 Unix. In the installation instructions, it says to change the kernel parameter shm_seg to 256. For 9i it was set to 128. I sort of understand why this might be an issue when a database is created/upgraded, but do I really have to have this parameter changed to 256 just to install the software? I've actually done one installation with it set to 128 and one with it set to 256 (different machines) and neither installation gave any errors, except for the prerequisite checks.

BJSS Limited, 1st Floor Coronet House, Queen Street, Leeds LS1 2TW. Registered in England with company number 2777575. http://www.bjss.co.uk

--
http://www.freelists.org/webpage/oracle-l