web analytics
Skip to primary content
Skip to secondary content

MemoSoup

Mix of the things I always forget

MemoSoup

Main menu

  • Home
  • About
  • Links

Tag Archives: run

Oracle: list of the running transactions

Posted on 09/02/2010 by bigspoon
Reply

This query shows SID, username and start time of the running transaction.
In addition, number of the used blocks is shown.


SELECT a.sid, a.status, a.username, b.xidusn, b.used_urec, b.used_ublk, b.START_TIME
FROM v$session a, v$transaction b
WHERE a.saddr = b.ses_addr
order by START_TIME desc;

Posted in Oracle | Tagged Oracle, run, transaction | Leave a reply

Archives

  • March 2021
  • February 2016
  • February 2013
  • December 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • July 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • February 2010
  • January 2010
  • December 2009
  • November 2009
  • October 2009
  • September 2009
  • August 2009

Meta

  • Log in
Proudly powered by WordPress