On Dec 4, 12:47 pm, "sybrandb" <sybra..._at_gmail.com> wrote:
> 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
Thanks Sybrand
Received on Tue Dec 05 2006 - 12:51:52 CST
