hmmm..HP.... do a "man -k dlm" and find something like 'dlmstats'. It'll be a 'big' command with lots of cmd line flags. That should get/find you lock up/down converts.
Go to the specifics from there. Expect to find "most" of your converts are from null to shared, or vice versa...then, an order magniture (at least) fewer from shared to exclusive, etc. That's normal. Most decent dlmstats utilities will give you rudimentary waits and statistics. See if everything seems copacetic there. There are (although i honestly do NOT think this is your issue) UDP internode comms parameters that might be optimized up to, say, 256K-size send/receive buffers. What I'd look at is is the OS dlm version and patching and *its* kernel settings. I know nothing about HP, so maybe one of the truly informed on the list can chime in on that. If, OTOH, you are in a version of Oracle that internalizes the dlm (9i for sure, e.g.) then you'll likely have more knobs and dials to twist there. hope these hazily recalled, partially correct, and potentially irrelevant comments prove useful, if only as an example of what *not* to do. - Ross -----Original Message----- Sent: Monday, December 17, 2001 12:20 PM To: Multiple recipients of list ORACLE-L Ross, The HP info for one of the two nodes is, HP-UX proteus B.11.00 U 9000/800. As to the conversion stats, how do I determine/obtain those ? I'll have to get the kernal setting tomorrow; I'm working from home today, so no hard-copy. -----Original Message----- Sent: Monday, December 17, 2001 11:40 AM To: Multiple recipients of list ORACLE-L just out of curiosity, what flavor of Unix? What are your dlm lock conversion statistics? what are your OS kernel settings for udp buffers at? -----Original Message----- Sent: Friday, December 14, 2001 6:10 PM To: Multiple recipients of list ORACLE-L Hello, Anyone out there having fun on OPS with the dlm resource hash list ORA-600 and ORA-603 errors. We are getting them more frequently with increased load on the system. See below for some particulars. The really bad part is having a critical process die with the 603 error. applicable init.ora parameters: lm_locks = 180000 lm_ress = 120000 dml_locks = 7250 _lm_direct_sends = lkmgr alertlog error: Thu Dec 13 14:34:36 2001 Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc: ORA-00600: internal error code, arguments: [526], [3339519528], [1], [dlm resour ce hash list], [38628], [3338960552], [34261], [] Thu Dec 13 14:34:38 2001 Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc: ORA-00600: internal error code, arguments: [600], [], [], [], [], [], [], [] Thu Dec 13 14:34:41 2001 Errors in file /u01/app/oracle/admin/IPMP/bdump/p000_17980_ipmp2.trc: ORA-00603: ORACLE server session terminated by fatal error ORA-00600: internal error code, arguments: [600], [], [], [], [], [], [], [] Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax - 781-278-8341 (office) email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. 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: Mohan, Ross 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: Sherman, Paul R. 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: Mohan, Ross 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).
