- If the code has been executed previously and can be shared, Oracle will report a library cache hit.
- If Oracle is unable to use existing code, then a new executable version of the code must be built, which is known as a library cache miss.
Library Cache Hit Ratio
原创
©著作权归作者所有:来自51CTO博客作者maclean_007的原创作品,请联系作者获取转载授权,否则将追究法律责任
The library cache (a component of the shared pool) stores the executable (parsed or compiled) form of recently referenced SQL and PL/SQL code. Oracle tries to reuse this code.
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
深入学习cache--思考篇
ARMv8/ARMv9架构精选系列
v8 v9 个人博客 -
哪种操作需要哪种类型的library cache lock / library cache pin?
哪种操作需要哪种类型的library cache lock / library cache pin?
library cache pin library cache lock sed sql