Our DBA is the only person who knows the login info, he is gone and I can't get a hold of him, I found some info on forcing a commit but I think where I delete the record form the dba_2pc_pending table, that it does not find the transaction to force the commit on. I think I am gonning up the river without a paddle.


I have shut down the DB and started it back up but the lock is still there.

Got any more ideas??

Thanks
Scott