enq: HW - contention

From: Tim Onions <att755_at_hotmail.com>
Date: Tue, 17 Jan 2006 15:16:22 +0000
Message-ID: <BAY105-F14B8C1B6AFA97EA7CDD327991A0@phx.gbl>

10gR2, RHEL4, OCFS2, DL585 AMD Opteron 64bit

Im running a benchmark on the above hardware using hammerora (GPL TPC like tool I saw a presention on at UK OUG 2005). All runs very fast to begin with but then slows to a crawl. AWR/ADDM shows the reason for the slow down to be HWM contention presumably do to a large number of multiple concurrent inserts happening (once the initial HWM is breeched). I did some googling and found lots of references to the _bump_highwatre_mark_count parameter to "fix" this. My question is as I am using ASSM tablspaces surely this no longer applies - there are no freelists/freelist groups on such tablespaces if my understanding is correct. If this is so then why am I getting this contention and how can it be fixed when using ASSM. I will try the parameter next time I hit the issue.

Many thanks

Tim Onions

---

Be the first to hear what's new at MSN - sign up to our free newsletters! http://www.msn.co.uk/newsletters

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 17 2006 - 09:18:47 CST