Actually, I think the executing_packages script should be exactly what I
need.
Thank you very much. I had browsed ixora but didn't make the connection
between this script and what I was looking for.
Jay Miller
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002
Jay,
Don't know for sure but you could try Ixora's script to show executing packages
available at http://www.ixora.com.au/scripts/misc.htm
You could also look for blocked internal locks - try the following:
select * from dba_lock_internal
where
( mode_held = 'Null' OR mode_held =