RE: KCL gc element parent latch
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Dec 2009 13:53:14 -0500
I've seen these with full table scans going across instances. Tables can be
really small but it kills the rac.
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Rajesh Rao
Sent: Wednesday, December 16, 2009 12:34 PM
To: Tanel Poder
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: KCL gc element parent latch
Thank you Tanel.
"so if you have lots of GC ops, these latches will be used. Fix the GC
traffic and the latching problem will go away."
So, those waits would be an effect, rather than the cause leading to gc cr
request waits. These waits themselves are not significant. We see fast
object checkpoints as well as this KCL latch that seems to precede most of
the gc cr request waits we see. We know the fix for the gc waits.
Thank you for the script. That goes into the same directory where I have the
snapper one stored :-)
Raj
Other related posts:
