Oracle:如何确定是否有待处理的交易? [英] Oracle: How to find out if there is a transaction pending?
本文介绍了Oracle:如何确定是否有待处理的交易?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在寻找一种方法来找出当前会话中是否存在未提交的INSERT,UPDATE或DELETE语句.一种方法是使用当前sid检查v $ lock,但这需要对v $ lock的读取访问权限,如果DBA不想授予它,则将是一个问题.还有其他方法(除了跟踪应用程序发出的所有数据库命令之外)?
I'm looking for a way to find out if there are uncommited INSERT, UPDATE or DELETE statements in the current session. One way would be to check v$lock with the current sid, but that requires read access to v$lock, which is be a problem if the DBA doesn't want to grant it. Any other ways (other than keeping track of all database commands issued by the application)?
推荐答案
您可以检查您的会话是否在V$TRANSACTION
中有一行(显然,此视图需要读取特权):
you can check if your session has a row in V$TRANSACTION
(obviously that requires read privilege on this view):
SQL> SELECT COUNT(*)
FROM v$transaction t, v$session s, v$mystat m
WHERE t.ses_addr = s.saddr
AND s.sid = m.sid
AND ROWNUM = 1;
COUNT(*)
----------
0
SQL> insert into a values (1);
1 row inserted
SQL> SELECT COUNT(*)
FROM v$transaction t, v$session s, v$mystat m
WHERE t.ses_addr = s.saddr
AND s.sid = m.sid
AND ROWNUM = 1;
COUNT(*)
----------
1
SQL> commit;
Commit complete
SQL> SELECT COUNT(*)
FROM v$transaction t, v$session s, v$mystat m
WHERE t.ses_addr = s.saddr
AND s.sid = m.sid
AND ROWNUM = 1;
COUNT(*)
----------
0
这篇关于Oracle:如何确定是否有待处理的交易?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文