Oracle DB: Uncommited transactions

You can find the number of uncommited transactions using the following query:

SELECT ROWS_PROCESSED,sql_text
FROM v$sqlarea
WHERE (address, hash_value) IN
(SELECT sql_address, sql_hash_value
FROM v$session
WHERE sid in (select sid from v$session where schemaname='VAG'))

or using v$transaction table:

select * from v$transaction

where used_urec is the number of records processed

Leave a Reply