RE: HW-enqueue wait (ASSM)

From: Fmhabash <fmhabash_at_gmail.com>
Date: Wed, 14 Oct 2009 13:57:05 -0400
Message-ID: <4ad610e2.0c92100a.2ae6.2f54_at_mx.google.com>

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?

  ---

Thank You.

-----Original Message-----
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 11.1.0.7 (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-l

Received on Wed Oct 14 2009 - 12:57:05 CDT