| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Deep OPS tuning info - Scott Heisey, Where Are You When We Need Ya
Most likely not what you are looking for but here it is anyway:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=206577.1
http://www.amazon.com/exec/obidos/tg/detail/-/156592701X?vi=glance http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=181489.1
I see that you posted the same question on metalink with no success. Sorry I can't help at this detail level either.
I know that Scott Heisey who used to be the OPS instructor and may now be teaching the RAC class, browses this list from time to time. Hopefully he will chime in. If not I think his email is oraracdba_at_YAHOO.COM or sheisey_at_oracle.com
"K
Gopalakrishnan" To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
<kaygopal_at_yahoo.c cc:
om> Subject: RE: Deep OPS tuning info
Sent by:
root_at_fatcity.com
02/13/03 12:23 PM
Please respond to
ORACLE-L
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
-- 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-LReceived on Thu Feb 13 2003 - 17:04:14 CST
(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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Brian_P_MacLean_at_eFunds.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).
 |
 |