首页 > 应用开发 > IT综合 > parent latch & children latch

parent latch & children latch

原创 IT综合 作者:rwq_ 时间:2006-08-07 00:31:16 0 删除 编辑



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博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: SMON研究
请登录后发表评论 登录
  • 博文量
  • 访问量