谢谢楼上的兄弟,我按照lihaibolw方法,但是测试出来的如下.好象不对,是不是哪里稿错了?
select sql_text from v$sqlarea where address in(select sql_address from v$sessio
n where status='ACTIVE' and last_call_et>10);
select f.file#, f.block#, f.ts#, f.length from fet$ f, ts$ t where t.ts#=f.ts# a
nd t.dflextpct!=0 and t.bitmapped=0
select local_tran_id, global_tran_fmt, global_oracle_id, global_foreign_id,
state, status, heuristic_dflt,session_vector, reco_vector, 3600*24*(s
ysdate-reco_time),3600*24*(sysdate-nvl(heuristic_time,fail_time)), globa
l_commit#, type# from pending_trans$where session_vector != '00000000'
|