DBA面试题

当前位置: 面试问题网 > DBA面试题 > How to detect and cleanup pending transactions in Oracle

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

【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

点击展开全部

《How to detect and cleanup pending transactions in Oracle》

将本文的Word文档下载到电脑,方便收藏和打印

推荐程度:

进入下载页面

﹝How to detect and cleanup pending transactions in Oracle﹞相关内容

其它栏目

也许您还喜欢