开发者社区> 科技小能手> 正文
阿里云
为了无法计算的价值
打开APP
阿里云APP内打开

Most of library cache latches have gone in 11g

简介:
+关注继续查看
10g SELECT t1.ksllasnam "parent_name", t2.ksllwnam "location" FROM x$ksllw t2, x$kslwsc t1 WHERE t2.indx = t1.indx AND ksllasnam like '%library cache%' parent_name location -------------------------------------------------- ---------------------------------------------------------------- library cache kqlftc library cache kqlmbfre: parent library cache kqlmbpil: parent library cache kqlmbinv: parent library cache kqlmbfre: child: in loop library cache kqlmbfre: child: no obj to free library cache pin kqlmbpil: child library cache pin kqlmbpil: child: free and continue library cache pin kqlmbp: child library cache pin kqlmbpil: child: post parent after timeout library cache kgluka: parent library cache kglScanDependency library cache kglscn: parent library cache kglsca: parent library cache kglLockCursor library cache kgldrp: child library cache kgldrx: child library cache kgldmc: parent library cache kglhdiv: child library cache kglivl: parent library cache kglidp: child library cache kgldtld: parent library cache kgldte: parent library cache kglilf: parent library cache kglmvsca: parent library cache kgldte: child 0 library cache kglget: KGLDSBYA library cache kglget: set reserved lock library cache kglget: hash collision library cache kglget: unpin heap 0 library cache kglpin: child: KGLMX library cache kglupi: child: outside loop library cache kglkep: child library cache kglukp: child library cache kglupc: child library cache kglgfc: child library cache kglalt: child library cache kglupd: child library cache kglsts: child library cache kglpur: child library cache kglprg: child library cache kglini: child library cache kglver: child library cache kglivl: child library cache kglivr: child library cache kgldte: child library cache kglhdbrnl: child library cache kglobr: child library cache kglpnc: child library cache kglati library cache kglpim library cache kglupkp library cache kgllfr library cache kglnti library cache kglic library cache kglpnp: child library cache kglhfr: child library cache kglrtl library cache kglpin library cache kglswp library cache kgldti: 2child library cache kgldtld: 2child library cache kgl 2child pad56 library cache kgllkal: parent library cache kglhdal: parent library cache kglhdunp: parent: flush library cache kglhdiv0: parent: invalidate library cache kglhdbr0: parent: invalidate library cache kgllldl: child: library cache kglhdbr: child library cache kgl parent pad2132 library cache kglhdgn: child: library cache kglhdgc: child: library cache kglhdgh: child: library cache kglobpn: child: library cache kglpndl: child: before processing library cache kglhdiv0: child library cache kglpndl: child: after processing library cache kglobld library cache kglpin: child: heap processing library cache kglpnal: 2child library cache load lock kglllal: llatch library cache lock kglget: un-set reserved lock library cache lock kgllkal: child: multiinstance library cache lock kgllkal: child: in loop library cache lock kgllkal: child: deadlk det: error library cache lock kgllkdl: free heap 0 library cache lock kgllkdl: child: cleanup library cache lock kgllkdl: child: multiinstance library cache lock kgllkdl: child: no lock handle library cache lock kgllkc: child library cache lock kglpsl: child library cache lock kglhdbrnl: child library cache lock kglhdcb: child library cache lock ksucallcbksafely: kqllhng library cache pin ksucallcbksafely: kqlphng library cache load lock ksucallcbksafely: kqldlhn library cache pin kglobld: child: library cache pin kgllkdl: child: free pin library cache pin kglpnal: child: alloc space library cache pin kglpnal: child: check granted library cache pin kglpndl: child: multiinstance library cache pin kglpnck library cache pin kglupc library cache pin kglpin: child: KGLMS library cache pin kglupi: child: within loop library cache pin kgldnp: child library cache pin kglpnc: child library cache pin kglpnp: child library cache pin kglobf0 library cache pin kglpndl library cache pin dummy library cache pin kglivl0 library cache hash chains kglpnrel library cache hash chains kglpnget library cache hash chains spare library cache pin allocation kglpnrel library cache pin allocation kglpnget library cache pin allocation spare1 library cache pin allocation spare2 library cache lock allocation kgllkrel library cache lock allocation kgllkget library cache lock allocation spare1 library cache lock allocation spare2 library cache load lock kglllal: llatch: in loop library cache load lock kgllldl: llatch library cache kgl 2child pad2137 library cache kgl 2child pad2138 library cache kksftc 11g SELECT t1.ksllasnam "parent_name", t2.ksllwnam "location" FROM x$ksllw t2, x$kslwsc t1 WHERE t2.indx = t1.indx AND ksllasnam like '%library cache%' parent_name location --------------------------------------- --------------------------------------------- library cache load lock kglllal: llatch library cache load lock ksucallcbksafely: kqldlhn library cache load lock kglllal: llatch: in loop library cache load lock kglllal: llatch: in loop 2 library cache load lock kgllldl: llatch latch: library cache lock library cache lock allocation library cache pin library cache pin allocation library cache ALL above latches have gone(latch library cache load lock left), library cache lock/pin don't need acquire library cache any more in 11g ; library cache lock/pin structure now are protected by Library cache type mutex also. But We can not find out how kglpin/kgllkdl and else function are utlized with mutex from any V$/X$ dynamic views. Mutex is more black-box than Latch. SQL> select mutex_type ,location from v$mutex_sleep_history group by mutex_type,location; MUTEX_TYPE LOCATION -------------------------------- --------------------------------------------- Library Cache kglhdgn2 106 Library Cache kglget1 1 Cursor Pin kksfbc [KKSCHLCREA] Cursor Parent kksfbc [KKSPRTLOC1] Library Cache kglrfcl1 79 Library Cache kgllkal1 80 Library Cache kgllkdl1 85 Cursor Pin kkslce [KKSCHLPIN2] Library Cache kglhdgh1 64 Library Cache kglpin1 4 Library Cache kglpndl1 95 Cursor Pin kksfbc [KKSCHLPIN1] Library Cache kglhdgn1 62 Library Cache kglpur1 28 Library Cache kglpnal1 90 Library Cache kglobpn1 71 Library Cache kglpnal2 91                                                                                                                                                         本文转自maclean_007 51CTO博客,原文链接:http://blog.51cto.com/maclean/1276759

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
[20170727]library cache: mutex X.txt
[20170727]library cache: mutex X.txt --//如果多个会话访问v$sql视图,其底层视图是x$kglcursor_child,如果几个会话同时访问,会出现library cache: mutex X等待事件,通 --//过例子说明: 1.
943 0
[20161216]关于library cache lock.txt
[20161216]关于library cache lock.txt --这几天一直在关注这个链接,http://www.itpub.net/thread-2073170-1-1.
952 0
【问题处理】Memory Notification: Library Cache Object loaded into SGA
1.问题现象数据库日常巡检过程中,在alert日志中发现如下警告信息……省略……Thu Apr 15 22:06:31 2010Memory Notification: Library Cache Object loaded into SGAHeap size ...
809 0
Library cache lock/pin详解
一、概述 ---本文是网络资料加metalink 等整理得来 一个实例中的library cache包括了不同类型对象的描述,如:游标,索引,表,视图,过程,等等.
753 0
0106library cache pin的快速定位与解决
[20150106]library cache pin的快速定位与解决.txt --昨天别人的系统遇到library cache pin问题,导致前台业务停顿,出现问题后请求协助. --我以前也遇到,也是手忙脚乱。
751 0
library cache lock/pin
原创:转载请说明 X$KSMLRU that tracks allocations in the shared pool that cause other objects in th e shared pool to be age...
636 0
文章
问答
文章排行榜
最热
最新
相关电子书
更多
低代码开发师(初级)实战教程
立即下载
阿里巴巴DevOps 最佳实践手册
立即下载
冬季实战营第三期:MySQL数据库进阶实战
立即下载