Re: How to determine if a procedure is currently running.

Thanks for reply Gabriel

I have had a look at the V$SESSION view and am not sure that it will give
me what I am looking for. For example I run 2 sessions of Worksheet. In one of them I start a stored procedure in the other I monitor v$session. V$session tells me that I am running worksheet but does not tell me that one of my worksheet sessions is running a specific stored procedure. Can I get at this information some where else, possibly at a lower level to v$session?

Regards
John

gabriel.radu_at_znt.de (Gabriel Radu) wrote in message news:<d9d350a7.0111090116.1fe7956e_at_posting.google.com>...
> Hi John,
>
> Your assumption was right:
> you can use the V$SESSION administrative view.
>
> Best regards,
> Gabriel
>
> john_killeen_at_hotmail.com (Killeen) wrote in message news:<e05ea253.0111081018.62fff9f0_at_posting.google.com>...
> > Hi all,
> > It is a while since I have done anything in Oracle any the site I am
> > working at has very few books on Oracle. I am trying to find out how I
> > can determine from SQL whether a stored procedure is currently running
> > or not? I assume I can read this information from one of the V$ views.
> >
> > Regards
> > John
Received on Fri Nov 09 2001 - 16:43:24 CET