How to detect and cleanup pending transactions in Oracle
Usually pending transactions clear up on their own. If not, read on.
If you have a pending transaction that will not go away then check the pending states with the following query:
SELECT local_tran_id, state, mixed
FROM dba_2pc_pending;
Pending transactions can be in any of the following states :
collecting, committed, prepared, forced commit, forced rollback
If the transaction is in the ‘prepared’ state then run
COMMIT FORCE ‘’;
or
ROLLBACK FORCE ‘’;
If the transaction is any state (other than ‘prepared’) and the transaction is not resolving then Log in as ‘SYS’ and run the following script
exec dbms_transaction.purge_lost_db_entry();
If you have a pending transaction that will not go away then check the pending states with the following query:
SELECT local_tran_id, state, mixed
FROM dba_2pc_pending;
Pending transactions can be in any of the following states :
collecting, committed, prepared, forced commit, forced rollback
If the transaction is in the ‘prepared’ state then run
COMMIT FORCE ‘’;
or
ROLLBACK FORCE ‘’;
If the transaction is any state (other than ‘prepared’) and the transaction is not resolving then Log in as ‘SYS’ and run the following script
exec dbms_transaction.purge_lost_db_entry();
【How to detect and cleanup pending transactions in Oracle】相关文章
1. How to detect and cleanup pending transactions in Oracle
2. 若通过ObjectOutputStream向一个文件中多次以追加方式写入object,为什么用ObjectInputStream读取这些object时会产生StreamCorruptedExcepti
3. String s = new String(“xyz”);创建了几个String Object?
5. 软件测试LoadRunner面试题:How do you identify the performance bottlenecks
6. 什么是Connection-oriented Protocol/Connectionless Protocol面向连接的协议/无连接协议
7. String、StringBuffer、StringBuilder有区别
8. 软件测试LoadRunner面试题:Explain the following functions: – lr_debug_message
9. Oracle中delete,truncate和drop的区别
10. 声明struct x1 { . . . }; 和typedef struct { . . . }x2;有什么不同
本文来源:https://www.mianshiwenti.com/a13450.html
进入下载页面
﹝How to detect and cleanup pending transactions in Oracle﹞相关内容
- Linux Interview Questions For software testers
- What\'s the difference between an interface and abstract class? (接口与抽象类有什么区别)
- Java的类可以定义为Protected或者Private得吗
- 软件测试LoadRunner面试题:What is Ramp up? How do you set this
- 说说在weblogic中开发消息Bean时的persistent与non-persisten的差别
- OLEDBConnection和SQLConnection有什么区别
- string = null 和string = \'\'的区别
- JAVA语言如何进行异常处理,关键字:throws,throw,try,catch,finally分别代表什么意义?在try块中可以抛出异常吗?
- 软件测试LoadRunner面试题:What is think time? How do you change the threshold?
- 软件测试LoadRunner面试题:What is the difference between standard log and extended log?