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?

larry_freeman (AT) dnr (DOT) state.ak.us (akdnr_larry) wrote in message news:<b8182012.0306251100.5a49177b (AT) posting (DOT) google.com>...
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 --