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: Peter.Mclarty_at_mincom.com
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" <kirti.deshpande_at_verizon.com>
Sent by: root_at_fatcity.com
05-06-2002 01:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
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:kirti.deshpande_at_verizon.com]
>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: john.kanagaraj_at_hds.com
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: ListGuru_at_fatcity.com (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: kirti.deshpande_at_verizon.com
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: ListGuru_at_fatcity.com (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).
Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii"
Content-Transfer-Encoding: 7bit
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.
This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru. If you have questions
about this message, contact Postmaster_at_fatcity.com for clarification.
--=_mixed 001326E04A256BCF_=--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Peter.McLarty_at_mincom.com
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: ListGuru_at_fatcity.com (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).
- application/octet-stream attachment: STG34077
Received on Tue Jun 04 2002 - 23:38:20 CDT
