通过v$sql_bind_capture和dba_hist_sqlbind关联诊断gc事件
通常RAC集群里面出到GC事件，我们需要查找出哪个语句导致，这样的情况下我可以考虑用绑定变量值来判断
SELECT SQL_ID, NAME, VALUE_STRING, LAST_CAPTURED
FROM DBA_HIST_SQLBIND
WHERE SQL_ID in
(select distinct sql_id from v$session where event = '&event')
AND NAME = ':REGION'
and instance_number = '&INST_ID'
and value_string not in ('®ion1', '®ion2')
union
select sql_id, name, value_string,last_captured
from v$sql_bind_capture
where sql_id in
(select distinct sql_id from v$session where event = '&event')
and NAME = ':REGION' and value_string not in ('®ion);
SELECT SQL_ID, NAME, VALUE_STRING, LAST_CAPTURED
FROM DBA_HIST_SQLBIND
WHERE SQL_ID in
(select distinct sql_id from v$session where event = '&event')
AND NAME = ':REGION'
and instance_number = '&INST_ID'
and value_string not in ('®ion1', '®ion2')
union
select sql_id, name, value_string,last_captured
from v$sql_bind_capture
where sql_id in
(select distinct sql_id from v$session where event = '&event')
and NAME = ':REGION' and value_string not in ('®ion);
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29446986/viewspace-1328518/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
