wavelet123的专栏

在有些情况下，有些死事务在后台回滚，v$transaction

SQLT中有个jiaobdeclare  ar_profile_hints sys.sqlprof_attr;  cl_sql_text clob;  l_profile_name varchar2(30);begin  select sql_fulltext,'PROF_'||sql_id||'_'||plan_hash_value into cl_sql_tex

select sid, serial#, username, to_char(sysdate-last_call_et/24/60/60,'hh24:mi:ss') started,trunc(last_call_et/60) || ' mins, ' || mod(last_call_et,60) || ' secs' dur,(select sql_text from v$sql wher

WITH system_event AS (select sn.begin_interval_time begin_interval_time,         sn.end_interval_time end_interval_time,         se.event_name event_name,         se.total_waits e_total_waits,