Viewing which sql query is associated to a SPID
From: Sebastien Le Floc'h <slefloch_at_immostreet.com>
Date: Wed, 21 Mar 2001 11:27:45 GMT
Message-ID: <Re0u6.52$2A.177278_at_nnrp4.proxad.net>
Date: Wed, 21 Mar 2001 11:27:45 GMT
Message-ID: <Re0u6.52$2A.177278_at_nnrp4.proxad.net>
Hi
[Quoted] I'm looking for the way to viey which sqlquerie is executing a SPID :
(oracle8.i)
select spid, v$session.program, osuser, v$session.username, status,to_char(logon_time,'YYYYMMDD HH24:MI') from v$process, v$session where v$process.addr=v$session.paddr order by status, v$session.username,v$session.program
gives me informations on wich SPID runs an active connection I'd like to associate which SQLquery it is executing, but I can't find it on [Quoted] Oracle doc
1664 ? _at_titi.fr (TNS V1-V3) root MYUSER ACTIVE 20010321 12:20 ||||| select * [Quoted] from my1000000linetable |||| <- I will know why my db is out of order !!!
Any DBA can help ? Received on Wed Mar 21 2001 - 12:27:45 CET