-
select * from dba_2pc_pending;
When a DO the select
PNXTL02-:dbahiran> select * from dba_2pc_pending;
LOCAL_TRAN_ID GLOBAL_TRAN_ID
---------------------- ------------------------------------------------------------
STATE MIX A
---------------- --- -
TRAN_COMMENT
-----------------------------------------------------------------------------------
FAIL_TIM FORCE_TI RETRY_TI OS_USER
-------- -------- -------- --------------------------------------------------------
OS_TERMINAL
-----------------------------------------------------------------------------------
HOST DB_USER COMMIT#
-------------------- ------------------------------ ----------------
5.75.38968 PNXTL02.WORLD.8af73dfe.5.75.38968
collecting no
19/11/03 19/11/03 NBarbosa
BRRIO1W2K0179
xxxx\BRRIO1W2K0179 NBARBOSA 6527257198256
How I Kill this process???
-
login as sys and
exec dbms_transaction.purge_lost_db_entry('the_local_tran_id');
or
exec dbms_transaction.purge_lost_db_entry('5.75.38968');
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|