set linesize 200
set pages 999

select begin_time, TXNCOUNT trans_count , undoblks, MAXQUERYID , activeblks, unexpiredblks, expiredblks , sid, serial#, substr(sql_text, 1,30)
from v$undostat u left join (select s.sid, s.serial#, t.sql_id, t.sql_text from v$sqltext t , v$session s where s.sql_id=t.sql_id ) s on (sql_id = MAXQUERYID)
where sql_text is not null

ORDER BY UNDOBLKS

select * from v$session where sid=136 adn serial#=46785