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 (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...



Oracle DBA


http://www.freelists.org/webpage/oracle-l Received on Wed Oct 14 2009 - 11:25:47 CDT

Original text of this message