RE: transaction ???

From: Jon Walthour <jonw_at_fuse.net>
Date: Sun, 19 Aug 2001 17:10:58 -0700
Message-ID: <F001.0037055D.20010819171530@fatcity.com>

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: janetlinsy_at_yahoo.com

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: ListGuru_at_fatcity.com (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: jonw_at_fuse.net

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: ListGuru_at_fatcity.com (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).

Received on Sun Aug 19 2001 - 19:10:58 CDT