How to identify SQLText of a Process/Session?
From: badri <badri_at_cc.gatech.edu>
Date: 1996/04/02
Message-ID: <4jstgr$pjo_at_gaia.cc.gatech.edu>#1/1
Date: 1996/04/02
Message-ID: <4jstgr$pjo_at_gaia.cc.gatech.edu>#1/1
Hi:
Given all the information in V$SESSION and V$PROCESS, can I
get the SQL text of that particular process? These views only give me
the command type (as in select or insert, but I want the entire statement).
In other words, I want to be able to see the SQLText of a
given ORACLE_PID or SPID or SID/SEQ# combination.
Can this be done?
thanks a lot,
-Badri
p.s: How else can I use V$SQLarea to tie back to processes?