RE: HW-enqueue wait (ASSM)
Date: Wed, 14 Oct 2009 13:57:05 -0400
Just curious of why an OLTP system do up to 60% of such event. We manage heavy insert apps doing LOB's, but never seen it. Can you please share the following info with us ...
- how many inserts do you do per second (on this combo of tablespace/segment as per P1/P2 values associated with this event).
- what type of data are you inserting?
From: DBA Deepak <oracle.tutorials_at_gmail.com> Sent: Wednesday, October 14, 2009 12:25 PM To: Oracle-L <oracle-l_at_freelists.org> Subject: HW-enqueue wait (ASSM)
Our DB is on 184.108.40.206 (Solaris10 - sparc)
We have ASSM configured for all the segments but still we are seeing HW-enqueue waits which contributes 60% in the overall wait time.
The DB is an OLTP DB and data insertion rate across the segments is very high.
How to get rid of this wait event? Please help...
-- Regards, Deepak Oracle DBA -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 14 2009 - 12:57:05 CDT