AWR 일별 수집
DB CAFE
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
파일(F 편집(E) 서식(0) 보기~ 도움말 --awr 수집 sh sqlplus -s pjtdba/qhwkd!001@dussp014 < < EOF > /oracle/work/AWR/log/awr_$1.log set heading off set timing on set linesize 150 set pagesize 0 --set feedback off --set termout off col db_id new_value db_id; col inst_num new_value inst_num; col bid new_value bid; col eid new_value eid; col crtrYmd new_value crtrYmd; col stime new_value stime; col etime new_value etime; select '$1' as crtrYmd from dual; select dbid as db _id from utt$database; select listagg(instance_number, ') within group(order by instance_number) as inst_num from gut$instance; select min(snap_id) as bid , max(snap_id) as eid from ba_hist_snapshot where BEGIN_ INTERVAL_TIME between to_date('&crtrYmd 000000' YYYYMMDD HH24MISS') and to_date('&crtrYmd 235959*, YIYMMDD H24MISS") --and instance_number = 4 order by snap_id insert into TB_AWR_HIST