Re: script for detect user blocking problem

Mate you are going to load up your database running a lock check script every 10 seconds.

There is either a problem with the app
or you could modify the table parameters if you are going to have a massive number of concurrent users locking the table.

Query the v$sysstat to check to see how bad the locks (enqueues) are... Also having a look at what sessions are waiting on, as it might indicate that
locks are not the problem.

Have Fun

--
Posted via http://dbforums.com