[20231025]完善tpt的trans.sql脚本.txt

[20231025]完善tpt的trans.sql脚本.txt --//补充status2字段，说明一些细节。 -- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com -- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions. col 0xFLAG just right col trans_username HEAD USERNAME FOR A25 select     s.sid   , s.serial#   , s.username       trans_username   , t.addr taddr   , s.saddr ses_addr   , t.used_ublk   , t.used_urec --  , t.start_time   , to_char(t.flag, 'XXXXXXXX') "0xFLAG"   , t.status||CASE WHEN BITAND(t.flag,128) = 128 THEN ' ROLLING BACK' END status   , decode(t.space, 'YES', 'SPACE TX', decode(t.recursive, 'YES', 'RECURSIVE TX', decode(t.noundo, 'YES', 'NO UNDO TX', t.status) )) status2   , t.start_date   , XIDUSN   , XIDSLOT   , XIDSQN   , t.xid   , t.prv_xid   , t.ptx_xid from     v$session s   , v$transaction t where     s.saddr = t.ses_addr /