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

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

Other related posts: