Sean,
A lock would normally go away when the database is shut down, but if the
problem was in the application (or the users), the lock would probably come
right back again.
Check In v$lock for type TX locks with lmode=6 . These are exclusive row
locks caused by updates or select for
On of our applications is reporting a problem trying to access on a record
in a table. The application is reporting that a transaction is reserved for
update. The app in question hung whilst working on the record a few days
ago. I'm not convinced that this is an Oracle problem, i.e. a row lock