Hi
Here is something to give you a start :
select s.sid,
s.username,
t.sql_text
from v$session s,
v$sqltext t
where s.sid = THE_SID_U_R_INTERESTED_IN
and s.sql_hash_value = t.hash_value;
There is a lot more info you can glean out of this - the key is to join
either V$SESSION & V$SQLTEXT or V$SQLAREA, or in fact all of the above with
something like the HASH_VALUE/SQL_HASH_VALUE columns.
Have a dig..
HTH
Mark
-----Original Message-----
maganti
Sent: Monday, August 06, 2001 03:11
To: Multiple recipients of list ORACLE-L
Hi
how can i see the sql statements that are related to a
particular session .
i think it can be seen from v$sqlarea.
anybody of you have the statement ?
reg/
prsad
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: prasad maganti
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
