1性能优化基本步骤
11定位跟踪耗费资源较多的SQL语句步骤111通过SQL查询
1查询出最耗费资源的SQL语句selectt1SIDt1SERIALttHASH_VALUEttADDRESSttBUFFER_GETS读内存次数ttDISK_READS磁盘物理读次数ttEXECUTIONS语句的执行次数ttBUFFER_GETSttEXECUTIONS平均读内存次数ttSQL_FULLTEXTfromvsqlareattvsessio
t1wherettBUFFER_GETS100000orttDISK_READS100000a
dttHASH_VALUEt1SQL_HASH_VALUEa
dttADDRESSt1SQL_ADDRESSa
dt1STATUSACTIVEorderbyttBUFFER_GETSdesc
2：根据客户端程序发出的SQL来定位需要跟踪的sessio
selectssidsidsSERIALsuser
amesmachi
esprogramsserversLOGON_TIMEfromvsessio
s