Oracle针对systemstateDump练习题-数据库hang分析报告.txt
40墨值下载
背景：
数据库 HANG
数据库版本 10.2.0.4
1、从 appdb_ora_33030248.trc 中搜索"waiting for"可以看到：
即有 38 个进程在等 latch:library cache,1 个进程在等 cursor:pin X
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 70000006b9d8008 Child library cache level=5 child#=4
waiting for 'cursor: pin X' blocking sess=0x0 seq=37912 wait_time=0 seconds
since wait started=0
waiting for 'latch: library cache' blocking sess=0x0 seq=10382 wait_time=0
seconds since wait started=3123
waiting for 'latch: library cache' blocking sess=0x0 seq=12378 wait_time=0
seconds since wait started=3723
waiting for 'latch: library cache' blocking sess=0x0 seq=14373 wait_time=0
seconds since wait started=4323
waiting for 'latch: library cache' blocking sess=0x0 seq=16015 wait_time=0
seconds since wait started=4815
waiting for 'latch: library cache' blocking sess=0x0 seq=16366 wait_time=0
seconds since wait started=4923
waiting for 'latch: library cache' blocking sess=0x0 seq=1720 wait_time=0
seconds since wait started=516
waiting for 'latch: library cache' blocking sess=0x0 seq=17995 wait_time=0
seconds since wait started=5412
waiting for 'latch: library cache' blocking sess=0x0 seq=18363 wait_time=0
seconds since wait started=5523
waiting for 'latch: library cache' blocking sess=0x0 seq=18517 wait_time=0
seconds since wait started=5568
waiting for 'latch: library cache' blocking sess=0x0 seq=2034 wait_time=0
seconds since wait started=612
waiting for 'latch: library cache' blocking sess=0x0 seq=20357 wait_time=0
seconds since wait started=6123
waiting for 'latch: library cache' blocking sess=0x0 seq=2149 wait_time=0
seconds since wait started=645
waiting for 'latch: library cache' blocking sess=0x0 seq=22350 wait_time=0
seconds since wait started=6723
waiting for 'latch: library cache' blocking sess=0x0 seq=22479 wait_time=0
seconds since wait started=6762
waiting for 'latch: library cache' blocking sess=0x0 seq=22859 wait_time=0
seconds since wait started=6876
waiting for 'latch: library cache' blocking sess=0x0 seq=2363 wait_time=0
seconds since wait started=711
of 7
40墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论