dba_2pc_pending 中有21条几年前的事务,想清除,这样行不行?
来源:互联网 发布:一笔签名设计软件 编辑:程序博客网 时间:2024/05/16 23:21
dba_2pc_pending 中有21条几年前的事务,想清除,请大家帮忙
看看下面的方法行不行!
A: Cleanup Steps: Before you begin, make note of the local transaction ID,, from the error message reported.
1. Determine if you want to attempt a commit or rollback of this transaction. You can do the following select to help determine what action to take:
SQL>; select state, advice from dba_2pc_pending where
local_tran_id = "";
2. Commit or rollback the transaction. To commit: SQL>; commit force ““; To rollback:
SQL>; rollback force ““;
3. If your are using release 7.3.x or greater and Step 1 above fails, execute the following command in either Server Manager or SQL*Plus: SQL>; execute dbms_transaction.purge_lost_db_entry(““);
NOTE: The purge_lost_db_entry function is fully documented in the "dbmsutil.sql" script located in the "$ORACLE_HOME/rdbms/admin" directory.
4. If running a release below 7.3 -OR- both Steps 1 and 2 above have failed, do the following: Connect to Server Manager or SQL*Plus and execute the following commands:
SQL>; set transaction use rollback segment system;
SQL>; delete from dba_2pc_pending where local_tran_id = ““;
SQL>; delete from pending_sessions$ where local_tran_id = ““;
SQL>; delete from pending_sub_sessions$ where local_tran_id = ““;
SQL>; commit;
在我的数据库中,是第4种情况,直接delete安全吗?
看看下面的方法行不行!
A: Cleanup Steps: Before you begin, make note of the local transaction ID,, from the error message reported.
1. Determine if you want to attempt a commit or rollback of this transaction. You can do the following select to help determine what action to take:
SQL>; select state, advice from dba_2pc_pending where
local_tran_id = "";
2. Commit or rollback the transaction. To commit: SQL>; commit force ““; To rollback:
SQL>; rollback force ““;
3. If your are using release 7.3.x or greater and Step 1 above fails, execute the following command in either Server Manager or SQL*Plus: SQL>; execute dbms_transaction.purge_lost_db_entry(““);
NOTE: The purge_lost_db_entry function is fully documented in the "dbmsutil.sql" script located in the "$ORACLE_HOME/rdbms/admin" directory.
4. If running a release below 7.3 -OR- both Steps 1 and 2 above have failed, do the following: Connect to Server Manager or SQL*Plus and execute the following commands:
SQL>; set transaction use rollback segment system;
SQL>; delete from dba_2pc_pending where local_tran_id = ““;
SQL>; delete from pending_sessions$ where local_tran_id = ““;
SQL>; delete from pending_sub_sessions$ where local_tran_id = ““;
SQL>; commit;
在我的数据库中,是第4种情况,直接delete安全吗?
- dba_2pc_pending 中有21条几年前的事务,想清除,这样行不行?
- DBA_2PC_PENDING
- DBA_2PC_PENDING
- 请问在数据库中视图的作用有多大,或者不用行不行
- 不知道这样看起来行不行
- 这21条几乎概括了运营人存在的所有问题,很多人看后都恍然大悟!
- 23年前,有个年轻的女子...
- 千万不要让生命中有这样的遗憾
- Sendmail日志中经常有这样的提示:Connection refused
- 高手都是这样清除系统垃圾的
- spring事务定义中,@Transactional(readOnly = true, propagation = Propagation.NOT_SUPPORTED) 这样定义有问题吗?
- 测测你的杀毒软件行不行
- 竟然有这样的程序员
- 有一个这样的男人
- 有这样写法的html
- 有这样的家长,无语中
- 第一次有这样的帐号
- 怎么会有这样的代码
- 经典BBS语录2007贺岁版
- 雨花台
- enmu新用法(我刚刚发现)
- 熊猫烧香病毒超强分析(手工查杀方法)
- 如何预防“熊猫烧香”系列病毒?
- dba_2pc_pending 中有21条几年前的事务,想清除,这样行不行?
- 使用BMCONV工具加工自己的MBM 和MBG文件
- 游戏外挂高手合作征求
- Unix/Linux下 getrusage 的用法
- Winform DataGrid设计三步曲之三----如何改变DataGrid的背景色
- C++标准库名字和头文件--表
- 关于Donews的记忆---第一次用Donews
- 关于Donews的记忆---段段经典
- 关于Donews的记忆---游标