Snapshot 기반 TPR 추출 구문

alter session set NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS' ;


exec DBMS_TPR.REPORT_TEXT('2015/04/05 15:36:28','2015/04/05 19:25:58',INSTANCE_NO=>'0') ;


exec DBMS_TPR.REPORT_TEXT_ID(SNAP_ID);


exec DBMS_TPR.REPORT_TEXT_ID(BEGIN_SNAP_ID=>'1927',END_SNAP_ID=>'1939',INSTANCE_NO=>'0');


exec DBMS_TPR.REPORT_TEXT_ID(BEGIN_SNAP_ID=>'1907',END_SNAP_ID=>'1919',INSTANCE_NO=>'1');


exec dbms_TPR.report_txt(1907,1919,instance=>'1');



<SNAP SHOT CREATE>

exec dbms_TPR.create_snapshot()


set linesize 150

alter session set nls_date_format='yyyymmdd hh24:mi:ss';


select * from _TPR_snapshot where THREAD#='0' ;


<모니터링 구간 조회>

alter session set nls_date_format='yyyymmdd hh24:mi:ss';

select * from _TPR_snapshot;


<모니터링 구간 report 생성>

exec dbms_TPR.report_text('20110512 17:53:51','20110512 17:58:54');