??????????????????????????AWR??
??????????????ò???AWR??
??????????????Oracle??????????????????????????????????????AWR????????TOP 10 SQL????????????????????
??????????????????????????Щ???????????д???????????????????????????????????
??????????????????????????????
???????????AWR???????????????
?????????AWR???????????????????С??????????С?????вο??????
??????Σ?AWR?????????????С????????y??ASH??????
??????Σ?AWR????????????С???????????????ASH??
????С?????
????1?????????ASH??
????@?/rdbms/admin/ashrpt.sql
????2?????awr????????????????30?????10??
????exec dbms_workload_repository.modify_snapshot_settings(interval=>30??Retention=>10*24*60);
???????????????????DB Time

????dbtime???AWR?????????????????????????????????????????????????AWR???棩
????dbtime?????????dbtime=cpu????*60??=32*60=1920????????CPU?????32??
????????DB Time??????1920????????CPU????? ???
??????????????????Load Profile
?????????????

????Redo size    --??λ??Byte????С???31M?????????????Redo Size ??д??????31M/S??
????--???????????redo???????С????????
???????Redo??д???????31M/S?????redo log???С?????????????
???????Redo??3??д????ε?????????д???????31M/S???????????????????Double??￡?Redo log???С?????180M?????
????Logic Read    --????????????λ??飬??С??8K??
????--??????????????1852985*8/1024/1024=14.13G /S
????--??????????DBA????????飬???CPU1?????????1G??????????????????????????????15??CPU?????CPU?????????
????Block Change --?????仯???????????????д????????????????????IO??????????60M??????????
????--???????????ó??????????????????IO????????CPU??????
??????????????????????????

????Hard parses    --?????sql  ???CPU????????10???????Hard Parses??SQL???????30???????sql???3??CPU
????--?????????????CPU????
???????????????
?????????????????????????????????????????????????

????Cache buffer chains    --CBC?????????????п?????CBC???????SQL?????
????row cache lock           --?л???????
????--????????????
????1??sequence???cache??
????2????????????
????3????????????
????4???????á?
????--?????????2????????????????????????????????????