HW-enqueue wait (ASSM)

From: DBA Deepak <oracle.tutorials_at_gmail.com>
Date: Wed, 14 Oct 2009 21:55:47 +0530
Message-ID: <75aa80160910140925g664412afq5e9be244ceedb3c5_at_mail.gmail.com>

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 - 11:25:47 CDT