My database version is "Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production" rac .
My test steps as the followings
Step1
SQL> select * from v$transaction;

no rows selected

SQL> update test set tname='t' where tid=1;

1 row updated.

ps:uncommit
Step2: SQL> select ADDR,start_time from v$transaction;

ADDR START_TIME
---------------- --------------------
000000008F2DFC60 10/30/15 13:33:22

Step3:now i want to query uncommit transction sql;
but i can't find the sql.
if i use 'select SQL_TEXT from v$sql,v$transaction where LAST_ACTIVE_TIME=START_DATe;',
the result is 'select SQL_TEXT from v$sql,v$transaction where LAST_ACTIVE_TIME=START_DATe;

SQL_TEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
update test set tname='t' where tid=1
SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1),:"SYS_B_0"), NVL(SUM(C2),:"SYS_B_1") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("TEST") FULL("TEST") NO_PARALLEL_INDEX("TEST") */ :"SYS_B_2" AS C1, CASE WHEN "TEST"."TID"=:"SYS_B_3" THEN :"SYS_B_4" ELSE :"SYS_B_5" END AS C2 FROM "TEST" "TEST") SAMPLESUB
'
the result is not my want,becasue it not only contains the update sql.
if i use 'select gs.SQL_TEXT,
t.start_time,
s.sid,
s.serial#,
s.username,
s.status,
s.schemaname,
s.osuser,
s.process,
s.machine,
s.terminal,
s.program,
s.module,
to_char(s.logon_time, 'DD/MON/YY HH24:MI:SS') logon_time
from gv$transaction t, gv$session s,gv$sql gs
where s.saddr = t.ses_addr
and (s.SQL_ID=gs.SQL_ID or s.PREV_SQL_ID = gs.sql_id)
order by start_time
'
the result is still wrong..

So, is there any sql can help find the uncommit transaction sql ?