Bruce,
Not off the top of my head - never really worked in a forms environment -
but I will have a look in to it tonight, as I've had a bit of a busy day
doing my Real job today :)
Maybe somebody can help in the meantime? But I'll certainly see if I can
find an answer tonight..
Regards
Mark
, June 04, 2001 5:00 PM
Subject: Re: Which SQL is executing
SELECT T.SQL_TEXT FROM V$SQLTEXT T,V$SESSION S
WHERE S.SQL_ADDRESS=T.ADDRESS ORDER BY T.PIECE;
Sam
- Original Message -
From:
Chuan
Zhang
To: Multiple
recipients of list ORACLE-L
uWHERE s.hash_value =
u.sql_hash_valueORDER BY user_name/
HTH,
Rajesh
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Chuan ZhangSent:
Wednesday, June 06, 2001 11:25 AMTo: Multiple recipients of list
ORACLE-LSubject: Re: Which SQL is executing
ORACLE-LSubject: Re: Which SQL is executing
Hi, Sam,
Thanks for your information.
To my understanding,the script you gave is
for all the queries. There is still no way to figure out which query is
running.
Chuan,
- Original Message -
From:
Sam
Mark,
Do you have a corresponding query for a Forms type environment where a user
can have more than 1 statement running at the same time.
For example,
In forms I can open 1 form and start an update - the query below will show
that as the current cursor.
If I then swap to another form and do an
SELECT T.SQL_TEXT FROM V$SQLTEXT T,V$SESSION S
WHERE S.SQL_ADDRESS=T.ADDRESS ORDER BY T.PIECE;
Sam
- Original Message -
From:
Chuan
Zhang
To: Multiple recipients of list ORACLE-L
Sent: Monday, June 04, 2001 9:30 AM
Subject: Which SQL is executing
Hi All,