oracle share pool latch问题

muchun_fly

实在不好意思，因客户服务器宕了，最近几天都没上来。

其实想知道trace出来的那些latch信息如何在试图中查到，或者trace文件中的这些信息和latch字样的试图中列出的latch信息有什么关系。

Yong Huang

> 其实想知道trace出来的那些latch信息如何在试图中查到，或者trace文件中的这些信息和latch字样的试图中列出的latch信息有什么关系。

No need to apologize. But you really need to read our discussion before you continue to say this. To summarize, the latch directory shown in your trace file is not visible from any v$ or x$ table as far as we know. The address (right after "Latch: ") matches the address in v$latch or v$latch_children. Since the latch directory shows only a subset of the latches in v$latch_children, there may be some significance in placing a latch in the directory versus not putting it in the directory. We don't know what this significance is.

Yong Huang

muchun_fly

已经了解了，谢谢！

希望以后还能多多指教！