Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: User's running command
"Janos Makadi" <maki_at_freemail.hu> a écrit dans le message de
news:_5GCc.122957$vP.111807_at_news.chello.at...
> Michel Cadot wrote:
> > 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
>
> THX
>
> Janos Makadi
Sorry last line is:
and v$session.sql_hash_value=v$sqlarea.hash_value;
-- Regards Michel CadotReceived on Thu Jun 24 2004 - 15:44:45 CDT