parent latch & children latch

对于这个概念，我也觉得郁闷......

[@more@]

About parent vs child latches. There is no fundamental low level difference between parent and child latches, they are all small regions of memory modified with atomic test-and-set style opcodes.

You see parent (and solitary) latches from x$ksllt where kslltcnm = 0 and child latches have Kslltcnm > 0 (their child number is stored there).

V$LATCH_PARENT shows all latches with kslltcnm 0, V$LATCH_CHILDREN shows all latches with cnm > 0. V$LATCH just summarizes & groups all statistics up using the latch number, it doesn't care about parent vs child latches.

It's up to Oracle, how it uses the child and parent latches, normally when child latches are used, parent latches don't get used much (or at all), since all resources to be protected have been spread between child latches already.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/814/viewspace-853692/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/814/viewspace-853692/