Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Where can i find a list of uncommitted transactions or sql statements run?

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

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Mon, 04 Dec 2006 17:05:14 +0100
Message-ID: <4tiv9lF148gu7U2@mid.individual.net>


On 04.12.2006 16:05, 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?

Probably in v$session and related.

http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76961/ch3136.htm#9225

        robert Received on Mon Dec 04 2006 - 10:05:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US