uncommitted transaction's SQL [message #317972] |
Mon, 05 May 2008 02:53 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
fozerol
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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.
Regards
Michel
|
|
|