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