Trouble shooting for Pin S wait on X
发表于:2024-10-26 作者:千家信息网编辑
千家信息网最后更新 2024年10月26日,Pin S wait on X is usually due to high parses. So check for high parsing sqls or tune application to
千家信息网最后更新 2024年10月26日Trouble shooting for Pin S wait on XPin S wait on X is usually due to high parses. So check for high parsing sqls or tune application to share cursors. For further diagnosis, please review following note :Note:1349387.1 Trouble shooting 'Cursor: Pin S wait on X' wait
通常是由于高分析。 所以检查高解析sqls或调整应用程序共享游标。 如需进一步诊断,请查看以下注意事项Note:1349387.1 Trouble shooting 'Cursor: Pin S wait on X' wait
What causes 'Cursor: pin S wait on X' waits?
* Firstly, ensure that the shared pool is sized correctly.
If the shared pool is under sized or under load generally, this may manifest itself as 'Cursor: pin S wait on X'. If Automatic Memory Management is being used then this should not normally be an issue. See:
Document 443746.1 Automatic Memory Management (AMM) on 11g
*Frequent Hard Parses
If the frequency of Hard Parsing is extremely high, then contention can occur on this pin.
*High Version Counts
When Version counts become excessive, a long chain of versions needs to be examined and this can lead to contention on this event
* Known bugs
*Parse Errors, as following note indicates:
Document 1353015.1 How to Identify Hard Parse Failures
solution:
select p2raw from v$session where event = 'cursor: pin S wait on X';
select p2raw,
to_number(substr(to_char(rawtohex(p2raw)), 1, 8), 'XXXXXXXX') sid
from v$session
where event = 'cursor: pin S wait on X';
select sid,
serial#,
SQL_ID,
STATUS,
STATE,
BLOCKING_SESSION,
BLOCKING_SESSION_STATUS,
EVENT
from v$session
where SID = &sid;
As a result of Bug 7568642 BLOCKING_SESSION EMPTY FOR "CURSOR: PIN S WAIT ON X" the blocking_session is not populated in 10.2.The bug is fixed in 11g R1.
由于错误7568642 BLOCKING_SESSION为空当等待事件为"CURSOR:PIN S WAIT ON X",blocking_session未在10.2中填充。错误在11g R1中修复
In 11g and 12g, the blocking session can be found directly using the following sql:
在11g和12g中,可以使用下面的sql直接找到阻塞会话
select sid,
serial#,
SQL_ID,
BLOCKING_SESSION,
BLOCKING_SESSION_STATUS,
EVENT
from v$session
where event = 'cursor: pin S wait on X';
通常是由于高分析。 所以检查高解析sqls或调整应用程序共享游标。 如需进一步诊断,请查看以下注意事项Note:1349387.1 Trouble shooting 'Cursor: Pin S wait on X' wait
What causes 'Cursor: pin S wait on X' waits?
* Firstly, ensure that the shared pool is sized correctly.
If the shared pool is under sized or under load generally, this may manifest itself as 'Cursor: pin S wait on X'. If Automatic Memory Management is being used then this should not normally be an issue. See:
Document 443746.1 Automatic Memory Management (AMM) on 11g
*Frequent Hard Parses
If the frequency of Hard Parsing is extremely high, then contention can occur on this pin.
*High Version Counts
When Version counts become excessive, a long chain of versions needs to be examined and this can lead to contention on this event
* Known bugs
*Parse Errors, as following note indicates:
Document 1353015.1 How to Identify Hard Parse Failures
solution:
select p2raw from v$session where event = 'cursor: pin S wait on X';
select p2raw,
to_number(substr(to_char(rawtohex(p2raw)), 1, 8), 'XXXXXXXX') sid
from v$session
where event = 'cursor: pin S wait on X';
select sid,
serial#,
SQL_ID,
STATUS,
STATE,
BLOCKING_SESSION,
BLOCKING_SESSION_STATUS,
EVENT
from v$session
where SID = &sid;
As a result of Bug 7568642 BLOCKING_SESSION EMPTY FOR "CURSOR: PIN S WAIT ON X" the blocking_session is not populated in 10.2.The bug is fixed in 11g R1.
由于错误7568642 BLOCKING_SESSION为空当等待事件为"CURSOR:PIN S WAIT ON X",blocking_session未在10.2中填充。错误在11g R1中修复
In 11g and 12g, the blocking session can be found directly using the following sql:
在11g和12g中,可以使用下面的sql直接找到阻塞会话
select sid,
serial#,
SQL_ID,
BLOCKING_SESSION,
BLOCKING_SESSION_STATUS,
EVENT
from v$session
where event = 'cursor: pin S wait on X';
错误
事件
事项
应用程序
注意事项
游标
程序
空当
面的
高分
进一
应用
检查
调整
阻塞
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
数据库应用技术国开考试答案
json传参数到数据库
网络安全文明上网卡通图片
华为云香港服务器一年多少钱
基岩版日本服务器IP
基岩版我的世界起床战争服务器
数据库详细成绩表设计
如何检查hp服务器电源
阿阳精分了的服务器
网络技术支持是前端还是后台
北京小企业进销存软件开发
开sf服务器宽带的要求
csgo连接的服务器失败
tbc哪个数据库好用
淮阳软件开发项目管理
厦门大学购买万德数据库了吗
数据库安全日权限
查看数据库的详细信息语句
华为欧拉服务器操作系统价格
家庭教育与网络安全视频第三套
网络安全是从
小禾互联网科技
数据软件开发标准
徐汇区第三方软件开发客户至上
网络安全与维护论文引言
联想服务器如何创建两个阵列
特约风豹互联网科技是什么
首部网络安全法
淮阳软件开发项目管理
人类资料数据库