Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: User's running command

Re: User's running command

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 24 Jun 2004 22:44:45 +0200
Message-ID: <40db3d18$0$29363$626a14ce@news.free.fr>

"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 Cadot
Received on Thu Jun 24 2004 - 15:44:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US