Re: User's running command

"Janos Makadi" <jmakadi_at_fc.dunaferr.hu> a écrit dans le message de news:2jvrjoF16j9mfU1_at_uni-berlin.de...
> Hello,
>
> Does anybody know, what is the proper way to determine the user's actual
> running command? I mean, I would like to know, what commands run the
> users listed in v_$session. I found v_$sqlarea, but I don't know how to
> combine them.
>
> Regards,
>
> Janos Makadi

select v$session.sid, v$sqlarea.sql_text from v$session, v$sqlarea
where v$session.sql_address=v$sqlarea.address and v$session.sql_hash_value=v$sqlarea.v$sqlarea;

Regards
Michel Cadot Received on Thu Jun 24 2004 - 14:06:03 CDT