STATSPACK report for
DB Name DB Id Instance Inst Num Release Cluster Host
------------ ----------- ------------ -------- ----------- ------- ------------
ORCL 1151408333 orcl 1 9.2.0.8.0 NO ORACLE_SRV
Snap Id Snap Time Sessions Curs/Sess Comment
--------- ------------------ -------- --------- -------------------
Begin Snap: 1339 06-9月 -07 12:12:05 121 5.2
End Snap: 1345 06-9月 -07 14:12:05 127 4.1
Elapsed: 120.00 (mins)
Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache: 752M Std Block Size: 16K
Shared Pool Size: 200M Log Buffer: 512K
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 1,905.79 758.27
Logical reads: 12,414.29 4,939.37
Block changes: 11.31 4.50
Physical reads: 389.86 155.12
Physical writes: 8.21 3.27
User calls: 117.85 46.89
Parses: 37.98 15.11
Hard parses: 17.33 6.90
Sorts: 9.44 3.76
Logons: 0.09 0.04
Executes: 41.37 16.46
Transactions: 2.51
% Blocks changed per Read: 0.09 Recursive Call %: 28.86
Rollback per transaction %: 0.00 Rows per Sort: 4211.12
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 97.65 Redo NoWait %: 100.00
Buffer Hit %: 96.93 In-memory Sort %: 99.78
Library Hit %: 80.11 Soft Parse %: 54.36
Execute to Parse %: 8.20 Latch Hit %: 99.20
Parse CPU to Parse Elapsd %: 84.19 % Non-Parse CPU: 90.78
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 90.52 91.90
% SQL with executions>1: 22.14 25.68
% Memory for SQL w/exec>1: 22.37 25.61
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
db file sequential read 2,531,671 11,280 58.22
buffer busy waits 2,101,832 6,200 32.00
CPU time 1,548 7.99
db file scattered read 35,334 214 1.11
direct path read (lob) 25,165 61 .32
log file sync 18,289 21 .11
latch free 11,441 18 .09
direct path read 6,266 12 .06
control file sequential read 2,904 8 .04
control file parallel write 2,399 4 .02
-------------------------------------------------------------
Wait Events for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
db file sequential read 2,531,671 0 11,280 4 139.9
buffer busy waits 2,101,832 0 6,200 3 116.1
db file scattered read 35,334 0 214 6 2.0
direct path read (lob) 25,165 0 61 2 1.4
log file sync 18,289 0 21 1 1.0
latch free 11,441 10,212 18 2 0.6
direct path read 6,266 0 12 2 0.3
control file sequential read 2,904 0 8 3 0.2
control file parallel write 2,399 0 4 2 0.1
db file parallel write 2,477 0 4 1 0.1
SQL*Net more data to client 36,621 0 2 0 2.0
log file parallel write 18,135 0 1 0 1.0
direct path write 294 0 0 1 0.0
db file parallel read 34 0 0 9 0.0
library cache pin 116 0 0 1 0.0
enqueue 6 0 0 7 0.0
SQL*Net break/reset to clien 134 0 0 0 0.0
LGWR wait for redo copy 19 0 0 0 0.0
virtual circuit status 499,810 1,109 87,578 175 27.6
jobq slave wait 390 375 1,164 2985 0.0
SQL*Net message from client 612,079 1 611 1 33.8
SQL*Net message to client 612,428 0 1 0 33.8
SQL*Net more data from clien 6 0 0 0 0.0
-------------------------------------------------------------
Background Wait Events for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
control file sequential read 2,640 0 8 3 0.1
control file parallel write 2,398 0 4 2 0.1
db file parallel write 2,477 0 4 1 0.1
db file sequential read 288 0 2 9 0.0
log file parallel write 18,135 0 1 0 1.0
db file scattered read 92 0 1 10 0.0
LGWR wait for redo copy 19 0 0 0 0.0
rdbms ipc reply 9 0 0 0 0.0
rdbms ipc message 32,370 7,333 40,039 1237 1.8
smon timer 148 1 7,309 49383 0.0
pmon timer 2,530 2,377 7,078 2798 0.1
-------------------------------------------------------------
SQL ordered by Gets for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code. As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100
CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
13,157,230 408 32,248.1 14.7 201.27 2113.12 3057365622
Module: w3wp.exe
SELECT * FROM( select pkid,TITLE FROM I_INFORMATION WHERE auditi
ng=1 and isdel=0 and ONEID=1 ORDER BY UPDATETIME DESC) WHERE RO
WNUM<=11
5,789,175 179 32,341.8 6.5 97.02 1269.79 3572315607
Module: w3wp.exe
select * from (select pkid,title from i_information where auditi
ng=1 and isdel=0 and oneid=1 order by updatetime desc ) where ro
wnum<=8
2,268,168 644 3,522.0 2.5 26.88 40.49 1141137336
Module: w3wp.exe
Select Count(1) From (Select CityName,ShopName,Address,Tel From
ShopInfo Where Type=2 And LoginID=0)
1,413,045 27 52,335.0 1.6 19.45 34.92 2909168186
Module: w3wp.exe
SELECT pkid,title,addtime,content FROM (SELECT pkid,title,addtim
e,content FROM i_information WHERE auditing=1 AND ppid>0 AND isd
el=0 AND ppid=505719 ORDER BY hit DESC,AddTime DESC) WHERE ROW
NUM<10
1,360,712 26 52,335.1 1.5 23.45 387.18 3534219027
Module: w3wp.exe
SELECT pkid,title,addtime,content FROM (SELECT pkid,title,addtim
e,content FROM i_information WHERE auditing=1 AND ppid>0 AND isd
el=0 AND ppid=1000760 ORDER BY hit DESC,AddTime DESC) WHERE RO
WNUM<10
1,329,014 289 4,598.7 1.5 13.53 1.22 1432308458
Module: w3wp.exe
SELECT * FROM( select pkid,TITLE FROM I_INFORMATION WHERE auditi
ng=1 and isdel=0 and ONEID=220 ORDER BY UPDATETIME DESC) WHERE
ROWNUM<=11
1,293,436 120 10,778.6 1.4 14.41 187.71 4239559300
Module: w3wp.exe
SELECT * FROM( select pkid,TITLE FROM I_INFORMATION WHERE auditi
ng=1 and isdel=0 and ONEID=35 ORDER BY UPDATETIME DESC) WHERE R
OWNUM<=11
1,029,721 2,697 381.8 1.2 25.72 603.60 1944150314
Module: w3wp.exe
SELECT COUNT(1) FROM C_PRODUCT WHERE (ONEID=:B2 OR TWOID=:B2 OR
THREEID=:B2 ) AND ISAUDIT=1 AND ISDEL=0 AND PRODUCTNAME LIKE '%'
|| :B1 || '%'
934,182 73 12,797.0 1.0 10.27 145.88 2144569900
SQL ordered by Gets for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code. As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100
CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
Module: w3wp.exe
select * from (select pkid,title from i_information where auditi
ng=1 and isdel=0 and oneid=232 order by updatetime desc ) where
rownum<=8
785,026 15 52,335.1 0.9 8.59 -74.47 1149300065
Module: w3wp.exe
SELECT pkid,title,addtime,content FROM (SELECT pkid,title,addtim
e,content FROM i_information WHERE auditing=1 AND ppid>0 AND isd
el=0 AND ppid=500058 ORDER BY hit DESC,AddTime DESC) WHERE ROW
NUM<10
785,025 15 52,335.0 0.9 11.92 78.15 2438519743
Module: w3wp.exe
SELECT pkid,title,addtime,content FROM (SELECT pkid,title,addtim
e,content FROM i_information WHERE auditing=1 AND ppid>0 AND isd
el=0 AND ppid=500034 ORDER BY hit DESC,AddTime DESC) WHERE ROW
NUM<10
624,757 26 24,029.1 0.7 2.44 -514.14 2300535542
Module: w3wp.exe
select * FROM ( SELECT pkid,TITLE FROM I_INFORMATION WHERE audi
ting=1 and isdel=0 and TWOID=402 ORDER BY UPDATETIME DESC)WHERE
ROWNUM<=10
584,577 128 4,567.0 0.7 5.69 21.39 488648922
Module: w3wp.exe
select * from (select pkid,title from i_information where auditi
ng=1 and isdel=0 and oneid=220 order by updatetime desc ) where
rownum<=8
471,016 9 52,335.1 0.5 6.86 80.08 1009228380
Module: w3wp.exe
SELECT pkid,title,addtime,content FROM (SELECT pkid,title,addtim
e,content FROM i_information WHERE auditing=1 AND ppid>0 AND isd
el=0 AND ppid=500054 ORDER BY hit DESC,AddTime DESC) WHERE ROW
NUM<10
314,010 6 52,335.0 0.4 4.78 32.95 1462698615
Module: w3wp.exe
SELECT pkid,title,addtime,content FROM (SELECT pkid,title,addtim
e,content FROM i_information WHERE auditing=1 AND ppid>0 AND isd
el=0 AND ppid=504299 ORDER BY hit DESC,AddTime DESC) WHERE ROW
NUM<10
209,340 4 52,335.0 0.2 3.36 3.54 847496508
Module: w3wp.exe
SELECT pkid,title,addtime,content FROM (SELECT pkid,title,addtim
e,content FROM i_information WHERE auditing=1 AND ppid>0 AND isd
el=0 AND ppid=505487 ORDER BY hit DESC,AddTime DESC) WHERE ROW
SQL ordered by Gets for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code. As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100
CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
NUM<10
165,067 181 912.0 0.2 2.11 68.06 1054880813
Module: w3wp.exe
Select PKID,ProductName From (Select PKID,ProductName From gou.C
_Product Where TwoID=5100 Order By Dits DESC) Where RowNum<=20
147,424 196 752.2 0.2 2.11 38.96 2637155852
Module: w3wp.exe
Select PKID,ProductName From (Select PKID,ProductName From gou.C
_Product Where TwoID=5200 Order By Dits DESC) Where RowNum<=20
104,396 68 1,535.2 0.1 1.45 58.88 844795322
Module: w3wp.exe
Select PKID,ProductName From (Select PKID,ProductName From gou.C
_Product Where TwoID=0 Order By Dits DESC) Where RowNum<=20
78,045 129 605.0 0.1 0.73 35.56 2365532089
Module: w3wp.exe
Select PKID,ProductName From (Select PKID,ProductName From gou.C
_Product Where TwoID=6046 Order By Dits DESC) Where RowNum<=20
75,742 140 541.0 0.1 0.67 17.72 2297142305
Module: w3wp.exe
Select PKID,ProductName From (Select PKID,ProductName From gou.C
_Product Where ThreeID=5221 Order By Dits DESC) Where RowNum<=20
-------------------------------------------------------------
SQL ordered by Reads for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> End Disk Reads Threshold: 1000
CPU Elapsd
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
148,918 408 365.0 5.3 201.27 2113.12 3057365622
Module: w3wp.exe
SELECT * FROM( select pkid,TITLE FROM I_INFORMATION WHERE auditi
ng=1 and isdel=0 and ONEID=1 ORDER BY UPDATETIME DESC) WHERE RO
WNUM<=11
116,125 179 648.7 4.1 97.02 1269.79 3572315607
Module: w3wp.exe
select * from (select pkid,title from i_information where auditi
ng=1 and isdel=0 and oneid=1 order by updatetime desc ) where ro
wnum<=8
105,962 2,697 39.3 3.8 25.72 603.60 1944150314
Module: w3wp.exe
SELECT COUNT(1) FROM C_PRODUCT WHERE (ONEID=:B2 OR TWOID=:B2 OR
THREEID=:B2 ) AND ISAUDIT=1 AND ISDEL=0 AND PRODUCTNAME LIKE '%'
|| :B1 || '%'
37,953 26 1,459.7 1.4 23.45 387.18 3534219027
Module: w3wp.exe
SELECT pkid,title,addtime,content FROM (SELECT pkid,title,addtim
e,content FROM i_information WHERE auditing=1 AND ppid>0 AND isd
el=0 AND ppid=1000760 ORDER BY hit DESC,AddTime DESC) WHERE RO
WNUM<10
27,082 120 225.7 1.0 14.41 187.71 4239559300
Module: w3wp.exe
SELECT * FROM( select pkid,TITLE FROM I_INFORMATION WHERE auditi
ng=1 and isdel=0 and ONEID=35 ORDER BY UPDATETIME DESC) WHERE R
OWNUM<=11
20,440 72 283.9 0.7 1.30 68.77 2965208609
Module: w3wp.exe
Select PKID,ProductName From (Select PKID,ProductName From gou.C
_Product Where TwoID=5402 Order By Dits DESC) Where RowNum<=20
20,320 73 278.4 0.7 10.27 145.88 2144569900
Module: w3wp.exe
select * from (select pkid,title from i_information where auditi
ng=1 and isdel=0 and oneid=232 order by updatetime desc ) where
rownum<=8
12,276 181 67.8 0.4 2.11 68.06 1054880813
Module: w3wp.exe
Select PKID,ProductName From (Select PKID,ProductName From gou.C
_Product Where TwoID=5100 Order By Dits DESC) Where RowNum<=20
10,505 68 154.5 0.4 1.45 58.88 844795322
Module: w3wp.exe
Select PKID,ProductName From (Select PKID,ProductName From gou.C
_Product Where TwoID=0 Order By Dits DESC) Where RowNum<=20
6,966 4 1,741.5 0.2 0.11 4.83 191103266
Module: w3wp.exe
SQL ordered by Reads for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> End Disk Reads Threshold: 1000
CPU Elapsd
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
SELECT * FROM (SELECT PKID,jdname,dits FROM trip.t_sj_zrfgxx WHE
RE isaudit=1 AND isdel=0 ORDER BY dits DESC) t WHERE ROWNUM<=10
6,915 4 1,728.8 0.2 0.11 2.46 3056711125
Module: w3wp.exe
SELECT jdname,PKID,JDTPLJ FROM trip.t_sj_zrfgxx WHERE qyid00=5 A
ND isaudit=1 AND isdel=0 AND ROWNUM<=4 ORDER BY dits DESC
6,103 15 406.9 0.2 11.92 78.15 2438519743
Module: w3wp.exe
SELECT pkid,title,addtime,content FROM (SELECT pkid,title,addtim
e,content FROM i_information WHERE auditing=1 AND ppid>0 AND isd
el=0 AND ppid=500034 ORDER BY hit DESC,AddTime DESC) WHERE ROW
NUM<10
5,759 148 38.9 0.2 0.75 33.12 1944032542
Module: w3wp.exe
Select PKID,ProductName From (Select PKID,ProductName From gou.C
_Product Where TwoID=6030 Order By Dits DESC) Where RowNum<=20
5,719 196 29.2 0.2 2.11 38.96 2637155852
Module: w3wp.exe
Select PKID,ProductName From (Select PKID,ProductName From gou.C
_Product Where TwoID=5200 Order By Dits DESC) Where RowNum<=20
5,711 1 5,711.0 0.2 0.72 5.80 2359307229
Module: w3wp.exe
select ri from (select tt.*,rownum r from (select t.rowid ri fro
m SellInfo t where 1=1 and SFID=11 and TwoID=5648 order by A
gon desc) tt where rownum<=8)ttt where ttt.r>=1
4,870 4 1,217.5 0.2 0.09 2.06 2654138945
Module: w3wp.exe
SELECT jdname,PKID,JDTPLJ FROM trip.t_sj_zrfgxx WHERE qyid00=4 A
ND isaudit=1 AND isdel=0 AND ROWNUM<=4 ORDER BY dits DESC
4,730 129 36.7 0.2 0.73 35.56 2365532089
Module: w3wp.exe
Select PKID,ProductName From (Select PKID,ProductName From gou.C
_Product Where TwoID=6046 Order By Dits DESC) Where RowNum<=20
4,682 2 2,341.0 0.2 1.03 4.64 2045555791
Module: w3wp.exe
select * from (select rownum r, t.* from (SELECT pkid,img,produc
tname FROM c_product WHERE isaudit=1 ORDER BY pkid DESC) t where
rownum<=145180) ss where ss.r >= 145161 and ss.r <=145180
4,490 177 25.4 0.2 0.63 32.44 780666026
Module: w3wp.exe
Select PKID,ProductName From (Select PKID,ProductName From gou.C
_Product Where TwoID=5101 Order By Dits DESC) Where RowNum<=20
4,196 52 80.7 0.1 0.39 18.60 3353671886
Module: w3wp.exe
SQL ordered by Reads for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> End Disk Reads Threshold: 1000
CPU Elapsd
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
Select PKID,ProductName From (Select PKID,ProductName From gou.C
_Product Where TwoID=5427 Order By Dits DESC) Where RowNum<=20
4,089 76 53.8 0.1 0.33 24.63 4228210008
Module: w3wp.exe
Select PKID,ProductName From (Select PKID,ProductName From gou.C
_Product Where ThreeID=5240 Order By Dits DESC) Where RowNum<=20
4,074 100 40.7 0.1 0.39 26.17 339325585
Module: w3wp.exe
Select PKID,ProductName From (Select PKID,ProductName From gou.C
_Product Where TwoID=5300 Order By Dits DESC) Where RowNum<=20
4,057 80 50.7 0.1 0.53 24.88 3363206684
Module: w3wp.exe
Select PKID,ProductName From (Select PKID,ProductName From gou.C
_Product Where TwoID=5412 Order By Dits DESC) Where RowNum<=20
3,947 142 27.8 0.1 0.67 26.50 1212940464
Module: w3wp.exe
Select PKID,ProductName From (Select PKID,ProductName From gou.C
_Product Where TwoID=5102 Order By Dits DESC) Where RowNum<=20
3,692 2 1,846.0 0.1 0.70 4.31 3072417893
Module: w3wp.exe
select Count(1) RecCount from c_product where 1=1 and lower(p
roductname) like '%w908c%' and isdel = 0
3,564 2 1,782.0 0.1 0.59 4.19 1093592865
Module: w3wp.exe
select pkid,productname,comid,writer,addtime from (select * from
(select rownum r, t.* from c_product t where 1=1 and lower(pr
-------------------------------------------------------------
SQL ordered by Executions for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> End Executions Threshold: 100
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
13,220 13,220 1.0 0.00 0.00 1767551517
Module: w3wp.exe
Select pkid From CityInfo Where CityDomain='bj'
8,223 0 0.0 0.00 0.00 1481230938
Module: w3wp.exe
SELECT T.PRICE FROM TRIP.T_SJ_FJJRJG T WHERE T.ROOMID=:B2 AND :B
1 BETWEEN T.STARTTIME AND T.ENDTIME
2,697 2,697 1.0 0.01 0.22 1944150314
Module: w3wp.exe
SELECT COUNT(1) FROM C_PRODUCT WHERE (ONEID=:B2 OR TWOID=:B2 OR
THREEID=:B2 ) AND ISAUDIT=1 AND ISDEL=0 AND PRODUCTNAME LIKE '%'
|| :B1 || '%'
2,630 2,630 1.0 0.00 0.00 3975203045
Module: w3wp.exe
Select pkid From CityInfo Where CityDomain='lnsy'
2,567 2,567 1.0 0.00 0.00 614524047
Module: w3wp.exe
SELECT * FROM TRIP.T_SJ_FJXX T WHERE T.ROOMID = :B1
2,567 2,339 0.9 0.00 0.00 3670372901
Module: w3wp.exe
SELECT T.WEEKEND FROM T_SJ_WEEKINFO T WHERE T.HOTELID=:B1
2,560 0 0.0 0.00 0.00 2413437433
Module: w3wp.exe
select * from (select * from COMMENTINFO where rowid in ('')) tm
p order by pkid desc
1,833 2,933 1.6 0.00 0.00 1433558559
select intcol#,nvl(pos#,0),col# from ccol$ where con#=:1
1,439 6 0.0 0.00 0.00 1038353885
select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= n
ext_date) and (next_date <= :2)) or ((last_date is null) and
(next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5
)) and (this_date is null) order by next_date, job
1,433 1,433 1.0 0.00 0.00 1693927332
select count(*) from sys.job$ where (next_date > sysdate) and (n
ext_date < (sysdate+5/86400))
1,070 1,070 1.0 0.00 0.00 2391920089
Module: w3wp.exe
Select pkid From CityInfo Where CityDomain='xm'
1,001 0 0.0 0.00 0.00 2237228970
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
SQL ordered by Executions for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> End Executions Threshold: 100
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
Date>=sysdate And State='3' And ADItemsID=322 And CityID=0
1,001 1,001 1.0 0.00 0.00 2760557022
Module: w3wp.exe
Select decode(DefaultAdType,'L',DefaultLetter,'P',DefaultPicture
,'F',DefaultFlash) DefaultAdvertisement,DefaultHttp,DefaultAdTyp
e,decode(DefaultAdType,'L',0,'P',PictureWidth,'F',FlashWidth) Wi
dth,decode(DefaultAdType,'L',0,'P',PictureHeight,'F',FlashHeight
) Height From AD_Items Where ID=322
844 0 0.0 0.00 0.00 132045879
Module: w3wp.exe
select PKID,PRODUCTID,PRODUCTNAME,PRICE,LOGINID,IMAGE,DISCOUNT,S
ORTCUR from p_s_contact where rowid in ('') order by SORTCUR
752 0 0.0 0.00 0.00 890482460
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
Date>=sysdate And State='3' And ADItemsID=125 And CityID like '1
1%'
752 0 0.0 0.00 0.00 1286342729
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
Date>=sysdate And State='3' And ADItemsID=127 And CityID like '1
1%'
752 0 0.0 0.00 0.00 1664983044
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
Date>=sysdate And State='3' And ADItemsID=130 And CityID like '1
1%'
752 0 0.0 0.00 0.00 1874711132
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
Date>=sysdate And State='3' And ADItemsID=124 And CityID like '1
1%'
752 0 0.0 0.00 0.00 2139015209
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
Date>=sysdate And State='3' And ADItemsID=123 And CityID like '1
1%'
SQL ordered by Executions for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> End Executions Threshold: 100
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
752 0 0.0 0.00 0.00 2172858532
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
Date>=sysdate And State='3' And ADItemsID=128 And CityID like '1
1%'
752 0 0.0 0.00 0.00 2363074783
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
Date>=sysdate And State='3' And ADItemsID=126 And CityID like '1
-------------------------------------------------------------
SQL ordered by Parse Calls for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> End Parse Calls Threshold: 1000
% Total
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
13,220 13,220 4.83 1767551517
Module: w3wp.exe
Select pkid From CityInfo Where CityDomain='bj'
2,630 2,630 0.96 3975203045
Module: w3wp.exe
Select pkid From CityInfo Where CityDomain='lnsy'
2,560 2,560 0.94 2413437433
Module: w3wp.exe
select * from (select * from COMMENTINFO where rowid in ('')) tm
p order by pkid desc
1,070 1,070 0.39 2391920089
Module: w3wp.exe
Select pkid From CityInfo Where CityDomain='xm'
1,001 1,001 0.37 2237228970
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
Date>=sysdate And State='3' And ADItemsID=322 And CityID=0
1,001 1,001 0.37 2760557022
Module: w3wp.exe
Select decode(DefaultAdType,'L',DefaultLetter,'P',DefaultPicture
,'F',DefaultFlash) DefaultAdvertisement,DefaultHttp,DefaultAdTyp
e,decode(DefaultAdType,'L',0,'P',PictureWidth,'F',FlashWidth) Wi
dth,decode(DefaultAdType,'L',0,'P',PictureHeight,'F',FlashHeight
) Height From AD_Items Where ID=322
844 844 0.31 132045879
Module: w3wp.exe
select PKID,PRODUCTID,PRODUCTNAME,PRICE,LOGINID,IMAGE,DISCOUNT,S
ORTCUR from p_s_contact where rowid in ('') order by SORTCUR
752 752 0.27 890482460
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
Date>=sysdate And State='3' And ADItemsID=125 And CityID like '1
1%'
752 752 0.27 1286342729
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
Date>=sysdate And State='3' And ADItemsID=127 And CityID like '1
1%'
752 752 0.27 1664983044
SQL ordered by Parse Calls for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> End Parse Calls Threshold: 1000
% Total
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
Date>=sysdate And State='3' And ADItemsID=130 And CityID like '1
1%'
752 752 0.27 1874711132
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
Date>=sysdate And State='3' And ADItemsID=124 And CityID like '1
1%'
752 752 0.27 2139015209
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
Date>=sysdate And State='3' And ADItemsID=123 And CityID like '1
1%'
752 752 0.27 2172858532
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
Date>=sysdate And State='3' And ADItemsID=128 And CityID like '1
1%'
752 752 0.27 2363074783
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
Date>=sysdate And State='3' And ADItemsID=126 And CityID like '1
1%'
752 752 0.27 3188285794
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
Date>=sysdate And State='3' And ADItemsID=129 And CityID like '1
1%'
752 752 0.27 3460003666
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
Date>=sysdate And State='3' And ADItemsID=122 And CityID like '1
1%'
SQL ordered by Parse Calls for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> End Parse Calls Threshold: 1000
% Total
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
752 752 0.27 3664529388
Module: w3wp.exe
Select ID,case When ADType='L' Then LetterContent When ADType='P
' Then PictureUrl When ADType='F' Then FlashUrl End advertisemen
t,HttpUrl,ADType From AD_Throws Where BeginDate<=sysdate And End
-------------------------------------------------------------
Instance Activity Stats for DB: ORCL Instance: orcl Snaps: 1339 -1345
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
CPU used by this session 154,846 21.5 8.6
CPU used when call started 154,391 21.4 8.5
CR blocks created 720 0.1 0.0
DBWR buffers scanned 1,330,216 184.8 73.5
DBWR checkpoint buffers written 287 0.0 0.0
DBWR checkpoints 0 0.0 0.0
DBWR free buffers found 1,321,926 183.6 73.1
DBWR lru scans 3,604 0.5 0.2
DBWR make free requests 3,872 0.5 0.2
DBWR summed scan depth 1,330,216 184.8 73.5
DBWR transaction table writes 75 0.0 0.0
DBWR undo block writes 388 0.1 0.0
SQL*Net roundtrips to/from client 1,220,708 169.5 67.5
active txn count during cleanout 97 0.0 0.0
background checkpoints completed 0 0.0 0.0
background checkpoints started 0 0.0 0.0
background timeouts 8,783 1.2 0.5
branch node splits 0 0.0 0.0
buffer is not pinned count 79,972,850 11,107.3 4,419.4
buffer is pinned count 1,055,303,512 146,569.9 58,317.0
bytes received via SQL*Net from c 110,073,126 15,287.9 6,082.7
bytes sent via SQL*Net to client 278,361,817 38,661.4 15,382.5
calls to get snapshot scn: kcmgss 525,336 73.0 29.0
calls to kcmgas 19,084 2.7 1.1
calls to kcmgcs 60 0.0 0.0
change write time 43 0.0 0.0
cleanout - number of ktugct calls 133 0.0 0.0
cleanouts and rollbacks - consist 1 0.0 0.0
cleanouts only - consistent read 1 0.0 0.0
cluster key scan block gets 6,874 1.0 0.4
cluster key scans 4,403 0.6 0.2
commit cleanout failures: block l 0 0.0 0.0
commit cleanout failures: buffer 0 0.0 0.0
commit cleanout failures: callbac 0 0.0 0.0
commit cleanout failures: cannot 3 0.0 0.0
commit cleanouts 20,510 2.9 1.1
commit cleanouts successfully com 20,507 2.9 1.1
commit txn count during cleanout 91 0.0 0.0
consistent changes 753 0.1 0.0
consistent gets 89,343,512 12,408.8 4,937.2
consistent gets - examination 353,882 49.2 19.6
current blocks converted for CR 5 0.0 0.0
cursor authentications 19,215 2.7 1.1
data blocks consistent reads - un 753 0.1 0.0
db block changes 81,402 11.3 4.5
db block gets 64,532 9.0 3.6
deferred (CURRENT) block cleanout 11,201 1.6 0.6
dirty buffers inspected 3,397 0.5 0.2
enqueue conversions 160 0.0 0.0
enqueue releases 170,801 23.7 9.4
enqueue requests 170,801 23.7 9.4
enqueue timeouts 0 0.0 0.0
enqueue waits 6 0.0 0.0
exchange deadlocks 0 0.0 0.0
execute count 297,891 41.4 16.5
failed probes on index block recl 0 0.0 0.0
Instance Activity Stats for DB: ORCL Instance: orcl Snaps: 1339 -1345
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
free buffer inspected 3,830 0.5 0.2
free buffer requested 2,748,361 381.7 151.9
hot buffers moved to head of LRU 7,286,881 1,012.1 402.7
immediate (CR) block cleanout app 2 0.0 0.0
immediate (CURRENT) block cleanou 868 0.1 0.1
index crx upgrade (found) 37 0.0 0.0
index crx upgrade (positioned) 62,620 8.7 3.5
index fast full scans (full) 0 0.0 0.0
index fetch by key 95,713 13.3 5.3
index scans kdiixs1 32,154,079 4,465.8 1,776.9
leaf node 90-10 splits 5 0.0 0.0
leaf node splits 58 0.0 0.0
logons cumulative 659 0.1 0.0
messages received 24,128 3.4 1.3
messages sent 24,128 3.4 1.3
no buffer to keep pinned count 0 0.0 0.0
no work - consistent read gets 88,822,423 12,336.5 4,908.4
opened cursors cumulative 274,377 38.1 15.2
parse count (failures) 12 0.0 0.0
parse count (hard) 124,811 17.3 6.9
parse count (total) 273,477 38.0 15.1
parse time cpu 14,274 2.0 0.8
parse time elapsed 16,955 2.4 0.9
physical reads 2,807,013 389.9 155.1
physical reads direct 34,791 4.8 1.9
physical reads direct (lob) 25,185 3.5 1.4
physical writes 59,126 8.2 3.3
physical writes direct 47,296 6.6 2.6
physical writes direct (lob) 0 0.0 0.0
physical writes non checkpoint 59,064 8.2 3.3
pinned buffers inspected 381 0.1 0.0
prefetched blocks 180,212 25.0 10.0
prefetched blocks aged out before 17 0.0 0.0
process last non-idle time 7,200 1.0 0.4
recovery blocks read 0 0.0 0.0
recursive aborts on index block r 0 0.0 0.0
recursive calls 344,223 47.8 19.0
recursive cpu usage 9,552 1.3 0.5
redo blocks written 38,140 5.3 2.1
redo buffer allocation retries 0 0.0 0.0
redo entries 43,712 6.1 2.4
redo log space requests 0 0.0 0.0
redo log space wait time 0 0.0 0.0
redo ordering marks 0 0.0 0.0
redo size 13,721,704 1,905.8 758.3
redo synch time 2,031 0.3 0.1
redo synch writes 18,118 2.5 1.0
redo wastage 5,263,336 731.0 290.9
redo write time 1,853 0.3 0.1
redo writer latching time 0 0.0 0.0
redo writes 18,135 2.5 1.0
rollback changes - undo records a 0 0.0 0.0
rollbacks only - consistent read 720 0.1 0.0
rows fetched via callback 163,541 22.7 9.0
session connect time 101 0.0 0.0
session logical reads 89,382,859 12,414.3 4,939.4
Instance Activity Stats for DB: ORCL Instance: orcl Snaps: 1339 -1345
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
session pga memory max 70,398,988 9,777.6 3,890.3
session uga memory 25,777,400,240 3,580,194.5 1,424,480.6
session uga memory max 160,772,196 22,329.5 8,884.4
shared hash latch upgrades - no w 95,822 13.3 5.3
shared hash latch upgrades - wait 44 0.0 0.0
sorts (disk) 147 0.0 0.0
sorts (memory) 67,838 9.4 3.8
sorts (rows) 286,293,181 39,762.9 15,820.8
summed dirty queue length 11,543 1.6 0.6
switch current to new buffer 21 0.0 0.0
table fetch by rowid 557,173,469 77,385.2 30,789.9
table fetch continued row 10,852,562 1,507.3 599.7
table scan blocks gotten 1,335,122 185.4 73.8
table scan rows gotten 40,436,929 5,616.2 2,234.6
table scans (long tables) 855 0.1 0.1
table scans (short tables) 29,293 4.1 1.6
transaction rollbacks 0 0.0 0.0
user calls 848,515 117.9 46.9
user commits 18,096 2.5 1.0
user rollbacks 0 0.0 0.0
workarea executions - multipass 0 0.0 0.0
workarea executions - onepass 294 0.0 0.0
workarea executions - optimal 63,745 8.9 3.5
write clones created in foregroun 0 0.0 0.0
-------------------------------------------------------------
Tablespace IO Stats for DB: ORCL Instance: orcl Snaps: 1339 -1345
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
GOU
2,160,630 300 4.4 1.0 8,083 1 2,047,328 2.9
GOU_IDX
262,367 36 5.2 1.0 1,160 0 34,252 5.5
TRIP
161,083 22 4.1 1.8 1,103 0 16,001 4.8
TEMP
24,880 3 1.3 1.4 16,309 2 0 0.0
SYSTEM
3,663 1 9.9 1.2 82 0 36 24.2
PERFSTAT
2,740 0 6.2 1.0 889 0 0 0.0
TOGO
1,435 0 6.0 1.4 45 0 0 0.0
UNDOTBS1
147 0 2.7 1.0 465 0 2 0.0
TABSPACE_HELP
348 0 7.2 1.3 0 0 0 0.0
DRSYS
45 0 6.7 1.0 1 0 0 0.0
TABLESPACE_HELP
24 0 10.8 2.0 0 0 0 0.0
SO
18 0 7.8 1.0 0 0 0 0.0
-------------------------------------------------------------
File IO Stats for DB: ORCL Instance: orcl Snaps: 1339 -1345
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
DRSYS D:\ORACLE\ORADATA\ORCL\DRSYS01.DBF
45 0 6.7 1.0 1 0 0
GOU D:\ORACLE\ORADATA\ORCL\GOU.ORA
2,160,630 300 4.4 1.0 8,083 1 2,047,328 2.9
GOU_IDX D:\ORACLE\ORADATA\ORCL\GOU_IDX.ORA
262,367 36 5.2 1.0 1,160 0 34,252 5.5
PERFSTAT D:\ORACLE\ORADATA\ORCL\PERFSTAT.ORA
2,740 0 6.2 1.0 889 0 0
SO D:\ORACLE\ORADATA\ORCL\SO.ORA
18 0 7.8 1.0 0 0 0
SYSTEM D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
3,663 1 9.9 1.2 82 0 36 24.2
TABLESPACE_HELP D:\ORACLE\ORADATA\ORCL\TABLESPACE_HELP.ORA
24 0 10.8 2.0 0 0 0
TABSPACE_HELP D:\ORACLE\ORADATA\ORCL\TABSPACE_HELP.ORA
348 0 7.2 1.3 0 0 0
TEMP D:\ORACLE\ORADATA\ORCL\TEMP01.DBF
24,880 3 1.3 1.4 16,309 2 0
TOGO D:\ORACLE\ORADATA\ORCL\TOGO.ORA
1,435 0 6.0 1.4 45 0 0
TRIP D:\ORACLE\ORADATA\ORCL\TRIP.ORA
161,083 22 4.1 1.8 1,103 0 16,001 4.8
UNDOTBS1 D:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
147 0 2.7 1.0 465 0 2 0.0
-------------------------------------------------------------
Buffer Pool Statistics for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> Standard block size Pools D: default, K: keep, R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
Free Write Buffer
Number of Cache Buffer Physical Physical Buffer Complete Busy
P Buffers Hit % Gets Reads Writes Waits Waits Waits
--- ---------- ----- ----------- ----------- ---------- ------- -------- ------
D 47,564 96.9 89,346,181 2,747,344 11,830 0 0########
-------------------------------------------------------------
Instance Recovery Stats for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> B: Begin snapshot, E: End snapshot
Targt Estd Log File Log Ckpt Log Ckpt
MTTR MTTR Recovery Actual Target Size Timeout Interval
(s) (s) Estd IOs Redo Blks Redo Blks Redo Blks Redo Blks Redo Blks
- ----- ----- ---------- ---------- ---------- ---------- ---------- ----------
B 166 13 363 7187 6800 184320 6800
E 166 14 441 10136 10225 184320 10225
-------------------------------------------------------------
Buffer Pool Advisory for DB: ORCL Instance: orcl End Snap: 1345
-> Only rows with estimated physical reads >0 are displayed
-> ordered by Block Size, Buffers For Estimate (default block size first)
Size for Size Buffers for Est Physical Estimated
P Estimate (M) Factr Estimate Read Factor Physical Reads
--- ------------ ----- ---------------- ------------- ------------------
D 72 .1 4,554 27.93 6,330,716,517
D 144 .2 9,108 25.62 5,807,001,241
D 216 .3 13,662 23.96 5,431,426,396
D 288 .4 18,216 22.35 5,065,092,620
D 360 .5 22,770 18.88 4,277,904,326
D 432 .6 27,324 13.71 3,106,628,507
D 504 .7 31,878 10.17 2,304,687,109
D 576 .8 36,432 6.64 1,505,057,732
D 648 .9 40,986 3.00 678,979,710
D 720 1.0 45,540 1.34 302,770,717
D 752 1.0 47,564 1.00 226,640,540
D 792 1.1 50,094 0.74 166,605,828
D 864 1.1 54,648 0.46 103,182,824
D 936 1.2 59,202 0.29 65,622,216
D 1,008 1.3 63,756 0.20 44,217,666
D 1,080 1.4 68,310 0.13 29,823,383
D 1,152 1.5 72,864 0.09 19,600,857
D 1,224 1.6 77,418 0.06 12,625,124
D 1,296 1.7 81,972 0.03 7,849,326
D 1,368 1.8 86,526 0.02 4,924,313
D 1,440 1.9 91,080 0.01 3,252,651
-------------------------------------------------------------
Buffer wait Statistics for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> ordered by wait time desc, waits desc
Tot Wait Avg
Class Waits Time (s) Time (ms)
------------------ ----------- ---------- ---------
data block 2,098,446 6,183 3
segment header 13 0 8
undo header 2 0 0
-------------------------------------------------------------
PGA Aggr Target Stats for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> B: Begin snap E: End snap (rows dentified with B or E contain data
which is absolute i.e. not diffed over the interval)
-> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
-> Auto PGA Target - actual workarea memory target
-> W/A PGA Used - amount of memory used for all Workareas (manual + auto)
-> %PGA W/A Mem - percentage of PGA memory allocated to workareas
-> %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
-> %Man W/A Mem - percentage of workarea memory under manual control
PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
--------------- ---------------- -------------------------
60.8 1,835 1,184
%PGA %Auto %Man
PGA Aggr Auto PGA PGA Mem W/A PGA W/A W/A W/A Global Mem
Target(M) Target(M) Alloc(M) Used(M) Mem Mem Mem Bound(K)
- --------- --------- ---------- ---------- ------ ------ ------ ----------
B 200 164 31.5 0.0 .0 .0 .0 10,240
E 200 165 28.9 0.0 .0 .0 .0 10,240
-------------------------------------------------------------
PGA Aggr Target Histogram for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> Optimal Executions are purely in-memory operations
Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- ------------- ------------ ------------
2K 4K 44,170 44,170 0 0
4K 8K 11,277 11,277 0 0
8K 16K 4,257 4,257 0 0
16K 32K 2,035 2,035 0 0
32K 64K 862 862 0 0
64K 128K 358 358 0 0
128K 256K 216 216 0 0
256K 512K 381 381 0 0
512K 1024K 121 119 2 0
1M 2M 151 17 134 0
2M 4M 48 0 48 0
4M 8M 86 6 80 0
8M 16M 30 0 30 0
-------------------------------------------------------------
PGA Memory Advisory for DB: ORCL Instance: orcl End Snap: 1345
-> When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value
where Estd PGA Overalloc Count is 0
Estd Extra Estd PGA Estd PGA
PGA Target Size W/A MB W/A MB Read/ Cache Overalloc
Est (MB) Factr Processed Written to Disk Hit % Count
---------- ------- ---------------- ---------------- -------- ----------
25 0.1 267.4 7.0 97.0 2
50 0.3 267.4 5.2 98.0 0
100 0.5 267.4 5.2 98.0 0
150 0.8 267.4 0.0 100.0 0
200 1.0 267.4 0.0 100.0 0
240 1.2 267.4 0.0 100.0 0
280 1.4 267.4 0.0 100.0 0
320 1.6 267.4 0.0 100.0 0
360 1.8 267.4 0.0 100.0 0
400 2.0 267.4 0.0 100.0 0
600 3.0 267.4 0.0 100.0 0
800 4.0 267.4 0.0 100.0 0
1,200 6.0 267.4 0.0 100.0 0
1,600 8.0 267.4 0.0 100.0 0
-------------------------------------------------------------
Enqueue activity for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> Enqueue stats gathered prior to 9i should not be compared with 9i data
-> ordered by Wait Time desc, Waits desc
Avg Wt Wait
Eq Requests Succ Gets Failed Gets Waits Time (ms) Time (s)
-- ------------ ------------ ----------- ----------- ------------- ------------
TX 18,343 18,346 0 5 9.40 0
SQ 38 38 0 1 16.00 0
-------------------------------------------------------------
Rollback Segment Stats for DB: ORCL Instance: orcl Snaps: 1339 -1345
->A high value for "Pct Waits" suggests more rollback segments may be required
->RBS stats may not be accurate between begin and end snaps when using Auto Undo
managment, as RBS may be dynamically created and dropped as needed
Trans Table Pct Undo Bytes
RBS No Gets Waits Written Wraps Shrinks Extends
------ -------------- ------- --------------- -------- -------- --------
0 39.0 0.00 0 0 0 0
1 3,559.0 0.00 461,584 0 1 0
2 3,726.0 0.00 427,634 1 1 0
3 3,834.0 0.00 273,480 1 1 0
4 3,926.0 0.00 537,162 1 1 0
5 3,607.0 0.00 458,262 1 1 0
6 3,512.0 0.00 241,264 0 1 0
7 3,760.0 0.00 561,170 0 1 0
8 3,869.0 0.00 509,792 3 0 0
9 3,901.0 0.00 275,554 0 1 0
10 3,569.0 0.00 255,940 3 0 0
-------------------------------------------------------------
Rollback Segment Storage for DB: ORCL Instance: orcl Snaps: 1339 -1345
->Optimal Size should be larger than Avg Active
RBS No Segment Size Avg Active Optimal Size Maximum Size
------ --------------- --------------- --------------- ---------------
0 442,368 0 442,368
1 2,211,840 1,149,142 45,203,456
2 2,211,840 1,244,721 43,106,304
3 2,211,840 1,482,565 8,503,296
4 2,211,840 1,448,086 41,009,152
5 2,211,840 593,924 13,746,176
6 2,211,840 552,339 18,989,056
7 2,211,840 51,024,732 100,777,984
8 2,211,840 1,749,141 75,612,160
9 2,211,840 530,832 39,960,576
10 2,211,840 3,255,901 21,086,208
-------------------------------------------------------------
Undo Segment Summary for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> Undo segment block stats:
-> uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
-> eS - expired Stolen, eR - expired Released, eU - expired reUsed
Undo Undo Num Max Qry Max Tx Snapshot Out of uS/uR/uU/
TS# Blocks Trans Len (s) Concurcy Too Old Space eS/eR/eU
---- -------------- ---------- -------- ---------- -------- ------ -------------
1 305 ########## 104 1 0 0 0/0/0/0/0/0
-------------------------------------------------------------
Undo Segment Stats for DB: ORCL Instance: orcl Snaps: 1339 -1345
-> ordered by Time desc
Undo Num Max Qry Max Tx Snap Out of uS/uR/uU/
End Time Blocks Trans Len (s) Concy Too Old Space eS/eR/eU
------------ ------------ -------- ------- -------- ------- ------ -------------
06-9月 14:1 18 ######## 8 1 0 0 0/0/0/0/0/0
1
06-9月 14:0 30 ######## 75 1 0 0 0/0/0/0/0/0
1
06-9月 13:5 12 ######## 33 1 0 0 0/0/0/0/0/0
1
06-9月 13:4 37 ######## 72 1 0 0 0/0/0/0/0/0
1
06-9月 13:3 12 ######## 60 1 0 0 0/0/0/0/0/0
1
06-9月 13:2 35 ######## 8 1 0 0 0/0/0/0/0/0
1
06-9月 13:1 9 ######## 59 1 0 0 0/0/0/0/0/0
1
06-9月 13:0 46 ######## 50 1 0 0 0/0/0/0/0/0
1
06-9月 12:5 11 ######## 71 1 0 0 0/0/0/0/0/0
1
06-9月 12:4 44 ######## 83 1 0 0 0/0/0/0/0/0
1
06-9月 12:3 14 ######## 49 1 0 0 0/0/0/0/0/0
1
06-9月 12:2 37 ######## 104 1 0 0 0/0/0/0/0/0
1
-------------------------------------------------------------
Latch Activity for DB: ORCL Instance: orcl Snaps: 1339 -1345
->"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for
willing-to-wait latch get requests
->"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
->"Pct Misses" for both should be very close to 0.0
Pct Avg Wait Pct
Get Get Slps Time NoWait NoWait
Latch Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
Consistent RBA 18,134 0.0 0 0
FAL request queue 144 0.0 0 0
FOB s.o list latch 2,455 0.1 0.0 0 0
SQL memory manager latch 6 0.0 0 2,398 0.0
SQL memory manager worka 167,878 0.0 0 0
active checkpoint queue 8,437 0.0 0 0
archive control 246 0.0 0 0
archive process latch 192 0.0 0 0
cache buffer handles 2,430 0.0 0 0
cache buffers chains 183,498,995 1.0 0.0 20 3,006,333 0.0
cache buffers lru chain 29,810 0.1 0.1 0 3,107,036 0.1
channel handle pool latc 1,065 0.0 0 0
channel operations paren 7,028 0.0 0 0
checkpoint queue latch 640,385 0.0 0 11,815 0.1
child cursor hash table 878,491 0.2 0.0 0
分享到：
发表评论
相关推荐
CrimeStat是一款专业的地理空间分析软件，专为社会科学家和犯罪分析师设计，用于探索和解释空间模式，特别是与犯罪相关的数据。这款工具集成了统计学、地理信息系统（GIS）和计算机科学，提供了一种强大而直观的方式...
CrimeStat是一款专为犯罪数据分析和空间统计设计的强大工具。它结合了地理信息系统（GIS）的功能，使得研究人员和执法机构能够深入理解犯罪模式、热点区域以及潜在的风险因素。这个名为"CrimeStat_GIS_Data_Files....
CrimeStat是一款专为犯罪数据分析设计的地统计软件，它在社会科学，特别是犯罪学研究领域中有着广泛的应用。这个软件的核心功能集中在最邻近指数（Nearest Neighbor Index, NNI）、层次集聚分析以及Ripley's K函数这...
stat()—获取文件状态 stat() 函数是 Unix 系统中一个常用的函数，用于获取文件状态。该函数的头文件是 `<sys/stat.h>` 和 `<unistd.h>`。函数的定义是 `int stat(const char *file_name, struct stat *buf)`。 ...
Grafana是一款强大的开源数据可视化工具，而Stat Panel是它的一个原生插件，尤其在Grafana 6.7版本中尽管仍处于beta阶段，但已经提供了丰富的功能。Stat Panel设计的主要目的是为了显示单一指标的统计信息，与...
标题中的“万能数据转换工具stat/transfer12”指的是Stat/Transfer软件的第12版，这是一款功能强大的数据转换工具，适用于多种数据分析软件之间的数据格式互换。Stat/Transfer能够有效地帮助用户在Excel、SPSS、SAS...
在深入探讨Linux下的`stat`函数之前，我们首先简要回顾一下`stat`函数的基本概念与功能。`stat`函数是Linux系统中的一个重要系统调用，用于获取文件或目录的状态信息。通过`stat`函数，应用程序可以查询到目标文件的...
stat.xslnginx-rtmp-module-stat.xsl conf/nginx.conf 为配置文件实例 RTMP监听 1935 端口，启用live 和hls 两个application HTTP监听 8080 端口， * :8080/stat 查看stream状态 * :8080/index.html 为一个...
STAT 330. 1.1 Example The following table gives the number of fumbles in a game made by 110 Division A football teams during one weekend: No. of Fumbles: x 0 1 2 3 4 5 6 7 ≥ 8 Total Obs. Frequency: ...
分享下svn状态统计工具SvnStat 是开源的 在源码的基础上我做了些改动 现在已经是重新打好的jar包了 使用方法很简单 无需checkout配置库到本地 方法如下： 1 打开cmd 获取配置库指定日期内的log: svn log ...
STAT家族的成员包括STAT1、STAT2、STAT3、STAT4、STAT5a、STAT5b、STAT6等，广泛表达于各种细胞和组织中，并在细胞生长、凋亡、分化等生理过程中起到调节作用。 STAT家族的作用不仅仅局限于传统的淋巴系统和造血...
`redis-stat` 是一款实用的工具，它可以帮助我们实时查看 Redis 服务器的性能指标，如命令执行频率、内存使用情况、网络流量等。这个"redis-stat 集成包"包含了所有必要的组件，使得安装和使用过程变得更加便捷，...
标题 "redis-stat 离线安装" 涉及到的是在没有网络或者网络环境受限的情况下，如何安装和使用 `redis-stat` 这一工具。`redis-stat` 是一个用于监控 Redis 数据库性能的工具，它能提供实时的统计信息，帮助管理员...
AMD CPU超频工具K10stat是一款专为AMD处理器设计的高级系统监控和超频软件。这款工具由AMD爱好者和专业玩家开发，主要用于AMD的K10架构CPU，包括Phenom II、Athlon II以及后来的FX、A系列等处理器。通过K10stat，...
《移动端APU超频：K10Stat深度解析》 在移动计算领域，APU（Accelerated Processing Unit）是AMD公司推出的一种集成了CPU和GPU的处理器，旨在提供高效的计算性能和图形处理能力。APU超频作为一种提升性能的技术，受...
STAT蛋白家族成员包括STAT1、STAT2、STAT3、STAT4、STAT5a、STAT5b和STAT6，均含有六个结构和功能上均保守的蛋白质结构域：ND（N-terminal domain）、CC（coiled-coil domain）、DBD（DNA binding domain）、LD...
APU超频软件k10stat是一款专为AMD APU设计的高级超频工具，它允许用户通过手动调整APU的频率、电压等参数来提升处理器的性能，从而获得大约30%的性能提升。超频是计算机硬件爱好者常用的技术手段，通过挖掘硬件潜力...
SEER*Stat变量文档是理解这些数据的关键，因为它提供了每个可用字段的详细描述，这些字段通常包括患者的个人特征、诊断信息、治疗细节以及随访状态等。 以下是一些重要的SEER*Stat变量的说明： 1. **PATIENT ID**...
根据proc目录下的stat计算cpu的使用和内存使用情况