Subject Re: Which connection causes object in use - is there a way to find that out?
---In, <t.tyrakowski@...> wrote :

> From time to time, when I try to alter a stored procedure in a
> production database, I get "object in use" error.

  Run DDL statement in wait transaction. Better to set some timeout to not wait too much, but not no-wait mode

> I was wandering, is
> there a way to find the connections (users) that prevent a particular
procedure from being altered?

  No, sorry (one can use lock manager but it is not trivial)