Oracle-L: RE: Deep OPS tuning info

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Thu, 13 Feb 2003 11:23:53 -0800
Message-ID: <F001.0054C7A6.20030213112353@fatcity.com>

Rui,

It is very difficult to identify the problem by just looking the contention for "dlm resource hash list". What are the current values of lm_% parameters.

Basically that latch protects the resources in LM resource structures in the lock manager resource table. And I would compare the values from the V$resource_limit to the lm_% parameters to get an idea about the resource utilization.

BTW Do you see "Dynamic resources/locks allocated" message in the alert logs?

Best Regards,
K Gopalakrishnan

-----Original Message-----
MARREIROS,RUI (HP-Portugal,ex1)
Sent: Thursday, February 13, 2003 8:25 AM To: Multiple recipients of list ORACLE-L

Hi all:
I'm tuning an OPS env. and the things are getting quite deep, DLM latch issues and so on (e.g. lots of waits on "dlm resource hash list"). So I was wondering if any of you know of any site or doc. which could help me on this
(OPS tuning specific and very deep information).
Of course the first steps in the process was to submit the statspack report to oraperf and so on .... , but right now we are dealing with some issues that surpass the obvious things. So if any you could provide any tip or site to look for a tip I´ll be very glad.

thanks in advance

Rui Galamba Marreiros
Solution Consultant - HP Services, Consulting & Integration Quinta da Fonte , Edificio D. Sancho I,
2780 Porto Salvo, Portugal
Telf: +351 214828500
Fax: +351 21 4838431
rui.marreiros_at_hp.com <mailto:rui_marreiros_at_hp.com>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: MARREIROS,RUI (HP-Portugal,ex1)
  INET: rui.marreiros_at_hp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
-- 
Author: K Gopalakrishnan
  INET: kaygopal_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Thu Feb 13 2003 - 13:23:53 CST