HP-UX allocates as required these are limit values, if I remember rightly there is a slight memory overhead with some of these parameters, it is in the order of 1 MB supports all values or some such, it is negligible however it still exists. I think maxprocs is the culprit as it builds an empty linked list, hash table or some such to manage the procs up to the max value.
-- ================================================= Peter McLarty E-mail: [EMAIL PROTECTED] Technical Consultant WWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, Australia Mobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 ================================================= A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) ================================================= Mincom "The People, The Experience, The Vision" ================================================= This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. "Deshpande, Kirti" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05-06-2002 01:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Fax to: Subject: RE: Production Database Open Fails after Mount John, That's a splendid idea. I forgot about it.. Thanks. - Kirti -----Original Message----- Sent: Tuesday, June 04, 2002 8:18 PM To: Multiple recipients of list ORACLE-L Vivek, Just to add a simple way of determining the extent of overflow, you could use the sar -v command. This will also display other OS counters as well. 00:00:02 proc-sz ov inod-sz ov file-sz ov lock-sz 00:20:02 435/2580 0 4641/8816 0 7593/16884 0 25/33168 In fact, I would first check this out before adding a new database on any server, and use the SHM-modifications-reboot to change these as well. As per my understanding, Solaris defines an upper limit for these values, but doesn't allocate space until required, so you are Ok to define larger values without bulking up OS memory requirements. Anyone knows what happens in HP-UX? John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** >-----Original Message----- >From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, June 04, 2002 5:28 PM >To: Multiple recipients of list ORACLE-L >Subject: RE: Production Database Open Fails after Mount > > >Vivek, >You are right, this is an OS related issue, but a DBA must be >aware of why >it happens ;) > >Error 23 means 'File Table Overflow' and it is generated when >the system >wide limit for the number of simultaneously open files is >exceeded. It is >controlled by a kernel parameter 'nfile'. which defaults to a >value arrived >at by a formula that uses 'maxusers' (and a couple of other) kernel >parameters. You can check the values set for 'maxusers' and >'nfile' on these >servers, and get your SA to increase those on the server where >you had a >problem starting the database. > >Use '/usr/sbin/kmtune -q <parameter>' command to check >currently set value >for 'nfile' and 'maxusers'. > >Read more about 'nfile' at >http://docs.hp.com/hpux/onlinedocs/os/KCparam.Nfile.html. > >HTH, > >- Kirti > >-----Original Message----- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
STG34077
Description: Binary data
