How to detect and cleanup pending transactions in Oracle

DBA面试题手机阅读

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();

【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？

4. Collection和Collections的区别

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