Home » RDBMS Server » Server Administration » uncommitted transaction's SQL (oracle 10g r2)
uncommitted transaction's SQL [message #317972] Mon, 05 May 2008 02:53 Go to next message
Messages: 17
Registered: March 2007
Junior Member
is there any way to get uncommitted transaction's SQL
I can get sessions and usernames with joining v$rollname, v$transactions and v$session but cant get any sql_id in order to join v$sql
users last sql dont help me because they can run any sql after transactions begins before comitting it

for instance a user named scott runs sqlplus

sqlplus> update orders set aaa=111 where orderid=12345;
runs any sql query here (users last sql dont help)
waits without issuing commit or rollback

i want to get this sql "update orders set aaa=1111 where orderid=12345"

Thanks for your replies

[Updated on: Mon, 05 May 2008 03:06]

Report message to a moderator

Re: uncommitted transaction's SQL [message #318002 is a reply to message #317972] Mon, 05 May 2008 04:51 Go to previous message
Michel Cadot
Messages: 63930
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Either audit the updates or use Log Miner to mine the logs.
You can't have it for sure in V$SQL, the statement may have been get out of the SGA.

Previous Topic: DBA activity on launching(installing) new application
Next Topic: howo to manage recovery area?
Goto Forum:

Current Time: Thu Oct 27 04:24:07 CDT 2016

Total time taken to generate the page: 0.06734 seconds