Re: monitoring uncommited transactions?

As well as the other suggestions, you can get some information from v$lock - any real transaction will be holding a TX lock in mode 6, and you can check the CTIME column to see how long that lock has been held.

The 'pending transactions' views are for distributed transactions, which is why your local transaction didn't show up.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
Book bound date: 8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



gdas_at_my-deja.com wrote in message <90hgf9$141$1_at_nnrp1.deja.com>...


>Hi,

>

>Aside from monitoring the size of the rollback segments, is there any

>way to monitor the number of uncommitted transactions in the database?

>I thought that the view DBA_PENDING_TRANSACTIONS would do the trick,

>but it didn't return what I expected.  (With the DB idle, I sent an

>update from one session and without committing it, I issued a count(*)

>against dba_pending_transactions from another session.  I was expecting

>to be returned "1", but it returned "0").

>

>The reason I'm asking is because this a dev system.  Someone recently

>introduced a bug whereby the application didn't commit any of it's

>work .  After a few hours, the entire DB halted and was complaining

>that all rollback segments were full and that the max number of

>transactions had been exceeded.

>

>A fix was attempted, and the developers have asked me if there is a way

>to monitor the commit activity in the db so that they can be sure it's

>fixed.

>

>Does anyone know of a way?  (This is on version 8.1.5).

>

>Thanks for any help,

>Gavin

>

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.