To find currently running sql, run the following query:
SELECT a.username AS username
, a.sid AS sid
, a.serial# AS ser#
, b.sql_text AS statement
FROM v$session a
, v$sqltext b
WHERE a.username IS NOT NULL
AND a.status = 'ACTIVE'
AND a.sql_address = b.address
AND a.sql_hash_value = b.hash_value
AND a.audsid != USERENV('sessionid')
ORDER BY sid
, ser#
, b.piece;
To check out lots of scripts for tuning, look into Steve Adams' website
at http://www.ixora.com.au.
Jon Walthour
-----Original Message-----
Linsy
Sent: Sunday, August 19, 2001 6:41 PM
To: Multiple recipients of list ORACLE-L
Hi, all
How to find the currently running transaction,
including user, sql_text, etc?
Do you have any scripts for monitoring, tuning
transactions?
Thank you!
Janet
__________________________________________________
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: Janet Linsy
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: Jon Walthour
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).
