| uncommitted transaction's SQL [message #317972] |
Mon, 05 May 2008 02:53  |
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
