求助：最近Oracle时常CPU100%占用率，造成客户无法连接，高手帮忙分析一下这个Stacksp
服务器配置2CPU，4G内存，接的光纤存储柜，以前比较稳定，但是最近Oracle时常CPU100%占用率，造成客户无法连接,抱怨很大，时间可能持续20分钟左右。在负载100%的时候，抓了快照，生成了spreport,高手帮忙分析一下，可能会是哪里出问题了呢，谢谢:
STATSPACK report for
DB Name DB Id Instance Inst Num Release RAC Host
------------ ----------- ------------ -------- ----------- --- ----------------
ccmes 1600126904 ccmes 1 10.1.0.2.0 NO mes01
Snap Id Snap Time Sessions Curs/Sess Comment
--------- ------------------ -------- --------- -------------------
Begin Snap: 13 05-12月-05 11:09:00 105 29.7
End Snap: 14 05-12月-05 11:09:18 106 29.4
Elapsed: 0.30 (mins)
Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache: 488M Std Block Size: 8K
Shared Pool Size: 240M Log Buffer: 2,048K
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 141,715.56 94,477.04
Logical reads: 44,931.28 29,954.19
Block changes: 741.61 494.41
Physical reads: 1,671.83 1,114.56
Physical writes: 9.78 6.52
User calls: 119.06 79.37
Parses: 56.61 37.74
Hard parses: 10.94 7.30
Sorts: 32.61 21.74
Logons: 0.28 0.19
Executes: 252.00 168.00
Transactions: 1.50
% Blocks changed per Read: 1.65 Recursive Call %: 69.06
Rollback per transaction %: 0.00 Rows per Sort: 56.53
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 99.55 Redo NoWait %: 99.82
Buffer Hit %: 96.28 In-memory Sort %: 100.00
Library Hit %: 93.25 Soft Parse %: 80.67
Execute to Parse %: 77.54 Latch Hit %: 99.58
Parse CPU to Parse Elapsd %: % Non-Parse CPU:
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 79.95 80.74
% SQL with executions>1: 65.04 64.96
% Memory for SQL w/exec>1: 58.17 58.14
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Call Time
-------------------------------------------- ------------ ----------- ---------
read by other session 3,794 15 28.84
Queue Monitor Task Wait 2 10 19.60
db file scattered read 2,068 8 15.20
enq: TX - row lock contention 3 6 11.51
latch: cache buffers chains 94 6 11.22
-------------------------------------------------------------
Wait Events DB/Inst: ccmes/ccmes Snaps: 13-14
-> 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
---------------------------- ------------ ---------- ---------- ------ --------
read by other session 3,794 0 15 4 140.5
Queue Monitor Task Wait 2 2 10 5118 0.1
db file scattered read 2,068 0 8 4 76.6
enq: TX - row lock contentio 3 0 6 2003 0.1
latch: cache buffers chains 94 88 6 62 3.5
class slave wait 1 1 5 5119 0.0
log file switch completion 8 0 1 74 0.3
log file sequential read 14 0 1 37 0.5
control file sequential read 504 0 0 1 18.7
log file parallel write 32 0 0 2 1.2
latch: library cache 667 0 0 0 24.7
db file sequential read 36 0 0 2 1.3
log file sync 27 0 0 2 1.0
control file parallel write 22 0 0 2 0.8
db file parallel write 7 0 0 6 0.3
direct path read 5 0 0 7 0.2
process startup 1 0 0 19 0.0
latch: shared pool 111 0 0 0 4.1
control file single write 4 0 0 2 0.1
log file single write 2 0 0 2 0.1
enq: CF - contention 1 0 0 1 0.0
direct path write 5 0 0 0 0.2
SQL*Net more data to client 20 0 0 0 0.7
latch free 2 0 0 0 0.1
buffer busy waits 1 0 0 0 0.0
ksfd: async disk IO 5 0 0 0 0.2
SQL*Net message from client 1,328 0 742 559 49.2
SQL*Net message to client 1,334 0 0 0 49.4
-------------------------------------------------------------
Background Wait Events DB/Inst: ccmes/ccmes Snaps: 13-14
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
Queue Monitor Task Wait 2 2 10 5118 0.1
class slave wait 1 1 5 5119 0.0
log file sequential read 14 0 1 37 0.5
control file sequential read 58 0 0 4 2.1
log file parallel write 29 0 0 2 1.1
control file parallel write 22 0 0 2 0.8
db file parallel write 7 0 0 6 0.3
direct path read 5 0 0 7 0.2
process startup 1 0 0 19 0.0
control file single write 4 0 0 2 0.1
log file single write 2 0 0 2 0.1
enq: CF - contention 1 0 0 1 0.0
direct path write 5 0 0 0 0.2
ksfd: async disk IO 5 0 0 0 0.2
rdbms ipc message 85 47 178 2089 3.1
-------------------------------------------------------------
SQL ordered by Gets DB/Inst: ccmes/ccmes Snaps: 13-14
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> End Buffer Gets Threshold: 10000 Total Buffer Gets: 808,763
-> Captured SQL accounts for 76.2% of Total Buffer Gets
-> SQL reported below exceeded 1.0% of Total Buffer Gets
CPU Elapsd Old
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
337,255 185 1,823.0 41.7 0.00 14.39 513280995
Module: plantMonitor.exe
BEGIN :1 := mesuser.GET_LOGUSER(:2,:3); END;
333,609 183 1,823.0 41.2 0.02 13.96 1094942948
Module: plantMonitor.exe
SELECT DISTINCT YGMC FROM SJDLJLB WHERE ZDDM=:B1 AND SUBSTR(GZSJ
,0,10)=TO_CHAR(SYSDATE,'YYYY-MM-DD')
114,996 3 38,332.0 14.2 0.01 55.12 1182286929
Module: ？????？？.exe
SELECT ABOM_OP,ABOM_COMP,ABOM_QTY FROM QAD_BOM WHERE ABOM_PS_COD
E='X' AND UPPER(ABOM_JHDM)=UPPER(:B1 ) AND ABOM_OP<>0 AND TO_CHA
R(ABOM_OP) IN ( SELECT GXDM FROM ATPUGWGXB WHERE GZZXDM IN( SELE
CT GZZXDM FROM ATPUZDGWB WHERE ZDDM=:B4 ) AND GZDD=:B3 AND JGDLX
=:B2 )
102,057 5 20,411.4 12.6 0.00 928.52 268677010
Module: ？????？？.exe
BEGIN mesuser.PL_QUERY_BOMZJTS(:1,:2,:3,:4,:5); END;
84,757 32 2,648.7 10.5 0.06 1.79 353651785
Module: plantMonitor.exe
BEGIN :1 := mesuser.GET_WOSUM(:2); END;
79,345 1 79,345.0 9.8 0.00 1.23 808025322
Module: plantMonitor.exe
SELECT COUNT(*) FROM SJCBB WHERE GHTM NOT IN(SELECT GHTM FROM SJ
WCB WHERE ZDMC='CCECMESZP010')
23,202 1 23,202.0 2.9 0.00 5.47 325111338
Module: plantMonitor.exe
BEGIN mesuser.PV_CREATE_PVPRODUCT; END;
9,087 1 9,087.0 1.1 0.00 188.60 2522684317
Module: SQL*Plus
BEGIN statspack.snap; END;
8,655 4 2,163.8 1.1 0.01 0.22 3295972034
Module: ？????？？.exe
SELECT A.WOD_OP,A.WOD_PART,A.WOD_DESC,A.WOD_BOM_QTY,A.WOD_WKCTR
FROM RST_QAD_WODPART A WHERE UPPER(WOD_NBR)=UPPER(:B1 ) AND A.WO
D_BOM_QTY<>0 AND WOD_WKCTR IN (SELECT GZZXDM FROM ATPUZDGWB WHER
E ZDDM=:B2 ) AND (WOD_WKCTR,WOD_PART) NOT IN(SELECT GWMC,LJDM FR
OM RSTWLZDB WHERE JHSO=:B3 AND JHDM=:B1 )
-------------------------------------------------------------
SQL ordered by Reads DB/Inst: ccmes/ccmes Snaps: 13-14
-> End Disk Reads Threshold: 1000 Total Disk Reads: 30,093
-> Captured SQL accounts for 95.7% of Total Disk Reads
-> SQL reported below exceeded 1.0% of Total Disk Reads
CPU Elapsd Old
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
28,793 3 9,597.7 95.7 0.01 55.12 1182286929
Module: ？????？？.exe
SELECT ABOM_OP,ABOM_COMP,ABOM_QTY FROM QAD_BOM WHERE ABOM_PS_COD
E='X' AND UPPER(ABOM_JHDM)=UPPER(:B1 ) AND ABOM_OP<>0 AND TO_CHA
R(ABOM_OP) IN ( SELECT GXDM FROM ATPUGWGXB WHERE GZZXDM IN( SELE
CT GZZXDM FROM ATPUZDGWB WHERE ZDDM=:B4 ) AND GZDD=:B3 AND JGDLX
=:B2 )
16,298 5 3,259.6 54.2 0.00 928.52 268677010
Module: ？????？？.exe
BEGIN mesuser.PL_QUERY_BOMZJTS(:1,:2,:3,:4,:5); END;
-------------------------------------------------------------
SQL ordered by Executions DB/Inst: ccmes/ccmes Snaps: 13-14
-> End Executions Threshold: 100 Total Executions: 4,536
-> Captured SQL accounts for 53.9% of Total Executions
-> SQL reported below exceeded 1.0% of Total Executions
CPU per Elap per Old
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
225 0 0.0 0.00 0.00 1053795750
COMMIT
185 185 1.0 0.00 0.08 513280995
Module: plantMonitor.exe
BEGIN :1 := mesuser.GET_LOGUSER(:2,:3); END;
183 142 0.8 0.00 0.08 1094942948
Module: plantMonitor.exe
SELECT DISTINCT YGMC FROM SJDLJLB WHERE ZDDM=:B1 AND SUBSTR(GZSJ
,0,10)=TO_CHAR(SYSDATE,'YYYY-MM-DD')
105 4 0.0 0.00 0.00 3715838357
Module: plantMonitor.exe
UPDATE PV_PRODUCT SET PROD_STATE=1 WHERE PROD_SN IN( SELECT LJDM
FROM ATPUSTATUS WHERE STATUS='质量报警' AND ZDMC='CCECMES'||:B1
AND ISDELETE='0' )
98 98 1.0 0.00 0.00 2193015051
Module: plantMonitor.exe
SELECT COUNT(*) FROM ATPUSTATUS WHERE STATUS='设备故障' AND ZDMC
='CCECMES'||:B1 AND ISDELETE='0'
92 92 1.0 0.00 0.00 336012303
Module: plantMonitor.exe
UPDATE PV_PLANTSTATION SET PS_NOTE=' ' WHERE PS_CODE=:B1
86 86 1.0 0.00 0.00 1088193259
Module: plantMonitor.exe
UPDATE PV_PLANTSTATION SET PS_STATE=0 WHERE PS_CODE=:B1
85 71 0.8 0.00 0.00 4187199979
Module: plantMonitor.exe
SELECT ZDMC FROM ATPUZDACT WHERE SUBSTR(ZDMC,8,5)=:B1
82 127 1.5 0.00 0.00 2891858848
Module: plantMonitor.exe
INSERT INTO PV_PRODUCT (PROD_SN,PROD_CUSTOMER,PROD_PICPATH,PL_CO
DE,PL_NAME,PS_CODE,PS_NAME, PROD_WO,PROD_SO,PROD_DESC,PROD_NOTE,
PROD_TYPE,PROD_QMTYPE,PROD_STATE) SELECT A.GHTM,NVL(B.YHMC,' '),
B.GZDD,:B6 ,:B5 ,:B1 ,:B4 , B.JHMC,A.SO,NVL(:B3 ,' '), NVL(:B2 ,
' '),A.GGXHMC,NVL(B.JCLX,'none') ,'0' FROM SJCBB A,ATPUJHB B,SJS
79 79 1.0 0.00 0.00 2695195103
Module: plantMonitor.exe
SELECT DISTINCT PL_CODE,PL_NAME FROM PV_PLANTSTATION WHERE PS_CO
DE=:B1
78 0 0.0 0.00 0.00 3839079974
Module: plantMonitor.exe
UPDATE PV_PRODUCT SET PROD_STATE=2 WHERE PROD_SN IN( SELECT LJDM
FROM ATPUSTATUS WHERE STATUS='零件缺料' AND ZDMC='CCECMES'||:B1
SQL ordered by Executions DB/Inst: ccmes/ccmes Snaps: 13-14
-> End Executions Threshold: 100 Total Executions: 4,536
-> Captured SQL accounts for 53.9% of Total Executions
-> SQL reported below exceeded 1.0% of Total Executions
CPU per Elap per Old
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
AND ISDELETE='0' )
76 76 1.0 0.00 0.00 3765561844
Module: plantMonitor.exe
SELECT (SYSDATE-RQSJ)*60*24*60 FROM ATPUZDACT WHERE SUBSTR(ZDMC,
8,5)=:B1
75 75 1.0 0.00 0.00 1189561350
Module: plantMonitor.exe
SELECT COUNT(*) FROM ATPUZDACT WHERE ZDMC='CCECMES'||:B1
62 62 1.0 0.00 0.00 23696520
Module: plantMonitor.exe
UPDATE PV_PLANTSTATION SET PS_MACHINE=:B2 WHERE PS_CODE=:B1
61 61 1.0 0.00 0.00 1213086138
Module: plantMonitor.exe
SELECT NVL(BZ,' ') FROM ATPUZDACT WHERE ZDMC='CCECMES'||:B1
-------------------------------------------------------------
Instance Activity Stats DB/Inst: ccmes/ccmes Snaps: 13-14
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
CR blocks created 144 8.0 5.3
Cached Commit SCN referenced 0 0.0 0.0
Commit SCN cached 0 0.0 0.0
DBWR checkpoint buffers written 171 9.5 6.3
DBWR checkpoints 1 0.1 0.0
DBWR revisited being-written buff 0 0.0 0.0
DBWR tablespace checkpoint buffer 0 0.0 0.0
DBWR thread checkpoint buffers wr 171 9.5 6.3
DBWR transaction table writes 7 0.4 0.3
DBWR undo block writes 130 7.2 4.8
IMU CR rollbacks 8 0.4 0.3
IMU Flushes 11 0.6 0.4
IMU Redo allocation size 27,040 1,502.2 1,001.5
IMU bind flushes 0 0.0 0.0
IMU commits 7 0.4 0.3
IMU contention 5 0.3 0.2
IMU pool not allocated 9 0.5 0.3
IMU recursive-transaction flush 0 0.0 0.0
IMU undo allocation size 114,976 6,387.6 4,258.4
IMU- failed to get a private stra 9 0.5 0.3
Misses for writing mapping 0 0.0 0.0
SQL*Net roundtrips to/from client 1,241 68.9 46.0
active txn count during cleanout 207 11.5 7.7
application wait time 601 33.4 22.3
background checkpoints completed 1 0.1 0.0
background checkpoints started 1 0.1 0.0
background timeouts 47 2.6 1.7
buffer is not pinned count 164,063 9,114.6 6,076.4
buffer is pinned count 1,495,559 83,086.6 55,391.1
bytes received via SQL*Net from c 279,649 15,536.1 10,357.4
bytes sent via SQL*Net to client 613,812 34,100.7 22,733.8
calls to get snapshot scn: kcmgss 15,899 883.3 588.9
calls to kcmgas 885 49.2 32.8
calls to kcmgcs 43 2.4 1.6
cleanout - number of ktugct calls 215 11.9 8.0
cleanouts and rollbacks - consist 144 8.0 5.3
cleanouts only - consistent read 0 0.0 0.0
cluster key scan block gets 28,928 1,607.1 1,071.4
cluster key scans 14,472 804.0 536.0
commit cleanout failures: block l 0 0.0 0.0
commit cleanout failures: buffer 0 0.0 0.0
commit cleanout failures: callbac 1 0.1 0.0
commit cleanout failures: cannot 0 0.0 0.0
commit cleanouts 257 14.3 9.5
commit cleanouts successfully com 256 14.2 9.5
commit txn count during cleanout 31 1.7 1.2
concurrency wait time 694 38.6 25.7
consistent changes 4,179 232.2 154.8
consistent gets 799,306 44,405.9 29,603.9
consistent gets - examination 34,694 1,927.4 1,285.0
consistent gets direct 0 0.0 0.0
consistent gets from cache 799,303 44,405.7 29,603.8
cursor authentications 22 1.2 0.8
data blocks consistent reads - un 4,169 231.6 154.4
db block changes 13,349 741.6 494.4
db block gets 9,420 523.3 348.9
Instance Activity Stats DB/Inst: ccmes/ccmes Snaps: 13-14
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
db block gets direct 0 0.0 0.0
db block gets from cache 9,420 523.3 348.9
deferred (CURRENT) block cleanout 110 6.1 4.1
dirty buffers inspected 0 0.0 0.0
enqueue conversions 46 2.6 1.7
enqueue deadlocks 0 0.0 0.0
enqueue releases 518 28.8 19.2
enqueue requests 523 29.1 19.4
enqueue timeouts 1 0.1 0.0
enqueue waits 4 0.2 0.2
execute count 4,536 252.0 168.0
frame. signature mismatch 0 0.0 0.0
free buffer inspected 30,831 1,712.8 1,141.9
free buffer requested 31,065 1,725.8 1,150.6
heap block compress 15 0.8 0.6
hot buffers moved to head of LRU 1,487 82.6 55.1
immediate (CR) block cleanout app 144 8.0 5.3
immediate (CURRENT) block cleanou 58 3.2 2.2
index fast full scans (full) 0 0.0 0.0
index fetch by key 29,736 1,652.0 1,101.3
index scans kdiixs1 14,935 829.7 553.2
leaf node 90-10 splits 1 0.1 0.0
leaf node splits 23 1.3 0.9
logons cumulative 5 0.3 0.2
messages received 40 2.2 1.5
messages sent 40 2.2 1.5
no buffer to keep pinned count 0 0.0 0.0
no work - consistent read gets 737,248 40,958.2 27,305.5
opened cursors cumulative 1,020 56.7 37.8
parse count (failures) 0 0.0 0.0
parse count (hard) 197 10.9 7.3
parse count (total) 1,019 56.6 37.7
physical read IO requests 2,070 115.0 76.7
physical reads 30,093 1,671.8 1,114.6
physical reads cache 30,088 1,671.6 1,114.4
physical reads cache prefetch 28,012 1,556.2 1,037.5
physical reads direct 5 0.3 0.2
physical reads direct temporary t 0 0.0 0.0
physical reads prefetch warmup 0 0.0 0.0
physical write IO requests 46 2.6 1.7
physical writes 176 9.8 6.5
physical writes direct 5 0.3 0.2
physical writes direct (lob) 0 0.0 0.0
physical writes direct temporary 0 0.0 0.0
physical writes from cache 171 9.5 6.3
physical writes non checkpoint 50 2.8 1.9
pinned buffers inspected 206 11.4 7.6
prefetch clients - default 1 0.1 0.0
prefetch warmup blocks aged out b 0 0.0 0.0
recovery blocks read 0 0.0 0.0
recursive calls 4,784 265.8 177.2
redo blocks written 4,310 239.4 159.6
redo buffer allocation retries 8 0.4 0.3
redo entries 6,624 368.0 245.3
redo log space requests 12 0.7 0.4
redo ordering marks 0 0.0 0.0
Instance Activity Stats DB/Inst: ccmes/ccmes Snaps: 13-14
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
redo size 2,550,880 141,715.6 94,477.0
redo synch writes 18 1.0 0.7
redo wastage 8,720 484.4 323.0
redo writes 29 1.6 1.1
rollback changes - undo records a 0 0.0 0.0
rollbacks only - consistent read 1 0.1 0.0
rows fetched via callback 14,475 804.2 536.1
session logical reads 808,763 44,931.3 29,954.2
session uga memory max 3,070,948 170,608.2 113,738.8
shared hash latch upgrades - no w 14,992 832.9 555.3
shared hash latch upgrades - wait 0 0.0 0.0
sorts (memory) 587 32.6 21.7
sorts (rows) 33,182 1,843.4 1,229.0
summed dirty queue length 0 0.0 0.0
switch current to new buffer 692 38.4 25.6
table fetch by rowid 784,989 43,610.5 29,073.7
table fetch continued row 0 0.0 0.0
table scan blocks gotten 599,704 33,316.9 22,211.3
table scan rows gotten 62,177,839 3,454,324.4 2,302,882.9
table scans (long tables) 3 0.2 0.1
table scans (short tables) 4,850 269.4 179.6
transaction rollbacks 0 0.0 0.0
undo change vector size 821,156 45,619.8 30,413.2
user I/O wait time 2,173 120.7 80.5
user calls 2,143 119.1 79.4
user commits 27 1.5 1.0
workarea executions - optimal 1,322 73.4 49.0
write clones created in backgroun 0 0.0 0.0
write clones created in foregroun 0 0.0 0.0
-------------------------------------------------------------
Instance Activity Stats DB/Inst: ccmes/ccmes Snaps: 13-14
-> Statistics with absolute values (should not be diffed)
Statistic Begin Value End Value
--------------------------------- --------------- ---------------
logons current 105 106
opened cursors current 3,122 3,120
workarea memory allocated 10,193 4,660
-------------------------------------------------------------
Instance Activity Stats DB/Inst: ccmes/ccmes Snaps: 13-14
-> Statistics identified by '(derived)' come from sources other than SYSSTAT
Statistic Total per Hour
--------------------------------- ------------------ ---------
log switches (derived) 1 200.00
-------------------------------------------------------------
Time Model System Stats DB/Inst: ccmes/ccmes Snaps: 13-14
-> Total Time in Database calls 97.5s (or 97539127us)
Statistic Time (s) % of DB Time
----------------------------------- -------------------- ------------
DB CPU 1.6 1.6
DB time 97.5
PL/SQL execution elapsed time 0.1 .1
background cpu time 0.0 .0
background elapsed time 1.6 1.7
connection management call elapsed 0.0 .0
hard parse elapsed time 0.4 .4
parse time elapsed 0.7 .7
sql execute elapsed time 96.6 99.0
-------------------------------------------------------------
OS Statistics DB/Inst: ccmes/ccmes Snaps: 13-14
Statistic Total per Second
------------------------- ---------------------- ------------------
AVG_IN_BYTES 58,368 3,243
AVG_OUT_BYTES 0 0
IN_BYTES 466,944 25,941
OUT_BYTES 0 0
AVG_BUSY_TICKS 1,234
AVG_IDLE_TICKS 392
AVG_SYS_TICKS 111
AVG_USER_TICKS 1,123
BUSY_TICKS 9,877
IDLE_TICKS 3,149
SYS_TICKS 892
USER_TICKS 8,985
NUM_CPUS 8
-------------------------------------------------------------
Tablespace IO Stats DB/Inst: ccmes/ccmes Snaps: 13-14
-> rdered 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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
USERS
2,229 124 3.9 14.6 18 1 4,181 0.0
UNDOTBS1
1 0 0.0 1.0 23 1 0 0.0
SYSTEM
1 0 0.0 1.0 3 0 0 0.0
PERFSTAT
2 0 15.0 1.0 1 0 0 0.0
SYSAUX
1 0 0.0 1.0 1 0 0 0.0
-------------------------------------------------------------
File IO Stats DB/Inst: ccmes/ccmes Snaps: 13-14
->Mx Rd Bkt: Max bucket time for single block read
->rdered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Mx Av
Av Rd Rd Av Av Buffer BufWt
Reads Reads/s (ms) Bkt Blks/Rd Writes Writes/s Waits (ms)
-------------- ------- ----- --- ------- ------------ -------- ---------- ------
PERFSTAT G:\ORACLE\PRODUCT\10.1.0\ORADATA\ccmes\PERFSTAT.D
2 0 15.0 1.0 1 0 0
SYSAUX G:\ORACLE\PRODUCT\10.1.0\ORADATA\ccmes\SYSAUX01.D
1 0 0.0 1.0 1 0 0
SYSTEM G:\ORACLE\PRODUCT\10.1.0\ORADATA\ccmes\SYSTEM01.D
1 0 0.0 1.0 3 0 0
UNDOTBS1 G:\ORACLE\PRODUCT\10.1.0\ORADATA\ccmes\UNDOTBS01.
1 0 0.0 1.0 23 1 0
USERS G:\ORACLE\PRODUCT\10.1.0\ORADATA\ccmes\USERS01.DB
2,229 124 3.9 14.6 18 1 4,181 0.0
-------------------------------------------------------------
Buffer Pool Statistics DB/Inst: ccmes/ccmes Snaps: 13-14
-> Standard block size Pools D: default, K: keep, R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
Free Writ Buffer
Number of Pool Buffer Physical Physical Buff Comp Busy
P Buffers Hit% Gets Reads Writes Wait Wait Waits
--- ---------- ---- -------------- ------------ ----------- ---- ---- ----------
D 61,122 96 839,847 30,841 171 0 0 3,845
-------------------------------------------------------------
Instance Recovery Stats DB/Inst: ccmes/ccmes Snaps: 13-14
-> 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 0 0 934 21452 18432 18432 39523
E 0 0 999 20180 18432 18432 40063
-------------------------------------------------------------
, 'D' , size_for_estimate*1024/:def_cache
*
ERROR at line 10:
ORA-01476: divisor is equal to zero |
|
发表于 2005-12-5 13:22 | 
发表于 2005-12-5 15:41 | 
发表于 2005-12-5 16:58 | 
