v$lock

From: Michael B. Allen <mballen_at_erols.com>
Date: 27 Jun 2001 08:56:12 GMT
Message-ID: <slrn9jj860.401.mballen@nano.foo.net>

If I do:

select v$session.sid, v$session.username

	from v$session, v$lock
	where v$session.sid = v$lock.sid;

the query returns about 15 entries with sid == 2 but then just hangs. Is this normal?

I want to write two cgi scripts; one that produces a list of sessions holding locked records with username, machine, program, etc with a link to the second cgi script which will kill the session with alter system kill ...

What's the best way to do this?

Thanks,
Mike Received on Wed Jun 27 2001 - 03:56:12 CDT