Record lock

From: S. Han <shan168_at_yahoo.com>
Date: Mon, 03 Jan 2000 18:12:43 GMT
Message-ID: <84qoqf$hvc$1@nnrp1.deja.com>

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 - 12:12:43 CST