Items in v$locked_object;

Hi,

I need help. The situation is as follows: There are some clients that are connected to Oracle 8.0.5 on Solaris 2.6 (with sync. replication on).

Besides transaction requests from clients, there are also cron jobs set in place to preiodically scan the tables for certain conditions.

The problem is with "unlockable" items in v$locked_object, due to some "currently unknown" reason". Sometimes I manage to manually do a "ALTER SYSTEM KILL SESSION ..." but sometimes I can't.

Since a few records are locked, the only solution I had was to restart the instance to remove the lock on the objects.

I find this strange and have no clue as to how to begin debugging the situation.

It is appreciated if I get some help on the following:

1. What does LOCKED_MOD column refers to in v$locked_object, specially values 2 and 3.
2. How do I trace the cause of the lock and manually unlock it? (note: the "PROCESS" column in v$locked_object no longer exists and a "ALTER SYSTEM KILL SESSION" is unable to find the session in question.)
3. I have checked through the cron jobs, scripts and stored procedures and am convinced of trapping exceptions in every conceiveable places with ROLLBACK or COMMIT inserted. Are there anymore things I overlooked?
4. Documentation in Replication and related issues does not seem to be in abundance. Can someone advice on what books or site to visit for more info.

Thanks in advance.
Regards,

   Joe
Regards, Received on Fri Apr 23 1999 - 11:23:30 CDT