Re: Record lock

From: Wuchun Shen <shen.wuchun_at_bcg.com>
Date: Mon, 03 Jan 2000 15:41:52 -0500
Message-ID: <38710990.9167DE63@bcg.com>

I suspect the reason was it was still in the process of rolling back the transaction
even after the user got disconnected. First, pmon has to detect the dead process,
then rollback kicks in.....Once, I have to wait 10 mins to see a killed session going away.
It all depends on your particular transaction and how much data needs to be roll back.

Regards,

Wuchun

"S. Han" wrote:

> Hi,
>
> We are running VB application with Oracle8 as backend. Somehow while
> during updates, the PC got crashed, and after the user logged in
> again and tried to retrieve the same record, she got the error message
> saying record is locked by another user under HER userid. Well, she
> wasn't loging into another machine. We had to manually go into v$session
> and kill all her sessions. Isn't PMON supposed to terminate this user's
> sessions automatically? Can somebody figure out what was going on?
> Thanks a million!
>
> Steph
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jan 03 2000 - 14:41:52 CST