Enqueue type - RO-Multiple Object Reuse (fast object reuse)

From: Keith Moore <kmoore_at_zephyrus.com>
Date: Wed, 31 Aug 2005 12:06:02 -0700 (PDT)
Message-ID: <46870.156.153.255.126.1125515162.squirrel@webmail.zephyrus.com>

Does anyone have information on this?

We have setup a two node 10g RAC database, Oracle version 10.0.3.

I ran statspack for a test and this shows up as the top wait time in one instance with 3 minutes of wait time during a 12 minute test. Interestingly, it has less than one second of wait on the other instance.

Here is the statspack info:

Enqueue Type (Request Reason)

Requests Succ Gets Failed Gets Waits Wt Time (s) Av Wt Time(ms)
------------ ------------ ----------- ----------- ------------ --------------
RO-Multiple Object Reuse (fast object reuse)

5,180 5,180 0 2,217 184 83.00 TX-Transaction (row lock contention)

23 23 0 23 1 49.57

Any help would be greatly appreciated.

Keith

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 31 2005 - 14:10:24 CDT