DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: select * from dba_2pc_pending;

  1. #1
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    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???

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
  •  


Click Here to Expand Forum to Full Width