?????????????????????????????

?????????????SQL_TRACE?????????????????????????????????????????????????????????????????Statspack???????????????????飬??????????????????????????????????sql???棬?????????????sql?????SQL_TRACE????????

????oracle Statspack??Oracle8.1.6????????????DBA??Oracle?????????????????????????????????Statspack????????????????Oracle???????????????????????????????????????????????????????????????????????????????Statspack ????DBA????????????

?????????????

????1??????oracle???????????????е??????

????2??????????????(????statspack.snap??????????????????????????????)

????3???????????????檔

????????statspack??oracle10g????????AWR???棬????oracle?????????????????1С??????????????????????????statspack???????????????????????????

????AWR???????10g????oracle DBconsole????ɡ?

?????????statspack??????????????￡????????????????????????????????????????

??????????oracle????????job_queue_process???????????????????????????????????????????0;timed_statistics???????true???????????????洢??V$sessstats??V$sysstats????????????С?

?????????9i???汾??????oradba?????????sqlplus / as sysdba?????????????create tablespace perfstat datafile 'D:**oradataorclperstat.ora'size 100m extent management local;???????????????????????????????????????????????????￡???????????Щ?????Statspack??????????????????????????н??%oracle_home% dbmsadminspcreate.sql?????statspack?????????????????????????????????????lis??????????????????д???

????select dt.table_name from dba_tables dt where dt.owner='PERFSTAT'?????????????洢????

????????????????statspack????????create?????????????????????????perfstat??????statspack.snap?????????????????????Σ????????ο????

????execute statspack.snap;?????н??%oracle_home% dbmsadminspreport.sql??????????????????????檔????????????????????????????????2??????????????

??????????statspack???棬????????????????????????????????????????????棬????????????????????壬????????oracle????????л????????????ж?????????????????????????????Щ?????·????????????

???????????????????????

???????????????????е???????????????????????OLTP??(????????????)??sql??з?????????????????????2?????Library Hit??Buffer Hit???????????????????????????????SQL????????????????????????????????????????????????????sql??????????????????????????У????????Ч????????????????????

??????????????????????????????????????????????????????????????????????????????????DB time: ??????????????????ж???￡?????????????棬???????????????????top5????????Load Profile???????????????????????б????????????溬??????????????????????????￡??????д???????д????????????????Redo size???????????????????????????????????????????????????????????????????k??????????k.????????????????У???????????????????????????????????????

????Instance Efficiency Indicators??????Ч???????????????OLTP???????????????????????????????????????????????????????????о???

????Top 5 Timed Events??????????????????????????????????????????????????????λ????????????????ú????????????????????á???????????????????Щ???ε??????????????