Just as a possible quick tip:
Have you disabled DML_LOCKs on the most
commonly accessed tables ? Is it possible
to do so on at least some of them ?
Under OPS, some activity which is usually
local latching activity turns into global lock
acquisition. If you have excessive parsing,
with
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
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
Ask Anjo. I know everybody says he's neither pretty nor smart, but I
think that's just a little unfair...
Mogens
MARREIROS,RUI (HP-Portugal,ex1) wrote:
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
:
om Subject: RE: Deep OPS tuning info
Sent
Rui,
I'm an HP (ex CPQ) collegue of yours, I spend a lot of time optimizing OPS and RAC
(with a lot of help from Anjo Kolk, especially when I just started with OPS). Can you
detail your problems, can you send me statspack report(s) and explain a little more
about the app? Maybe it's better to
