Re: Where can i find a list of uncommitted transactions or sql statements run?

Wally wrote:
> DB: Oracle 8.1.7.4.1
> OS: Windows 2000
>
> Lets say I have an update, insert or delete statements that has been
> run in sql * plus, but hasn't been committed yet. Is there a table/view
> in the database that I can query on to find these pending uncommited
> transactions or statements?
>
> Thanks.

You would need v$lock, v$transaction, v$session, and v$sql

address of v$transaction links to v$session.taddr
address of v$lock links to v$session.kaddr
address of v$sql links to v$sql.sql_address

Hth

-- 
Sybrand Bakker
Senior Oracle DBA