根据metalink脚本学习undo（六）

关于undo的统计 包括最长执行的sql语句等

set lines 120
set pages 999
clear col


set termout off
set trimout on
set trimspool on


connect / as sysdba
alter session set nls_date_format='dd-hh24:mi';


spool undostatistics.out


prompt
prompt  ############## RUNTIME ############## 
prompt


col rdate head "Run Time"


select sysdate rdate from dual;


col current_scn head "SCN Now"
col start_date head "Trans Started"
col start_scn head "SCN for Trans"
col ses_addr head "ADDR"


prompt 
prompt  ############## Historical V$UNDOSTAT (Last 2 Days) ############## 
prompt 




col end_time format a18 Head "Date/Time"
col maxq format 999,999 head "Query|Maximum|Minutes"
col maxquerysqlid head "SqlID"
col undotsn format 999,999 head "TBS"
col undoblks format 999,999,999 head "Undo|Blocks"
col txncount format 999,999,999 head "# of|Trans"
col unexpir