Re: lockwait session

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 26 Jun 2003 07:02:35 -0700
Message-ID: <2687bb95.0306260602.50dbfaf1@posting.google.com>

larry_freeman_at_dnr.state.ak.us (akdnr_larry) wrote in message news:<b8182012.0306251100.5a49177b_at_posting.google.com>...
> I have a v$session.lockwait value that has no equal v$lock.kaddr
> value. How do I find the offending lock and remove it?

Take a look at the results of $ORACLE_HOME/rdbms/admin/utllockt, which will show lock waited sessions and the session they are waiting on.

You can also look at How do you find out who is locking a specific row in a table? at http://www.jlcomp.demon.co.uk/faq/locked_rows.html

If your are waiting on a row specific row then the v$session rowid columns: row_wait*, should be populated.

HTH -- Mark D Powell -- Received on Thu Jun 26 2003 - 09:02:35 CDT