最初由 zhouwf0726 发布
[B]Instance Efficiency Percentages
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %:100.00 Redo NoWait %: 99.99
BufferHit %:100.00In-memory Sort %: 99.87
Library Hit %: 99.97Soft Parse %: 96.00
Execute to Parse %: 99.56 Latch Hit %: 99.42
Parse CPU to Parse Elapsd %: 93.85 % Non-Parse CPU: 97.68
这些指标都还可以,应该是以下sql过渡解析造成。
CPU
CPU per
Elapsd
Old
Time (s) ExecutionsExec (s)%Total Time (s)Buffer GetsHash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
Module: JDBC Thin Client
select * from( selectdistinct a.restaurantid as restaurantid,a
.SQUESEID,e.ADMISSION fromclientinfo_view a ,w_category b ,cli
entinfoforservice ewhere a.restaurantid = e.restaurantid and b
.dishmenuid in(select dishmenuid from w_category start with dish
menuid= (select dishmenuid from w_category where dishmenuname =:
252.41 47 5.371.2 264.03 5,239,702 2093053261
Module: JDBC Thin Client
select F_GET_CLIENT_CITYLETTER(clientId,clientType) letter,clien
tId,clientType from W_CHANGEFORPURGE where F_GET_CLIENT_CITYLETT
ER(clientId,clientType) is not null and PURGEFLAG=0 and clientty
pe=1
220.88
250 0.881.0 239.7827,975,320 1870490799
Module: JDBC Thin Client
BEGIN pkg_restaurantSearch.getSearchClient(:1,:2,:3,:4,:5,:6,:7,
:8,:9,:10); END; [/B]
斑竹同志,我对SQL的优化不是很熟悉,能否给详解一下!
CPU时间是252, 这个SQL执行次数是47,BUFFER GETS 一共是5239702,这样算一次执行应该是11483.然后需要和总的BUFFER比较,到这里就不大清楚了! |