Enqueue type - RO-Multiple Object Reuse (fast object reuse)
- From: "Keith Moore" <kmoore@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 31 Aug 2005 12:06:02 -0700 (PDT)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
