【正文】 5天時(shí)間（注：?jiǎn)挝欢际菫榉昼姡篹xec (interval=30, retention=5*24*60)。關(guān)閉AWR自動(dòng)快照把interval設(shè)為0則關(guān)閉自動(dòng)捕捉快照手工創(chuàng)建快照exec ()。查看快照select * from $_active_session_history。刪除快照exec (low_snap_id = 22, high_snap_id = 32, dbid = 3310949047)。，這是個(gè)bug，bug信息為MOS 8622802。如果打算刪除指定數(shù)據(jù)庫(kù)的所有快照，執(zhí)行下面的語(yǔ)句select dbid, status, count(*) from wrm$_snapshot group by dbid, status。exec (dbid)。創(chuàng)建刪除baselineselect dbid,baseline_name,start_snap_id,end_snap_id from dba_hist_baseline。exec (56,59,39。baseline_name39。)。exec (baseline_name = 39。baseline_name39。, cascade = FALSE)。AWR數(shù)據(jù)的導(dǎo)出和導(dǎo)入$ORACLE_HOME/rdbms/admin/ 導(dǎo)出拷貝導(dǎo)出的awr數(shù)據(jù)到目標(biāo)數(shù)據(jù)庫(kù)的指定DIRECTORY$ORACLE_HOME/rdbms/admin/ 導(dǎo)入導(dǎo)入需要注意幾點(diǎn)，輸入DIRECTORY的時(shí)候注意大小寫(xiě)，另外輸入導(dǎo)入的文件名時(shí)只輸入前綴，不要輸入完整的文件名。導(dǎo)入的awr保存期限超過(guò)了100年，所以不會(huì)被自動(dòng)刪除其他產(chǎn)生整個(gè)數(shù)據(jù)庫(kù)的AWR報(bào)告。@$ORACLE_HOME/rdbms/admin/ 產(chǎn)生某個(gè)實(shí)例的AWR報(bào)告。 @$ORACLE_HOME/rdbms/admin/ 產(chǎn)生某條SQL語(yǔ)句的AWR報(bào)告。ORACLE 11GR2中，可以將多個(gè)實(shí)例生成的AWR匯總到一個(gè)文件@$ORACLE_HOME/rdbms/admin/從AWR中獲取TOP 5事件Oracle 10gselect dbid from v$databaseset linesize 200col BEGIN_INTERVAL_TIME for a40col END_INTERVAL_TIME for a40col event for a40select snap_id,begin_interval_time,end_interval_time,snap_level from dba_hist_snapshot。select max(snap_id) from dba_hist_snapshot。col event for a40select case wait_rank when 1 then inst_id end Inst Num, case wait_rank when 1 then snap_id end Snap Id, case wait_rank when 1 then begin_snap end Begin Snap, case wait_rank when 1 then end_snap end End Snap, event_name Event, total_waits Waits, time_waited Time(s), round((time_waited / total_waits) * 1000) Avg wait(ms), round((time_waited / db_time) * 100, 2) % DB time, substr(wait_class, 1, 15) Wait Class from (select inst_id, snap_id, to_char(begin_snap, 39。DDMMYY hh24:mi:ss39。) begin_snap, to_char(end_snap, 39。hh24:mi:ss39。) end_snap, event_name, wait_class, total_waits, time_waited, dense_rank() over(partition by inst_id, snap_id order by time_waited desc) 1 wait_rank, max(time_waited) over(partition by inst_id, snap_id) db_time from (select inst_id, , begin_snap, end_snap, event_name, wait_class, total_waits lag(total_waits, 1, total_waits) over(partition by , , order by ) total_waits, time_waited lag(time_waited, 1, time_waited) over(partition by , , order by ) time_waited, min() over(partition by , , ) min_snap_id from (select dbid, instance_number, snap_id, event_name, wait_class, total_waits total_waits, round(time_waited_micro / 1000000, 2) time_waited from dba_hist_system_event where wait_class not in (39。Idle39。, 39。System I/O39。) union all select dbid, instance_number, snap_id, stat_name event_name, null wait_class, null total_waits, round(value / 1000000, 2) time_waited from dba_hist_sys_time_model where stat_name in (39。DB CPU39。, 39。DB time39。)) stats, dba_hist_snapshot s where = and = and = and = 520444635 and = 1 and between 29930 and 29943) where snap_id min_snap_id and nvl(total_waits, 1) 0) where event_name != 39。DB time39。 and wait_rank = 5 order by inst_id, snap_id。Oracle 11gselect dbid from v$databasecol event for a40set linesize 200col BEGIN_INTERVAL_TIME for a40col END_INTERVAL_TIME for a40col event for a40select case wait_rank when 1 then inst_id end Inst Num, case wait_rank when 1 then snap_id end Snap Id, case wait_rank when 1 then begin_snap end Begin Snap, case wait_rank when 1 then end_snap end End Snap, event_name Event, total_waits Waits, time_waited Time(s), round((time_waited / total_waits) * 1000) Avg wait(ms), round((time_waited / db_time) * 100, 2) % DB time, substr(wait_class, 1, 15) Wait Class from (select inst_id, snap_id, to_char(begin_snap, 39。DDMMYY hh24:mi:ss39。) begin_snap, to_char(end_snap, 39。hh24:mi:ss39。) end_snap, event_name, wait_class, total_waits, time_waited, dense_rank() over(partition by inst_id, snap_id order by time_waited desc) 1 wait_rank, max(time_waited) over(partition by inst_id, snap_id) db_time from (select inst_id, , begin_snap, end_snap, event_name, wait_class, total_waits lag(total_waits, 1, total_waits) over(partition by , , order by ) total_waits, time_waited lag(time_waited, 1, time_waited) over(partition by , , order by ) time_waited, min() over(partition by , , ) min_snap_id from (select dbid, instance_number, snap_id, event_name, wait_class,