oracle database11g性能優(yōu)化less使用基于awr的工具

課程目 7-自 任7-窗窗口10PM2AM610PM2AM7-默 計(jì)SQL>SELECTnameFROM 2WHEREis_top_ n='TRUE'; 7-…優(yōu)先運(yùn)行…優(yōu)先運(yùn)行優(yōu)先運(yùn)行優(yōu)先運(yùn)行窗…使窗…使用緊運(yùn)行

…作業(yè)7-優(yōu)化自 任“Server>AutomaticMaintenanceTasks> 7-ADDM性能監(jiān)60統(tǒng)計(jì)信快ADDM7-ADDM和數(shù)據(jù)庫時(shí)用戶用戶發(fā)請用戶獲響Oracle數(shù)據(jù)數(shù)據(jù)庫連執(zhí)提提提執(zhí)7-數(shù)據(jù)庫時(shí)間圖和ADDM方法根節(jié)故障現(xiàn)用 連 優(yōu)

執(zhí)

數(shù)能 庫根本原維7-7-檢測到的首要性能問未檢測

RAC服務(wù)問題鎖和ITL爭用PL/SQL、JavaOracleStreams、AQI/O問題

7-7-ADDM分析結(jié)1237-ADDM建7-DatabaseControlADDM任7-ADDM屬I/OADDMI/O度量I/O設(shè)置預(yù)期速度'ADDM','DBIO_EXPECTED',8000);SELECTparameter_value,is_default WHEREadvisor_name='ADDM'ANDparameter_name=7-SELECT

task_id=(SELECT

dba_advisor_loglt.task_id=l.task_idANDt.advisor_name='ADDM'ANDl.status='COMPLETED');SQL>…Entervalueforbegin_snap:8Entervalueforend_snap:10…EntervalueforGeneratingtheADDMreportforysis7-活動(dòng)會(huì)話歷史記錄：概對象編號(hào)、文件編號(hào)和塊編等 標(biāo)識(shí)符和參會(huì)話標(biāo)識(shí)符和會(huì)話序列模塊和操作名會(huì)話的客戶機(jī)標(biāo)識(shí)服務(wù)散列標(biāo)識(shí)阻塞會(huì)7-活動(dòng)會(huì)話歷史記錄：技統(tǒng)計(jì)信

11秒 1秒 最近歷史記

緩沖

工作量資 7-等待1秒 等待等待1 等待……時(shí)活

1I/O1I/O1等待塊…

活活…7-ASH數(shù) ASH7-SQL>oradebugSQL>oradebugdumpashdump<<<ACTIVESESSIONHISTORY-PROCESSTRACEDUMPHEADERDBID,INSTANCE_NUMBER,SAMPLE_ID,SAMPLE_TIME,SESSION_ID,SESSION_SERIAL#,USER_ID,SQL_ID,SQL_CHILD_NUMBER,SQL_ N_HASH_VALUE,SERVICE_HASH,SESSION_TYPE,SQL_OPCODE,BLOCKING_SESSION,BLOCKING_SESSION_SERIAL#QC_SESSION_ID,QC_INSTANCE_ID,XID,CURRENT_OBJ#,CURRENT_FILE#,CURRENT_BLOCK#,EVENT_ID,SEQ#,P1,P2,P3,WAIT_TIME, _MATCHING_SIGNATURE,PROGRAM,MODULE,ACTION, <<<ACTIVESESSIONHISTORY-PROCESSTRACEDUMPHEADER<<<ACTIVESESSION PROCESSTRACEDUMP ,"08-26-2005 ",162,1,0,"",0, , , ,1664,0,0,0,0,646200, ,"08-26-2005 ", , ,0,0,0,,8751, 89,"emagent@edrsr14p1(TNSV1-V3)","emagent@edrsr14p1(TNSV1-V3)","",""…<<<ACTIVESESSIONHISTORY-PROCESSTRACEDUMP7-sql_id,round(count(*)/sum(count(*))sql_id,round(count(*)/sum(count(*))over(),2)sample_time>sysdate-1/24/60andsession_type<>'BACKGROUND'GROUPBYORDERBYcount(*)GROUPBY非空閑已用時(shí)間實(shí)際花費(fèi)時(shí)間的比7-7-ASH報(bào) = =report_type=begin_time= =report_name=slot_width= = = =target_service_hash=ta