Coskan’s Approach to Oracle

June 28, 2007

Sub Latch Wait Events with weak documentation

Filed under: RAC — coskan @ 8:57 am

Prior to Oracle Database 10g, all latch waits show up as the latch free wait event . In Oracle Database 10g, common latches are broken out and have independent wait event names and statistics but documentation about this independent wait event statistics are forgotten.

Yesterday I saw long waits of “latch: KCL gc element parent latch ” event on 10046 trace output of one of our sqls. I searched the documentation, metalink and google, all I have found is 15 bug pages on metalink, no page on documentation, 6 pages on google and all of this pages are not talking about defintion of event. They only show that this event has a place on the tkproof outputs. But my sql is suffering from this event what should I do now to lower this long waits???.

I hope documentation about latch sub events will be more definitive on upcoming 11G.

Ps: Any comment about definition of this wait event will be welcome.

About these ads

1 Comment »

  1. [...] a number of articles; Tanel Poder writes about session level statspack. Coskan Gundogar talks about sub latch wait events and finally Jeremy Schneider has a very interesting part 1 article about statspack and AWR latch [...]

    Pingback by OraTransplant » Log Buffer #51: a Carnival of the Vanities for DBAs — June 29, 2007 @ 4:01 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Silver is the New Black Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 203 other followers

%d bloggers like this: