烦请各位大师帮忙分析一下statspack,多谢！

显示全部楼层 · 2014-5-9 08:24:37

Cache Sizes
~~~~~~~~~~~
db_block_buffers: 102400
log_buffer: 10485760

db_block_size: 8192shared_pool_size:419430400
Load Profile
~~~~~~~~~~~~
Per Second Per Transaction

--------------- ---------------

Redo size:
105,524.77
60,323.82

Logical reads:
41,457.36
23,699.33

Block changes:
488.35
279.17

Physical reads:
728.51
416.45

Physical writes:
27.19
15.54

User calls:
396.34
226.57

Parses:
29.33
16.77

Hard parses:
0.39
0.22

Sorts:
12.64
7.22

Logons:
0.74
0.43

Executes:
690.31
394.62

Transactions:
1.75
% Blocks changed per Read:1.18Recursive Call %: 74.91
Rollback per transaction %:0.00 Rows per Sort:689.97
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Buffer Nowait %: 99.98 Redo NoWait %:100.00

BufferHit %: 98.24In-memory Sort %: 99.99

Library Hit %: 99.90Soft Parse %: 98.66
Execute to Parse %: 95.75 Latch Hit %: 99.92
Parse CPU to Parse Elapsd %:7.29 % Non-Parse CPU: 99.49
Shared Pool StatisticsBegin End

------------

Memory Usage %: 91.63 91.04
% SQL with executions>1: 70.60 77.45
% Memory for SQL w/exec>1: 53.20 48.75
Top 5 Wait Events
~~~~~~~~~~~~~~~~~
Wait % Total
Event
WaitsTime (cs) Wt Time
-------------------------------------------- ------------ ------------ -------
SQL*Net message from dblink
12,563,8561,723,467 61.68
db file sequential read
3,746,636431,051 15.43
latch free
5,460,287355,634 12.73
global cache cr request
1,148,943106,4783.81
global cache lock busy
34,472 54,1081.94

-------------------------------------------------------------
Wait Events for DB: ORACLEInstance: ORACLESnaps: 19 -21
-> cs - centisecond -100th of a second
-> ms - millisecond - 1000th of a second
-> ordered by wait time desc, waits desc (idle events last)

Avg

Total WaitwaitWaits
Event
Waits TimeoutsTime (cs)(ms) /txn
---------------------------- ------------ ---------- ----------- ------ ------
SQL*Net message from dblink12,563,856
0 1,723,4671998.1
db file sequential read 3,746,636
0 431,0511297.6
latch free
5,460,287311,070 355,6341433.8
global cache cr request 1,148,943284 106,4781 91.3
global cache lock busy
34,472
254,108 162.7
db file scattered read
469,017
040,3231 37.3
buffer busy due to global ca 32,657
036,835 112.6
buffer busy waits
35,349
016,85552.8
SQL*Net more data from dblin353,562
0 7,4470 28.1
SQL*Net more data to client 1,902,647
0 5,7100151.1
log file sync
47,783
0 3,36113.8
log file sequential read 25,376
0 3,01612.0
log file parallel write
57,987
0 2,57704.6
global cache lock open x 21,899
0 1,35611.7
db file parallel write
10,607
0 98710.8
direct path read
3,513
0 83820.3
Contacting SCN server or SCN146,578
0 8000 11.6
SQL*Net break/reset to dblin185,588
0 7260 14.7
global cache lock s to x 10,226
0 62510.8
file open
32,864
0 56202.6
enqueue
4,817
4 36810.4
SQL*Net message to dblink12,563,855
0 3420998.1
direct path write
973
0 26430.1
library cache lock
4,480
0 25710.4
control file sequential read4,040
0
8900.3
refresh controlfile command 332
0
5320.0
global cache lock open s
1,085
0
5100.1
DFS lock handle
387 13
3910.0
control file parallel write 2,542
0
3300.2
row cache lock
225
0
2410.0
log file switch completion
12
0
13 110.0
library cache pin
25
0 730.0
SQL*Net break/reset to clien
6
0 7 120.0
file identify
64
0 410.0
LGWR wait for redo copy
48
0 200.0
SQL*Net more data to dblink 912
0 000.1
log file single write
32
0 000.0
wait for inquiry response
6
0 000.0
buffer deadlock
4
4 000.0
SQL*Net message from client 2,851,804
0 ###########378226.5
lock manager wait for remote1,453,782 72,319 665,7295115.5
SQL*Net message to client 2,851,813
0 2580226.6
SQL*Net more data from clien
707
0
3910.1

-------------------------------------------------------------
Background Wait Events for DB: ORACLEInstance: ORACLESnaps: 19 -21
-> ordered by wait time desc, waits desc (idle events last)

Avg

Total WaitwaitWaits
Event
Waits TimeoutsTime (cs)(ms) /txn
---------------------------- ------------ ---------- ----------- ------ ------
latch free
5,250,351113,03123,9950417.1
log file sequential read 25,376
0 3,01612.0
log file parallel write
57,987
0 2,57704.6
db file parallel write
10,608
0 98710.8
file open
5,024
0
6600.4
db file scattered read
44
0
58 130.0
DFS lock handle
387 13
3910.0
control file sequential read1,534
0
3800.1
enqueue
555
1
3710.0
control file parallel write 2,542
0
3300.2
direct path read
2,580
0
2400.2
db file sequential read
15
0 750.0
file identify
64
0 410.0
global cache cr request
95
0 200.0
LGWR wait for redo copy
48
0 200.0
global cache lock open s
6
0 120.0
direct path write
780
0 000.1
log file single write
32
0 000.0
wait for inquiry response
6
0 000.0
library cache lock
5
0 000.0
Contacting SCN server or SCN
1
0 000.0
rdbms ipc message
523,427318,195 6,314,655121 41.6
pmon timer
3,4152,499 719,374 21070.3
smon timer
24 23 712,824 ######0.0
lock manager wait for remote1,453,789 72,319 665,7285115.5

-------------------------------------------------------------

千问 · 2014-5-9 08:24:37

SQL ordered by Gets for DB: ORACLEInstance: ORACLESnaps: 19 -21
-> 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
Buffer GetsExecutionsGets per Exec% TotalHash Value
--------------- ------------ -------------- ------- ------------
64,216,342 19,0683,367.821.5 1526479081
SELECT "STEPSEQ","LOTTYPE","PRODUCT" FROM "WIP" "WIP" WHERE "STE
PSEQ"=:1 AND "LOTTYPE":2
22,394,998
674 33,227.0 7.5 21984430
SELECT "RPTTIME","STEPSEQ","ACTIVITY","QUANTITY","LOTTYPE","PROD
UCT" FROM "WIP_EOH" "WIP_EOH" WHERE "ACTIVITY":1 AND "STEPSEQ"
=:2 AND "LOTTYPE":3 AND "RPTTIME"=DECODE(SIGN(TO_NUMBER(TO_CHA
R(:4,:5))-:6),(-:7),TO_DATE(TO_CHAR(:8-:9,:10)||:11,:12),TO_DATE
(TO_CHAR(:13,:14)||:15,:16))
8,560,049
117 73,162.8 2.9 2975062137
select sum("1SOL16&quot

,sum("1SOL17&quot

,sum("1SOL18&quot

,sum("1SOL19&quot

,s
um("1SOL20&quot

,sum("1SOL21&quot

,sum("1SOL22&quot

,sum("1SOL23&quot

from (s
electdecode(EQPID,'1SOL16',QUANTITY,0) "1SOL16",decode(EQPID,'
1SOL17',QUANTITY,0) "1SOL17",decode(EQPID,'1SOL18',QUANTITY,0) "
1SOL18",decode(EQPID,'1SOL19',QUANTITY,0) "1SOL19",decode(EQPID,
7,874,0431,7724,443.6 2.6186823899
select m.eqpid,status,trim(eqpcode) eqpcode,nvl(product,'-') pr
o,nvl(qty,0),decode(m.status, 'RUN', '00FF00', 'IDLE', '00FFFF
', 'PM', 'FFFF00','DOWN','red','TPM','chocolate'),EQPCODEDESC,CO
MMENTDESC,unittypefrom(select A.EQPID eqpid,A.STATUS statu
s,EQPCODE,unittype, EQPCODEDESC,COMMENTDESCfrom eqpstatus A,
7,834,6721,7824,396.6 2.6 87010636
select m.eqpid,status,trim(eqpcode) eqpcode,nvl(product,'-') pr
o,nvl(qty,0),decode(m.status, 'RUN', '00FF00', 'IDLE', '00FFFF
', 'PM', 'FFFF00','DOWN','red','TPM','chocolate'),EQPCODEDESC,CO
MMENTDESC,unittypefrom(select A.EQPID eqpid,A.STATUS statu
s,EQPCODE,unittype, EQPCODEDESC,COMMENTDESCfrom eqpstatus A,
5,056,957
149 33,939.3 1.7 1082602718
BEGIN wipmgr_hist.pmcos_wip ; END;
4,108,919
22,054,459.5 1.4 3927298166
select bb.PRODUCT,aa.MATPRODUCTID,aa.MATTYPE,aa.MATLOTID,sum(aa.
QUANTITY)from lothistory_pn2m aa,lothistory bb where aa.lotid=
bb.lotid and bb.STEPSEQ='1SM030' and aa.SHIPTIME=TO_DATE('20060311220000','yyyymmddhh24miss') a
nd bb.EVENTTIME 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
Buffer GetsExecutionsGets per Exec% TotalHash Value
--------------- ------------ -------------- ------- ------------
2,765,854
6804,067.4 0.9 2681336474
select m.eqpid,status,trim(eqpcode) eqpcode,nvl(product,'-') pr
o,nvl(qty,0),decode(m.status, 'RUN', '00FF00', 'IDLE', '00FFFF
', 'PM', 'FFFF00','DOWN','red','TPM','chocolate'),EQPCODEDESC,CO
MMENTDESC,unittypefrom(select A.EQPID eqpid,A.STATUS statu
s,EQPCODE,unittype, EQPCODEDESC,COMMENTDESCfrom eqpstatus A,
2,602,723
179 14,540.4 0.9 2827256168
select m.eqpid,status,trim(eqpcode) eqpcode,nvl(product,'-') pr
o,nvl(qty,0),decode(m.status, 'RUN', '00FF00', 'IDLE', '00FFFF
', 'PM', 'FFFF00','DOWN','red','TPM','chocolate'),EQPCODEDESC,CO
MMENTDESC from(select A.EQPID eqpid,A.STATUS status,EQPCODE
, EQPCODEDESC,COMMENTDESCfrom eqpstatus A,equipment@sesl1mexas
2,546,175
217 11,733.5 0.9 2021575920
BEGIN wipmgr_eqp.pmcos_eqp ; END;
2,541,318
3427,430.8 0.9250848842
BEGIN wipmgr_out.pmcos_wip ; END;
2,536,709
3417,439.0 0.9 2810677235
BEGIN wipmgr_out01.pmcos_wip ; END;
2,532,700
179 14,149.2 0.8 1528597451
select m.eqpid,status,trim(eqpcode) eqpcode,nvl(product,'-') pr
o,nvl(qty,0),decode(m.status, 'RUN', '00FF00', 'IDLE', '00FFFF
', 'PM', 'FFFF00','DOWN','red','TPM','chocolate'),EQPCODEDESC,CO
MMENTDESC from(select A.EQPID eqpid,A.STATUS status,EQPCODE
, EQPCODEDESC,COMMENTDESCfrom eqpstatus A,equipment@sesl1mexas
2,481,536
5994,142.8 0.8 1090819526
select m.eqpid,status,trim(eqpcode) eqpcode,nvl(product,'-') pr
o,nvl(qty,0),decode(m.status, 'RUN', '00FF00', 'IDLE', '00FFFF
', 'PM', 'FFFF00','DOWN','red','TPM','chocolate'),EQPCODEDESC,CO
MMENTDESC from(select A.EQPID eqpid,A.STATUS status,EQPCODE
, EQPCODEDESC,COMMENTDESCfrom eqpstatus A,equipment@sesl1mexas
2,331,905
117 19,930.8 0.8 1907151006
select sum("1SOL16&quot

,sum("1SOL17&quot

,sum("1SOL18"),sum("1SOL19"),s
um("1SOL20"),sum("1SOL21"),sum("1SOL22"),sum("1SOL23") from (s
electdecode(EQPID,'1SOL16',QUANTITY,0) "1SOL16",decode(EQPID,'
1SOL17',QUANTITY,0) "1SOL17",decode(EQPID,'1SOL18',QUANTITY,0) "
1SOL18",decode(EQPID,'1SOL19',QUANTITY,0) "1SOL19",decode(EQPID,
2,255,417
6003,759.0 0.8 2130543886
select m.eqpid,status,trim(eqpcode) eqpcode,nvl(product,'-') pr
o,nvl(qty,0),decode(m.status, 'RUN', '00FF00', 'IDLE', '00FFFF

-------------------------------------------------------------
SQL ordered by Reads for DB: ORACLEInstance: ORACLESnaps: 19 -21
-> End Disk Reads Threshold:1000
Physical ReadsExecutionsReads per Exec % TotalHash Value
--------------- ------------ -------------- ------- ------------
2,990,818 19,068
156.957.1 1526479081
SELECT "STEPSEQ","LOTTYPE","PRODUCT" FROM "WIP" "WIP" WHERE "STE
PSEQ"=:1 AND "LOTTYPE":2
338,140
2169,070.0 6.5 1342713388
select to_char(max(made_dttm),'yyyymmddhh24miss') max_made_dttm
from tpss_if
208,542
2104,271.0 4.0 3927298166
select bb.PRODUCT,aa.MATPRODUCTID,aa.MATTYPE,aa.MATLOTID,sum(aa.
QUANTITY)from lothistory_pn2m aa,lothistory bb where aa.lotid=
bb.lotid and bb.STEPSEQ='1SM030' and aa.SHIPTIME=TO_DATE('20060311220000','yyyymmddhh24miss') a
nd bb.EVENTTIME=TO_DATE('20060312220000','yyyymmddhh24miss') a
nd bb.EVENTTIME End Disk Reads Threshold:1000
Physical ReadsExecutionsReads per Exec % TotalHash Value
--------------- ------------ -------------- ------- ------------
QUANTITY)from lothistory_pn2m aa,lothistory bb where aa.lotid=
bb.lotid and bb.STEPSEQ='1SM030' and aa.SHIPTIME=TO_DATE('20060315220000','yyyymmddhh24miss') a
nd bb.EVENTTIME End Executions Threshold: 100
Executions Rows ProcessedRows per Exec Hash Value
------------ ---------------- ---------------- ------------
398,716
110,741
0.3 2602864013
SELECT NVL(SUBSTR(VALDATA,1,30),'-') VALUE FROM S1MOD.FWLOT_PN
2M@SESL1MEXASWHERE FROMID = :b1AND LINKNAME = 'customattrs'
AND KEYDATA = :b2AND ROWNUMEnd Executions Threshold: 100
Executions Rows ProcessedRows per Exec Hash Value
------------ ---------------- ---------------- ------------
ATLOTID = DECODE(:b2,'BL',:b3,:b4)
92,819
0
0.0 2405908255
SELECT ASSOCIATIONID FROM S1MOD.FWMATERIALASSOCIATION@SESL1MEX
ASWHERE CHILDID = :b1AND ASSOCIATIONTYPE = 'Carrier'AND CH
ILDTYPE = 'Lot'
92,815 92,815
1.0305130526
SELECT PROCESSINGSTATUS,CURRENTRULEINDEX,STEPSEQ FROM S1MOD.FW
LOT@SESL1MEXAS L,S1MOD.FWWIPSTEP@SESL1MEXAS SWHERE L.SYSID = :
b1AND L.SYSID = S.LOTOBJECTAND ROWNUMEnd Executions Threshold: 100
Executions Rows ProcessedRows per Exec Hash Value
------------ ---------------- ---------------- ------------
,PREEQPTYPE=:b15,EQPTYPE=:b16,EQPID=:b17,AREA=:b18,CELL=:b19,CUR
RSTKID=:b20,FINALSTKID=:b21,PPID=:b22,STEPDESC=:b23,PRCSTATUS=:b
84,109 84,109
1.0 1692825832
SELECT PROCESSINGSTATUS,CURRENTRULEINDEX,STEPNAME FROM FWLOT@S

-------------------------------------------------------------
SQL ordered by Sharable Memory for DB: ORACLEInstance: ORACLESnaps: 19 -21
-> End Sharable Memory Threshold: 1048576
Sharable Mem (b)Executions% TotalHash Value
---------------- ------------ ------- ------------
2,231,750
1 0.3 3023756875
select process, product, lotid, activity, stepseq, to_char(int
ime,'yyyy-mm-dd hh24:mi:ss') as intime, to_char(EVENTTIME,'yyy
y-mm-dd hh24:mi:ss') eventtime, trunc(mod(eventtime-PRETKOUTTI
ME, 1) * 24) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24,
1) * 60) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24 * 60,
2,217,958
1 0.3 1323505442
select process, product, lotid, activity, stepseq, to_char(int
ime,'yyyy-mm-dd hh24:mi:ss') as intime, to_char(EVENTTIME,'yyy
y-mm-dd hh24:mi:ss') eventtime, trunc(mod(eventtime-PRETKOUTTI
ME, 1) * 24) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24,
1) * 60) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24 * 60,
1,985,744
2 0.3 3315611334
select process, product, lotid, activity, stepseq, to_char(int
ime,'yyyy-mm-dd hh24:mi:ss') as intime, to_char(EVENTTIME,'yyy
y-mm-dd hh24:mi:ss') eventtime, trunc(mod(eventtime-PRETKOUTTI
ME, 1) * 24) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24,
1) * 60) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24 * 60,
1,721,588
1 0.3 2265686793
select process, product, lotid, activity, stepseq, to_char(int
ime,'yyyy-mm-dd hh24:mi:ss') as intime, to_char(EVENTTIME,'yyy
y-mm-dd hh24:mi:ss') eventtime, trunc(mod(eventtime-PRETKOUTTI
ME, 1) * 24) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24,
1) * 60) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24 * 60,
1,691,468
1 0.3864321446
select process, product, lotid, activity, stepseq, to_char(int
ime,'yyyy-mm-dd hh24:mi:ss') as intime, to_char(EVENTTIME,'yyy
y-mm-dd hh24:mi:ss') eventtime, trunc(mod(eventtime-PRETKOUTTI
ME, 1) * 24) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24,
1) * 60) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24 * 60,
1,664,018
1 0.3 4220127478
select process, product, lotid, activity, stepseq, to_char(int
ime,'yyyy-mm-dd hh24:mi:ss') as intime, to_char(EVENTTIME,'yyy
y-mm-dd hh24:mi:ss') eventtime, trunc(mod(eventtime-PRETKOUTTI
ME, 1) * 24) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24,
1) * 60) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24 * 60,
1,646,883
1 0.3 4225219385
select process, product, lotid, activity, stepseq, to_char(int
ime,'yyyy-mm-dd hh24:mi:ss') as intime, to_char(EVENTTIME,'yyy
y-mm-dd hh24:mi:ss') eventtime, trunc(mod(eventtime-PRETKOUTTI
ME, 1) * 24) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24,
1) * 60) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24 * 60,
1,629,276
1 0.3 2524111568
select process, product, lotid, activity, stepseq, to_char(int
ime,'yyyy-mm-dd hh24:mi:ss') as intime, to_char(EVENTTIME,'yyy
y-mm-dd hh24:mi:ss') eventtime, trunc(mod(eventtime-PRETKOUTTI
ME, 1) * 24) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24,
1) * 60) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24 * 60,
SQL ordered by Sharable Memory for DB: ORACLEInstance: ORACLESnaps: 19 -21
-> End Sharable Memory Threshold: 1048576
Sharable Mem (b)Executions% TotalHash Value
---------------- ------------ ------- ------------
1,582,527
1 0.2 4223174121
select process, product, lotid, activity, stepseq, to_char(int
ime,'yyyy-mm-dd hh24:mi:ss') as intime, to_char(EVENTTIME,'yyy
y-mm-dd hh24:mi:ss') eventtime, trunc(mod(eventtime-PRETKOUTTI
ME, 1) * 24) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24,
1) * 60) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24 * 60,
1,574,046
1 0.2 2755498735
select process, product, lotid, activity, stepseq, to_char(int
ime,'yyyy-mm-dd hh24:mi:ss') as intime, to_char(EVENTTIME,'yyy
y-mm-dd hh24:mi:ss') eventtime, trunc(mod(eventtime-PRETKOUTTI
ME, 1) * 24) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24,
1) * 60) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24 * 60,
1,494,984
1 0.2 4148079180
select process, product, lotid, activity, stepseq, to_char(int
ime,'yyyy-mm-dd hh24:mi:ss') as intime, to_char(EVENTTIME,'yyy
y-mm-dd hh24:mi:ss') eventtime, trunc(mod(eventtime-PRETKOUTTI
ME, 1) * 24) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24,
1) * 60) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24 * 60,
1,488,953
1 0.2246856513
select process, product, lotid, activity, stepseq, to_char(int
ime,'yyyy-mm-dd hh24:mi:ss') as intime, to_char(EVENTTIME,'yyy
y-mm-dd hh24:mi:ss') eventtime, trunc(mod(eventtime-PRETKOUTTI
ME, 1) * 24) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24,
1) * 60) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24 * 60,
1,120,280
3 0.2 1565717569
select process, product, lotid, activity, stepseq, to_char(int
ime,'yyyy-mm-dd hh24:mi:ss') as intime, to_char(EVENTTIME,'yyy
y-mm-dd hh24:mi:ss') eventtime, trunc(mod(eventtime-PRETKOUTTI
ME, 1) * 24) || ':' || trunc(mod((eventtime-PRETKOUTTIME) * 24,

-------------------------------------------------------------
Instance Activity Stats for DB: ORACLEInstance: ORACLESnaps: 19 -21
Statistic
Total per Secondper Trans
--------------------------------- ---------------- ------------ ------------
CPU used by this session
521,294 72.4 41.4
CPU used when call started
521,350 72.5 41.4
CR blocks created
793,131110.2 63.0
Cached Commit SCN referenced
0
0.0
0.0
DBWR buffers scanned
697,577 96.9 55.4
DBWR checkpoint buffers written
59,666
8.3
4.7
DBWR checkpoints
8
0.0
0.0
DBWR cross instance writes
27
0.0
0.0
DBWR free buffers found
637,783 88.6 50.7
DBWR lru scans
8,199
1.1
0.7
DBWR make free requests
10,257
1.4
0.8
DBWR revisited being-written buff
0
0.0
0.0
DBWR summed scan depth
697,577 96.9 55.4
DBWR transaction table writes
141
0.0
0.0
DBWR undo block writes
40,910
5.7
3.3
Parallel operations downgraded to
0
0.0
0.0
SQL*Net roundtrips to/from client2,840,309394.7225.6
SQL*Net roundtrips to/from dblink 12,563,3741,745.9998.0
background checkpoints completed
8
0.0
0.0
background checkpoints started
8
0.0
0.0
background timeouts
252,481 35.1 20.1
branch node splits
14
0.0
0.0
buffer is not pinned count
275,376,063 38,267.9 21,876.1
buffer is pinned count
634,425,739 88,163.7 50,399.3
bytes received via SQL*Net from c132,503,227 18,413.5 10,526.2
bytes received via SQL*Net from d2,928,875,994407,014.5232,672.1
bytes sent via SQL*Net to client 4,696,235,518652,617.5373,072.4
bytes sent via SQL*Net to dblink 3,479,731,402483,564.7276,432.4
calls to get snapshot scn: kcmgss5,009,097696.1397.9
calls to kcmgas
78,100 10.9
6.2
calls to kcmgcs
16,886
2.4
1.3
change write time
2,038
0.3
0.2
cleanouts and rollbacks - consist
486,736 67.6 38.7
cleanouts only - consistent read
13,979
1.9
1.1
cluster key scan block gets
950
0.1
0.1
cluster key scans
528
0.1
0.0
commit cleanout failures: block l
5,212
0.7
0.4
commit cleanout failures: buffer
2
0.0
0.0
commit cleanout failures: callbac
5,117
0.7
0.4
commit cleanout failures: cannot
13
0.0
0.0
commit cleanout failures: hot bac
0
0.0
0.0
commit cleanouts
325,444 45.2 25.9
commit cleanouts successfully com
315,100 43.8 25.0
consistent changes
1,578,680219.4125.4
consistent gets
291,476,565 40,505.4 23,155.1
current blocks converted for CR
cursor authentications
5,100
0.7
0.4
data blocks consistent reads - un1,576,005219.0125.2
db block changes
3,514,158488.4279.2
db block gets
6,850,455952.0544.2
deferred (CURRENT) block cleanout
104,768 14.6
8.3
dirty buffers inspected
9,355
1.3
0.7
enqueue conversions
8,908,8331,238.0707.7
enqueue releases
4,956,414688.8393.7
enqueue requests
4,956,431688.8393.7
enqueue timeouts
10
0.0
0.0
Instance Activity Stats for DB: ORACLEInstance: ORACLESnaps: 19 -21
Statistic
Total per Secondper Trans
--------------------------------- ---------------- ------------ ------------
enqueue waits
4,762
0.7
0.4
exchange deadlocks
4
0.0
0.0
execute count
4,967,462690.3394.6
free buffer inspected
11,624
1.6
0.9
free buffer requested
6,063,219842.6481.7
get Next seq # returned valid sta5,075,696705.4403.2
global cache convert timeouts
0
0.0
0.0
global cache converts
20,528
2.9
1.6
global cache cr blocks received
2
0.0
0.0
global cache cr blocks served
6
0.0
0.0
global cache gets
5,177,421719.5411.3
global lock async converts
20,765
2.9
1.7
global lock async gets
5,177,454719.5411.3
global lock releases
5,252,833730.0417.3
global lock sync converts
241
0.0
0.0
global lock sync gets
77,235 10.7
6.1
hot buffers moved to head of LRU 703,059 97.7 55.9
immediate (CR) block cleanout app
500,715 69.6 39.8
immediate (CURRENT) block cleanou 35,143
4.9
2.8
index fast full scans (full)
0
0.0
0.0
instance recovery database freeze
0
0.0
0.0
kcmgss read scn without going to
10,601
1.5
0.8
kcmgss waited for batching
139,731 19.4 11.1
leaf node splits
3,563
0.5
0.3
logons cumulative
5,361
0.7
0.4
logons current
messages received
156,767 21.8 12.5
messages sent
156,767 21.8 12.5
no buffer to keep pinned count
0
0.0
0.0
no work - consistent read gets 269,242,890 37,415.6 21,388.9
opened cursors cumulative
157,507 21.9 12.5
opened cursors current
parse count (hard)
2,832
0.4
0.2
parse count (total)
211,055 29.3 16.8
parse time cpu
2,680
0.4
0.2
parse time elapsed
36,743
5.1
2.9
physical reads
5,242,325728.5416.5
physical reads direct
65,849
9.2
5.2
physical writes
195,665 27.2 15.5
physical writes direct
66,855
9.3
5.3
physical writes non checkpoint
173,141 24.1 13.8
pinned buffers inspected
519
0.1
0.0
prefetched blocks
960,708133.5 76.3
prefetched blocks aged out before
84
0.0
0.0
process last non-idle time################ ############ ############
recursive calls
8,516,3781,183.5676.6
recursive cpu usage
62,806
8.7
5.0
redo blocks written
790,857109.9 62.8
redo buffer allocation retries
12
0.0
0.0
redo entries
2,037,935283.2161.9
redo log space requests
12
0.0
0.0
redo log space wait time
13
0.0
0.0
redo ordering marks
40,018
5.6
3.2
redo size
759,356,240105,524.8 60,323.8
redo synch time
3,708
0.5
0.3
redo synch writes
48,508
6.7
3.9

千问 · 2014-5-9 08:24:37

Instance Activity Stats for DB: ORACLEInstance: ORACLESnaps: 19 -21
Statistic
Total per Secondper Trans
--------------------------------- ---------------- ------------ ------------
redo wastage
38,018,8725,283.33,020.3
redo write time
2,879
0.4
0.2
redo writer latching time
2
0.0
0.0
redo writes
57,984
8.1
4.6
remote instance undo block writes
0
0.0
0.0
remote instance undo header write
23
0.0
0.0
rollback changes - undo records a
12
0.0
0.0
rollbacks only - consistent read 308,875 42.9 24.5
rows fetched via callback
5,754,718799.7457.2
session connect time
################ ############ ############
session cursor cache count
123
0.0
0.0
session cursor cache hits
91,763 12.8
7.3
session logical reads
298,327,137 41,457.4 23,699.3
session pga memory
27,486,436,7363,819,682.72,183,542.8
session pga memory max
27,516,727,9923,823,892.22,185,949.2
session uga memory
32,626,1764,533.92,591.9
session uga memory max
1,021,312,712141,927.8 81,133.8
sorts (disk)
5
0.0
0.0
sorts (memory)
90,941 12.6
7.2
sorts (rows)
62,749,7048,720.14,984.9
summed dirty queue length
303
0.0
0.0
switch current to new buffer
table fetch by rowid
415,745,019 57,774.5 33,027.1
table fetch continued row
2,028
0.3
0.2
table scan blocks gotten
72,189,464 10,031.95,734.8
table scan rows gotten
1,139,525,691158,355.4 90,524.8
table scans (long tables)
21,382
3.0
1.7
table scans (rowid ranges)
0
0.0
0.0
table scans (short tables)
466,317 64.8 37.0
total file opens
32,867
4.6
2.6
transaction lock background gets
0
0.0
0.0
transaction lock foreground reque
0
0.0
0.0
transaction rollbacks
0
0.0
0.0
transaction tables consistent rea
14
0.0
0.0
transaction tables consistent rea
508
0.1
0.0
user calls
2,852,056396.3226.6
user commits
12,588
1.8
1.0
user rollbacks
0
0.0
0.0
write clones created in backgroun
0
0.0
0.0
write clones created in foregroun
12
0.0
0.0

-------------------------------------------------------------
Tablespace IO Stats for DB: ORACLEInstance: ORACLESnaps: 19 -21
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------

AvAv Av
AvBuffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/sWaits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
REPORT_DAT
3,993,094 5551.1 1.2 21,9233 59,7778.3
REPORT_INDX
221,687315.6 1.0 65,45598,0955.1
RBS
263 0 49.7 1.0 41,03161202.8
ACTIVE_TEST_DAT
1,507 0 15.2 1.01,0450
00.0
TEMP
1,181 0 18.153.6
5270
00.0
SYSTEM
1,012 06.9 2.1 520
4 15.0
USERS
298 0 11.4 1.0
40
00.0
ACTIVE_TEST_INDX

60 0368.3 1.0 120
00.0
TOOLS

4 0467.5 1.0
40
00.0

-------------------------------------------------------------
File IO Stats for DB: ORACLEInstance: ORACLESnaps: 19 -21
->ordered by Tablespace, File
Tablespace
Filename
------------------------ ----------------------------------------------------

AvAv Av
AvBuffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/sWaits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
ACTIVE_TEST_DAT
/dev/disk1/dsk57b
268 0 27.2 1.0
3330
0

/dev/disk1/dsk57c
396 0 18.6 1.0
1830
0

/dev/disk1/dsk57d
843 09.7 1.0
5290
0
ACTIVE_TEST_INDX /dev/disk1/dsk58b

20 0372.5 1.0
40
0

/dev/disk1/dsk58c

20 0369.0 1.0
40
0

/dev/disk1/dsk58d

20 0363.5 1.0
40
0
RBS
/dev/disk1/dsk24c
106 0 22.1 1.09,7331 212.9

/dev/disk1/dsk24g

26 0130.4 1.07,1531 142.1

/dev/disk1/dsk24h

42 0 88.6 1.07,4361 113.6

/dev/disk1/dsk25c

89 0 40.6 1.0 16,7092 742.7
REPORT_DAT
/dev/disk1/dsk26b
175 0 15.522.3
40
42.5

/dev/disk1/dsk26c
160 0 15.424.3
40
0

/dev/disk1/dsk26d
541 09.1 7.9
40
0

/dev/disk1/dsk26e
207 0 12.919.0
40
0

/dev/disk1/dsk26f
167 0 14.723.3
40
1 10.0

/dev/disk1/dsk26g
9,031 15.0 1.4
79703144.6

/dev/disk1/dsk26h
5,205 16.5 1.7 9301007.5

/dev/disk1/dsk27b

79 0 27.819.8
40
10.0

/dev/disk1/dsk27c
5,999 11.4 1.2
40
0

/dev/disk1/dsk27d
200 0 10.3 8.4
40
0

/dev/disk1/dsk27e
448 05.4 4.3
50
0

/dev/disk1/dsk27f
792 07.4 2.9
40
0

/dev/disk1/dsk27g
1,165 02.9 1.6
40 225.0

/dev/disk1/dsk27h

71 0 25.411.5
40
0

/dev/disk1/dsk28b
File IO Stats for DB: ORACLEInstance: ORACLESnaps: 19 -21
->ordered by Tablespace, File
Tablespace
Filename
------------------------ ----------------------------------------------------

AvAv Av
AvBuffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/sWaits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
63,746 95.9 1.11,03305,6746.0
REPORT_DAT
/dev/disk1/dsk28c
53,319 75.6 1.1
61903,7095.7

/dev/disk1/dsk28d
809 08.6 5.6 170
1 10.0

/dev/disk1/dsk28e
755 08.6 5.9 250
52.0

/dev/disk1/dsk28f
377 0 10.5 8.9 110
33.3

/dev/disk1/dsk28g
324 0 12.912.5
70
0

/dev/disk1/dsk28h
395 0 11.510.4
50
0

/dev/disk1/dsk30b
853 05.2 6.5
6070 147.1

/dev/disk1/dsk30c
9,492 11.3 1.4
12509781.6

/dev/disk1/dsk30d
2,227 03.211.7
1980 114.5

/dev/disk1/dsk30e
3,297,490 4580.3 1.2 10,28816,183 35.7

/dev/disk1/dsk30f
23,696 32.4 1.5
60
0

/dev/disk1/dsk30g
4,492 11.7 1.9
4320
0

/dev/disk1/dsk30h
734 04.8 6.3 120
0

/dev/disk1/dsk32b
3,285 03.8 3.9 220
0

/dev/disk1/dsk32c
2,165 03.3 2.7
2000
0

/dev/disk1/dsk32d
12,830 24.4 1.6 2206,1914.8

/dev/disk1/dsk32e
911 05.5 5.1 160 709.7

/dev/disk1/dsk32f
485 04.4 8.7
60 245.4

/dev/disk1/dsk32g
252 08.215.8
40
40.0

/dev/disk1/dsk32h
21,589 36.2 1.2
29401,8795.6

/dev/disk1/dsk33b
1,138 01.7 9.2
90 132.3

/dev/disk1/dsk33c
304 02.317.3
40
0

/dev/disk1/dsk33d
602 01.414.4
40
0

/dev/disk1/dsk33e
574 01.815.0
40
0

/dev/disk1/dsk33f
578 01.614.9
40
10.0

/dev/disk1/dsk33g
File IO Stats for DB: ORACLEInstance: ORACLESnaps: 19 -21
->ordered by Tablespace, File
Tablespace
Filename
------------------------ ----------------------------------------------------

AvAv Av
AvBuffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/sWaits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
588 07.714.6
40
0
REPORT_DAT
/dev/disk1/dsk33h
286 0 15.812.1 430
0

/dev/disk1/dsk34b
482 0 12.411.0
50
0

/dev/disk1/dsk34c
346 0 17.5 9.6 110
0

/dev/disk1/dsk34d
1,517 09.4 3.0
2020
1 20.0

/dev/disk1/dsk34e
247 0 21.213.0
40
0

/dev/disk1/dsk34f
486 0 14.3 7.1
40
36.7

/dev/disk1/dsk34g
238 0 21.513.6
40
1 10.0

/dev/disk1/dsk34h
217 0 23.214.9
40
1990.0

/dev/disk1/dsk35b

12 0 83.3 1.0
40
0

/dev/disk1/dsk35c
20,851 31.8 1.0
40
0

/dev/disk1/dsk35d
32,126 41.7 1.0
40
0

/dev/disk1/dsk35e
30,462 41.8 1.0
40
0

/dev/disk1/dsk35f
12,125 21.2 1.0
40
0

/dev/disk1/dsk35g
2,165 04.1 1.0
40
0

/dev/disk1/dsk35h

12 0666.7 1.0
40
0

/dev/disk1/dsk36b
373 0 22.4 9.2
40 935.1

/dev/disk1/dsk36c
133 0 52.624.3
40
0

/dev/disk1/dsk36d
146 0 49.922.4
40
0

/dev/disk1/dsk36e
132 0 54.319.6
40
0

/dev/disk1/dsk36f
14,147 22.3 1.6
40
0

/dev/disk1/dsk36g
19,653 32.2 1.8
17606852.1

/dev/disk1/dsk36h
2,829 06.0 3.2 580
0

/dev/disk1/dsk37b
21,200 34.2 1.1
90 11,9285.2

/dev/disk1/dsk37c
9,925 15.0 1.3
403108.7

/dev/disk1/dsk37d
2,960 07.8 2.0
1680
0

/dev/disk1/dsk37e
File IO Stats for DB: ORACLEInstance: ORACLESnaps: 19 -21
->ordered by Tablespace, File
Tablespace
Filename
------------------------ ----------------------------------------------------

AvAv Av
AvBuffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/sWaits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
56,336 85.8 1.1
91004,7895.8
REPORT_DAT
/dev/disk1/dsk37f
4,607 16.9 1.6 340
33.3

/dev/disk1/dsk37g
961 0 14.8 4.1 100
33.3

/dev/disk1/dsk37h
11,991 25.6 1.2
2070 327.2

/dev/disk1/dsk39b
673 0 18.1 7.3 130
0

/dev/disk1/dsk39c
338 0 28.412.0 130
45.0

/dev/disk1/dsk39d
149 0 57.826.0
40
0

/dev/disk1/dsk39e
3,412 05.2 2.1
402,5083.3

/dev/disk1/dsk39f
145 0 55.026.7
40
0

/dev/disk1/dsk39g
145 0 54.626.7
40
0

/dev/disk1/dsk39h
284 0 30.514.1
50
0

/dev/disk1/dsk41b
294 0 29.813.7
40
0

/dev/disk1/dsk41c
234 0 35.016.9
40
0

/dev/disk1/dsk41d
236 0 43.516.8 200
0

/dev/disk1/dsk41e
286 0 36.714.0
40
0

/dev/disk1/dsk41f
433 0 26.4 9.6
40
0

/dev/disk1/dsk41g
555 0 21.4 7.7
40
0

/dev/disk1/dsk41h
229 0 40.617.2
40
0

/dev/disk1/dsk44b
692 0 13.6 6.4
40
0

/dev/disk1/dsk44c
151 0 58.925.6
40
0

/dev/disk1/dsk44d
176 0 51.022.1
40
0

/dev/disk1/dsk44e
9,649 11.9 1.4
6690
0

/dev/disk1/dsk44f
233 0 39.222.3
40
0

/dev/disk1/dsk44g
7,728 12.8 1.6 4605452.3

/dev/disk1/dsk44h
1,260 09.9 4.9
90
0

/dev/disk1/dsk45b
4,628 13.6 2.1
40
0

/dev/disk1/dsk45c
File IO Stats for DB: ORACLEInstance: ORACLESnaps: 19 -21
->ordered by Tablespace, File
Tablespace
Filename
------------------------ ----------------------------------------------------

AvAv Av
AvBuffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/sWaits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
9,082 16.5 1.5 5402545.2
REPORT_DAT
/dev/disk1/dsk45d
193 0 42.926.7
40
0

/dev/disk1/dsk45e
183 0 44.221.3
40
36.7

/dev/disk1/dsk45f
11,406 24.0 1.4 7505,3313.9

/dev/disk1/dsk45g
4,709 15.9 1.8 400 136.9

/dev/disk1/dsk45h
55,875 84.9 1.1
73404,6286.2

/dev/disk1/dsk47b
77,149114.2 1.01,28103,2965.4

/dev/disk1/dsk47c
10,719 14.1 1.3 840
72.9

/dev/disk1/dsk47d
785 0 15.9 5.7 270 20 10.5

/dev/disk1/dsk47e
4,221 17.5 1.9
5810
1 10.0

/dev/disk1/dsk47f
4,589 17.5 1.8
8310 115.5

/dev/disk1/dsk47g
6,166 16.2 1.8
5510
0

/dev/disk1/dsk47h
872 0 10.3 5.3
401051.0
REPORT_INDX
/dev/disk1/dsk29b
448 0 10.3 1.0
5400
0

/dev/disk1/dsk29c
1,973 07.2 1.03,5640
0

/dev/disk1/dsk29d
156 0 17.1 1.0 700
0

/dev/disk1/dsk29e
109 0 21.7 1.0 670
1 10.0

/dev/disk1/dsk29f

54 0 34.3 1.0 540
0

/dev/disk1/dsk29g

17 0 80.0 1.0 110
0

/dev/disk1/dsk29h

47 0 42.6 1.0 160
0

/dev/disk1/dsk31b

67 0 30.6 1.0 400
0

/dev/disk1/dsk31c

49 0 35.7 1.0 200
25.0

/dev/disk1/dsk31d

84 0 21.9 1.0 260
0

/dev/disk1/dsk31e

40 0 34.3 1.0 370
0

/dev/disk1/dsk31f
163 0 14.0 1.0
1510
0

/dev/disk1/dsk31g
4,275 17.1 1.0
33602615.7
File IO Stats for DB: ORACLEInstance: ORACLESnaps: 19 -21
->ordered by Tablespace, File
Tablespace
Filename
------------------------ ----------------------------------------------------

AvAv Av
AvBuffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/sWaits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
REPORT_INDX
/dev/disk1/dsk31h
178 0 26.7 1.0 690
0

/dev/disk1/dsk38b
413 0 15.6 1.0
4330
0

/dev/disk1/dsk38c
1,350 0 10.0 1.0
7730
0

/dev/disk1/dsk38d
1,302 09.4 1.0
8510
0

/dev/disk1/dsk38e
215 0 17.7 1.0 250 180.6

/dev/disk1/dsk38f
18,823 30.7 1.0
3670
0

/dev/disk1/dsk38g
2,138 08.9 1.02,5840
20.0

/dev/disk1/dsk38h
28,789 41.1 1.01,17207441.3

/dev/disk1/dsk40b
148 0 46.1 1.0
1130
0

/dev/disk1/dsk40c
149 0 45.9 1.0 990
0

/dev/disk1/dsk40d
263 0 37.9 1.0
2220
1 10.0

/dev/disk1/dsk40e
598 0 19.9 1.0
6630
2 15.0

/dev/disk1/dsk40f
12,114 21.2 1.0
3050
0

/dev/disk1/dsk40g
1,352 0 12.6 1.01,2080
0

/dev/disk1/dsk40h
2,480 09.5 1.02,6000
0

/dev/disk1/dsk48b
3,315 08.6 1.01,2770 534.7

/dev/disk1/dsk48c
1,137 0 10.8 1.0
3120
0

/dev/disk1/dsk48d
4,490 13.9 1.0
8950
0

/dev/disk1/dsk48e
2,172 07.6 1.0
3460
0

/dev/disk1/dsk48f
2,445 06.6 1.0
2530
0

/dev/disk1/dsk48g
589 0 16.2 1.0 690
0

/dev/disk1/dsk48h
271 0 30.8 1.0
1390
0

/dev/disk1/dsk49b
573 0 17.7 1.0
6220
1 10.0

/dev/disk1/dsk49c
268 0 28.6 1.0 220
0

/dev/disk1/dsk49d
418 0 21.3 1.0
3280
0

/dev/disk1/dsk49e
194 0 37.9 1.0 160
0

千问 · 2014-5-9 08:24:37

File IO Stats for DB: ORACLEInstance: ORACLESnaps: 19 -21
->ordered by Tablespace, File
Tablespace
Filename
------------------------ ----------------------------------------------------

AvAv Av
AvBuffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/sWaits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
REPORT_INDX
/dev/disk1/dsk49f
2,435 04.9 1.0
9730
0

/dev/disk1/dsk49g
5,337 14.2 1.02,3550
0

/dev/disk1/dsk49h
3,781 16.7 1.02,2200
0

/dev/disk1/dsk50b
1,274 0 10.7 1.01,4170
0

/dev/disk1/dsk50c
1,805 09.8 1.01,6440
0

/dev/disk1/dsk50d
574 0 16.6 1.0
8720
0

/dev/disk1/dsk50e
2,682 05.9 1.01,4740
0

/dev/disk1/dsk50f
1,693 0 10.3 1.01,2660
0

/dev/disk1/dsk50g
5,438 15.9 1.01,6110
0

/dev/disk1/dsk50h
771 0 14.2 1.0
9350
0

/dev/disk1/dsk51b
592 0 15.8 1.0
4730
0

/dev/disk1/dsk51c
2,645 08.2 1.02,8400
0

/dev/disk1/dsk51d
3,185 08.6 1.03,9531
25.0

/dev/disk1/dsk51e
1,798 09.2 1.01,7410
68.3

/dev/disk1/dsk51f
2,155 08.4 1.01,3260
74.3

/dev/disk1/dsk51g
3,353 06.9 1.0
84601646.6

/dev/disk1/dsk51h
23,624 36.0 1.01,28401,7096.7

/dev/disk1/dsk52b
12,498 26.1 1.0
19406985.9

/dev/disk1/dsk52c
1,651 09.3 1.01,6300
0

/dev/disk1/dsk52d
2,450 06.4 1.0
9910
0

/dev/disk1/dsk52e
666 0 12.1 1.0
3890
0

/dev/disk1/dsk52f
9,070 14.8 1.0
93003,7255.1

/dev/disk1/dsk52g
1,790 07.6 1.01,1460
56.0

/dev/disk1/dsk52h
4,042 13.3 1.0
52402101.7

/dev/disk1/dsk59b
902 0 10.9 1.0
8070
0

/dev/disk1/dsk59c
282 0 18.7 1.0
3470
0
File IO Stats for DB: ORACLEInstance: ORACLESnaps: 19 -21
->ordered by Tablespace, File
Tablespace
Filename
------------------------ ----------------------------------------------------

AvAv Av
AvBuffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/sWaits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
REPORT_INDX
/dev/disk1/dsk59d
459 0 13.8 1.0
5170
4 10.0

/dev/disk1/dsk59e
1,348 09.2 1.01,1000
47.5

/dev/disk1/dsk59f
2,712 05.9 1.0
7270
2 15.0

/dev/disk1/dsk59g
6,799 14.0 1.01,0110
0

/dev/disk1/dsk59h
2,299 02.8 1.0
3590
0

/dev/disk1/dsk60b
2,200 07.6 1.0
7780 826.0

/dev/disk1/dsk60c
2,710 07.9 1.01,0600 634.8

/dev/disk1/dsk60d
2,174 07.2 1.0
7700 465.9

/dev/disk1/dsk60e
4,149 17.0 1.01,43701116.1

/dev/disk1/dsk60f
2,797 07.0 1.01,1580 556.2

/dev/disk1/dsk60g
3,157 07.3 1.01,2010 975.7

/dev/disk1/dsk60h
724 07.7 1.0
4540 206.5
SYSTEM
/dev/disk1/dsk24b
1,012 06.9 2.1 520
4 15.0
TEMP
/dev/disk1/dsk25e
1,181 0 18.153.6
5270
0
TOOLS
/dev/disk1/dsk25b

4 0467.5 1.0
40
0
USERS
/dev/disk1/dsk24e
298 0 11.4 1.0
40
0

-------------------------------------------------------------
Buffer Pool Statistics for DB: ORACLEInstance: ORACLESnaps: 19 -21
-> Pools D: default pool,K: keep pool,R: recycle pool

FreeWrite Buffer
BufferConsistentPhysical PhysicalBuffer Complete Busy
PGets
Gets Reads Writes WaitsWaitsWaits
- ----------- ------------- ----------- ---------- ------- -------- ----------
D 6,063,023 271,992,331 5,176,164128,746 00 68,006

-------------------------------------------------------------

Buffer wait Statistics for DB: ORACLEInstance: ORACLESnaps: 19 -21
-> ordered by wait time desc, waits desc

Tot WaitAvg
Class
WaitsTime (cs) Time (cs)
------------------ ----------- ---------- ---------
data block
67,865 53,687 1
undo block
83 25 0
undo header
37
8 0

-------------------------------------------------------------

Enqueue activity for DB: ORACLEInstance: ORACLESnaps: 19 -21
-> ordered by waits desc, gets desc
Enqueue
GetsWaits
---------- ------------ ----------
TM
22,5744,152
US
744386
CF
408161
HW
89 28
TX
38,139 23
WL
8
4
DV
7
4
DR
3
3

-------------------------------------------------------------
Rollback Segment Stats for DB: ORACLEInstance: ORACLESnaps: 19 -21
->A high value for "Pct Waits" suggests more rollback segments may be required
Trans TablePct Undo Bytes
RBS No Gets Waits WrittenWrapsShrinksExtends
------ ------------ ------- --------------- -------- -------- --------
0
3.00.00
0000
1 73,624.00.0018,703,930 1000
2 79,622.00.0021,007,626 1200
3 79,462.00.0021,264,022 1100
4 79,539.00.0020,368,094 1000
5 89,350.00.0021,256,958 1100
6 84,738.00.0023,467,814 1300
7 82,986.00.0018,781,308 1000
8 77,036.00.0021,393,698 1200
9 79,580.00.0020,088,898 1000
10 84,607.00.0021,891,308 1100
11 80,071.00.0020,877,004 1100
12 12,754.00.00 3,283,402200
13 81,957.00.0022,002,566 1100
14 75,969.00.0020,597,436 1100
20 83,973.00.0020,305,728 1100

-------------------------------------------------------------
Rollback Segment Storage for DB: ORACLEInstance: ORACLESnaps: 19 -21
->Optimal Size should be larger than Avg Active
RBS NoSegment SizeAvg ActiveOptimal SizeMaximum Size
------ --------------- --------------- --------------- ---------------
0 811,008 8,192
811,008
110,477,568 2,159,30910,485,76031,449,088
210,477,568 2,162,57510,485,760 153,083,904
310,477,568 2,145,41010,485,76044,032,000
410,477,568 2,191,61910,485,760 155,181,056
510,477,568 2,192,26610,485,760 153,083,904
610,477,568 2,168,29510,485,760 159,375,360
710,477,568 2,184,46410,485,760 150,986,752
810,477,568 2,164,46610,485,760 423,616,512
910,477,568 2,181,84510,485,760 417,325,056
1010,477,568 2,154,60310,485,760 419,422,208
1110,477,568 2,171,50110,485,76090,169,344
1212,574,720 2,541,49010,485,760 421,519,360
1310,477,568 2,143,55810,485,760 423,616,512
1410,477,568 2,128,87810,485,760 153,083,904
2010,477,568 2,250,51710,485,76041,934,848

-------------------------------------------------------------
Latch Activity for DB: ORACLEInstance: ORACLESnaps: 19 -21
->"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

PctAvg
Pct

Get
Get Slps NoWait NoWait
Latch Name
RequestsMiss/Miss Requests Miss
----------------------------- -------------- ------ ------ ------------ ------
KCL freelist latch
11,850,2560.10.0
0
KCL lock element parent latch 22,574,1430.10.5
0
KCL name table latch
5,254,0760.40.8
0
Token Manager
30,2190.0
1100.0
active checkpoint queue latch100,1080.0
0
archive control
160.0
0
archive process latch
160.0
0
batching SCNs
10,308,2040.10.0
0
cache buffer handles
920.0
0
cache buffers chains
594,872,7170.00.5 10,296,9090.0
cache buffers lru chain 36,988,4240.40.36,013,1280.3
channel handle pool latch
7,8880.0
0
channel operations parent lat 11,8370.0
0
checkpoint queue latch
2,165,6800.00.3
0
dlm cr request queue latch
120.0
0
dlm deadlock list
18,1480.0
90.0
dlm domain lock latch
3,9480.0
0
dlm domain lock table latch
124,5490.0
0
dlm group lock latch
3,9480.0
0
dlm group lock table latch10,478,5950.00.9
0
dlm lock table freelist 20,988,1730.60.3
0
dlm process hash list
18,1450.0
0
dlm process table freelist
7,8880.0
0
dlm recovery domain record la
1,8570.0
0
dlm resource hash list
22,539,2090.2 99.84,074,8890.0
dlm resource scan list
920.0
0
dlm resource table freelist 12,447,8540.40.4491,3630.1
dlm shared communication latc6,883,7860.40.2
0
dlm timeout list
2,674,4110.00.5
1710.0
dml lock allocation
45,1430.00.0
0
enqueue hash chains
18,946,3590.30.4
0
enqueues
19,780,4070.30.1
0
event group latch
3,9490.0
0
file number translation table
200.0
0
global transaction
29,109,5690.0
0
global tx free list
96,9810.00.2
0
global tx hash mapping
4,963,8790.00.5
0
job_queue_processes parameter
5700.0
0
ktm global data
240.0
0
latch wait list
14,2050.20.1 14,2890.2
library cache
11,878,3320.20.99,9410.5
library cache load lock
1200.0
0
list of block allocation
64,8550.0
0
loader state object freelist
1240.0
0
longop free list
680.0
0
messages
1,257,1600.00.1
0
multiblock read objects
6,618,5750.20.1
0
name-service namespace bucket 66,8730.0
0
name-service pending queue
5,2440.0
0
name-service request queue
72,0350.0
0
Latch Activity for DB: ORACLEInstance: ORACLESnaps: 19 -21
->"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

PctAvg
Pct

Get
Get Slps NoWait NoWait
Latch Name
RequestsMiss/Miss Requests Miss
----------------------------- -------------- ------ ------ ------------ ------
ncodef allocation latch
5700.0
0
process allocation
3,9490.0
3,9490.0
process group creation
7,8880.0
0
process parent latch
21,159,2890.0 92.6
0
redo allocation
2,153,7730.00.1
0
redo writing
375,7180.10.6
0
row cache objects
8,914,7860.00.8
0
sequence cache
14,9720.0
0
session allocation
229,6650.10.9
0
session idle bit
5,792,5590.00.0
0
session switching
5700.0
0
shared pool
464,2150.00.9
0
sort extent pool
4850.0
0
transaction allocation
217,9430.00.1
0
transaction branch allocation736,1860.00.1
0
undo global data
2,414,6750.00.1
0
user lock
15,8840.01.0
0

-------------------------------------------------------------
Latch Sleep breakdown for DB: ORACLEInstance: ORACLESnaps: 19 -21
-> ordered by misses desc

Get
Spin &
Latch Name
Requests MissesSleeps Sleeps 1->4
-------------------------- -------------- ----------- ----------- ------------
cache buffers lru chain36,988,424 151,14843,948 108781/40833

/1487/47/0
cache buffers chains
594,872,717 125,10568,728 58161/65213/

1682/49/0
dlm lock table freelist20,988,173 124,73040,501 88617/33090/

2981/42/0
enqueues
19,780,40760,191 8,809 51390/8793/8

/0/0
enqueue hash chains
18,946,35948,76920,284 29162/18951/

636/20/0
dlm resource table freelis 12,447,85448,01520,643 28741/17910/

1359/5/0
dlm resource hash list 22,539,20946,026 4,591,949 659/2653/398

83/2831/0
KCL lock element parent la 22,574,14331,99315,951 17090/13953/

853/97/0
dlm shared communication l6,883,78628,041 5,493 23354/3992/6

89/6/0
KCL name table latch
5,254,07622,07017,785 6943/12716/2

184/227/0
library cache
11,878,33220,08417,441 7079/9539/27

17/749/0
KCL freelist latch
11,850,25613,799 553 13253/539/7/

0/0
multiblock read objects 6,618,57511,613 1,662 9969/1626/18

/0/0
process parent latch 21,159,289 6,502 602,253 1501/3741/10

83/177/0
batching SCNs
10,308,204 5,215 152 5064/150/1/0

/0
row cache objects
8,914,786 2,206 1,685 572/1584/49/

1/0
dlm group lock table latch 10,478,595 1,203 1,118 472/427/301/

3/0
dlm timeout list
2,674,411 947 496 731/109/98/9

/0
session idle bit
5,792,559 644
16 628/16/0/0/0
undo global data
2,414,675 582
73 509/73/0/0/0
messages
1,257,160 520
46 476/42/2/0/0
redo allocation
2,153,773 422
41 381/41/0/0/0
redo writing
375,718 317 182 135/182/0/0/

0
session allocation
229,665 263 237 31/227/5/0/0
shared pool
464,215 217 196 80/89/43/5/0
transaction branch allocat736,186 198
14 184/14/0/0/0
checkpoint queue latch
2,165,680
78
22 56/22/0/0/0
latch wait list
14,205
30 3 28/1/1/0/0
transaction allocation
217,943
24 2 22/2/0/0/0
global tx free list
96,981
11 2 9/2/0/0/0
global tx hash mapping
4,963,879 8 4 4/4/0/0/0
user lock
15,884 1 1 0/1/0/0/0

-------------------------------------------------------------
Latch Miss Sources for DB: ORACLEInstance: ORACLESnaps: 19 -21
-> only latches with sleeps are shown
-> ordered by name, sleeps desc

NoWait
Waiter
Latch Name
Where
Misses SleepsSleeps
------------------------ -------------------------- ------- ---------- -------
KCL freelist latch kclfadd
0287 392
KCL freelist latch kclfrem
0230 128
KCL freelist latch kclfget
0 3633
KCL lock element parentkclulb
07,901 3,242
KCL lock element parentkclnloc
06,673 1,697
KCL lock element parentkclfget
01,115 599
KCL lock element parentKCLUNLNK
0158 2,801
KCL lock element parentkclpbi: while down convert 0 88 7,335
KCL lock element parentkclccr
0
5 256
KCL lock element parentkclsfla
0
5 6
KCL lock element parentkclebs
0
3 4
KCL lock element parentkclswc
0
111
KCL name table latch kclnfnd
0 17,77517,775
batching SCNs
kcsl01
0122 111
batching SCNs
kcsl02
0 2841
batching SCNs
kcsl04
0
2 0
cache buffers chains kcbgtcr: kslbegin
0 33,12751,005
cache buffers chains kcbrls: kslbegin
0 24,30514,928
cache buffers chains kcbzwb
04,106 791
cache buffers chains kcbzib: multi-block read:03,135 0
cache buffers chains kcbzgb: scan from tail. no 02,085 0
cache buffers chains kcbchg: kslbegin: bufs not 01,259 445
cache buffers chains kcbgcur: kslbegin
0315 455
cache buffers chains kcbzib: finish free bufs 0131 311
cache buffers chains kcbget: pin buffer
0122 222
cache buffers chains kcbchg: kslbegin: call CR0 45 341
cache buffers chains kcbbwb1
0 25 7
cache buffers chains kcbbxsv
0 2454
cache buffers chains kcbgtcr
0 13 1
cache buffers chains kcbnlc
0 1145
cache buffers chains kclebs: check
0
9 1
cache buffers chains kcbget: exchange rls
0
437
cache buffers chains kcbget: exchange
0
144
cache buffers chains kcbzib: exchange rls
0
1 2
cache buffers lru chainkcbzgb: multiple sets nowa 0 37,012 0
cache buffers lru chainkcbzar: KSLNBEGIN
05,60634,469
cache buffers lru chainkcbzgm
0624 9,105
cache buffers lru chainkcbbiop: lru scan
039912
cache buffers lru chainkcbzgb: posted for free bu 026455
cache buffers lru chainkcbgtcr:CR Scan:KCBRSKIP 0 12 181
cache buffers lru chainkcbbwlru
0
3 6
cache buffers lru chainkcbbioc
0
261
checkpoint queue latch kcbklbc: Link buffer into0 15 0
checkpoint queue latch kcbk0rrd: update recovery0
7 1
cost function
kzulrl
0
1 0
dlm group lock table lat kjgalk: move a lock from p 0924 551
dlm group lock table lat kjgdlk: move a lock from g 0193 567
dlm lock table freelistkjlalc: lock allocation
0 34,725 5,368
dlm lock table freelistkjgalk: move lock from par 04,824 7,659
dlm lock table freelistkjgdlk: move lock to paren 057615,738
dlm lock table freelistkjlfr: remove lock from pa 034311,734
dlm resource hash list kjuocl: open cr lock reque 04,555,597 0
dlm resource hash list kjrrmas1: lookup master no 0 28,772 0

千问 · 2014-5-9 08:24:37

Latch Miss Sources for DB: ORACLEInstance: ORACLESnaps: 19 -21
-> only latches with sleeps are shown
-> ordered by name, sleeps desc

NoWait
Waiter
Latch Name
Where
Misses SleepsSleeps
------------------------ -------------------------- ------- ---------- -------
dlm resource hash list kjucvl: open cr lock reque 07,425 0
dlm resource hash list kjskchcv: convert on shado 0 9515
dlm resource hash list kjrlck: lock resource
0 25 #######
dlm resource hash list kjrref: find matched resou 0
9 141
dlm resource hash list kjlrlr: remove lock from r 0
722
dlm resource hash list kjruch: move resource from 0
7 0
dlm resource hash list kjxcvr: handle convert req 0
610
dlm resource table freel kjralc: resource allocatio 0 11,526 4,078
dlm resource table freel kjrchc: reget table latch05,452 0
dlm resource table freel kjrm2c: move resource to L 02,09110,127
dlm resource table freel kjrchc: remove cached reso 01,021 0
dlm resource table freel kjrfr: remove from resourc 0377 6,438
dlm resource table freel kjrchc2: remove cached res 0167 0
dlm shared communication kjccqmg: queue message 02,329 3,019
dlm shared communication kjctcsnd 2: lock comm latc 01,313 687
dlm shared communication kjcsrmg: extract seq numbe 01,260 1,194
dlm shared communication kjctssb: send buffered mes 0305 155
dlm shared communication kjctssmb: get comm latch b 0286 438
dlm timeout list kjteq: insert into timer q 0371 157
dlm timeout list kjtdq: remove from timer q 0125 339
enqueue hash chainsksqgtl3
09,877 4,908
enqueue hash chainsksqcnl
06,40011,887
enqueue hash chainsksqrcl
03,910 3,418
enqueue hash chainsksqcmi: if lk mode not req 0 6028
enqueue hash chainsksqcmi: if lk mode request 0 3543
enqueue hash chainsksqcmi: get hash chain lat 0
1 0
enqueues
ksqgel: create enqueue 05,329 3,473
enqueues
ksqdel
02,145 1,061
enqueues
ksqgtl2
01,201 2,026
enqueues
ksqrcl
0134 2,195
global tx free listk2gfegte
0
1 1
global tx free listk2ghashdel
0
1 1
global tx hash mapping K2GTBlatch
0
4 4
latch wait list
kslfre
17
2 3
latch wait list
kslges
14
1 0
library cache
kglpnal: child: alloc spac 03,817 2,396
library cache
kglpnc: child
03,512 4,871
library cache
kglhdgn: child:
02,650 1,426
library cache
kglupc: child
02,478 5,058
library cache
kgllkdl: child: cleanup
01,397 200
library cache
kglhdgc: child:
01,026 747
library cache
kglget: child: KGLDSBRD
061140
library cache
kglpnal: child: before pro 0520 491
library cache
kglic
032049
library cache
kgllkdl: child: free pin 0112 1,666
library cache
kglget: child: KGLDSBYD
0 8055
library cache
kglpnp: child
0 5977
library cache
kglsca: parent
0 33 0
library cache
kglrtl
0 23 2
library cache
kgldti: 2child
0 2117
library cache
kglpin
0 1263
library cache
kgllkdl: child: multiinsta 0
830
library cache
kgllkal: child: multiinsta 0
734
Latch Miss Sources for DB: ORACLEInstance: ORACLESnaps: 19 -21
-> only latches with sleeps are shown
-> ordered by name, sleeps desc

NoWait
Waiter
Latch Name
Where
Misses SleepsSleeps
------------------------ -------------------------- ------- ---------- -------
library cache
kglobpn: child:
0
614
library cache
kglati
0
3 7
library cache
kgldte: child 0
0
3 106
library cache
kglpnal: child: check gran 0
2 4
library cache
kglobld: child:
0
112
messages
ksarcv: after wait
0 28 6
messages
ksaamb: after wakeup
0 1629
messages
ksarcv
0
211
multiblock read objectskcbzib: MBRFRE
0967 802
multiblock read objectskcbzib: MBRGET
0695 860
process parent latch kjata
0602,137 #######
process parent latch kjskchcv: set converting 0 69 1,459
process parent latch kjlalc
0 49 2,666
redo allocation
kcrfwr: redo allocation
0 2939
redo allocation
kcrfwi: before write
0 10 1
redo allocation
kcrfwi: more space
0
2 1
redo writing
kcrfsr
0170 3
redo writing
kcrfwi: after write
0
8 0
redo writing
kcrfss
0
3 178
redo writing
kcrfwcr
0
1 1
row cache objectskqrpre: find obj
01,607 987
row cache objectskqreqd
0 36 680
row cache objectskqreqd: rel enqueue
0 35 7
row cache objectskqrbgl
0
4 5
row cache objectskqrso
0
2 0
session allocation ksufap: active sessions
0221 2
session allocation ksucri
0 11 165
session allocation ksuxds: KSUSFCLC not set 0
3 2
session allocation ksucrp
0
2 6
session idle bit ksupuc: set busy
0 13 7
session idle bit ksupuc: clear busy
0
2 9
session idle bit ksuxds
0
1 0
shared pool
kghfrunp: clatch: nowait 0723 0
shared pool
kghfrunp: alloc: clatch no 0 82 0
shared pool
kghupr1
0 53 115
shared pool
kghalo
0 4563
shared pool
kghfnd: req scan
0
5 0
shared pool
kghfrunp: clatch: wait 0
463
shared pool
kghfnd: get next extent
0
3 0
shared pool
kghfre
0
313
shared pool
kghfnd: resv scan
0
3 0
shared pool
kghalp
0
1 3
shared pool
kghfen: not perm alloc cla 0
1 1
transaction allocation ktcdso
0
2 2
transaction branch alloc ktcbba
0
9 3
transaction branch alloc ksupuc
0
411
transaction branch alloc ktcbod
0
1 0
undo global data ktudba: KSLBEGIN
0 4263
undo global data ktubnd
0 28 8
undo global data ktudnx: KSLBEGIN
0
3 2

-------------------------------------------------------------
Dictionary Cache Stats for DB: ORACLEInstance: ORACLESnaps: 19 -21
->"Pct Misses"should be very low ("Cache Usage" is the number of cache entries being used
->"Pct SGA" is the ratio of usage to allocated size for that cache

Get Pct Scan PctModFinalPct
Cache
Requests Miss RequestsMissReqUsageSGA
---------------------- ------------ ------ -------- ----- -------- ------ ----
dc_constraints
0
0
0182 93
dc_database_links
79,5950.00
0 16 94
dc_files
0
0
000
dc_free_extents
0
0
0377 43
dc_global_oids
0
0
000
dc_histogram_data
0
0
000
dc_histogram_data_valu
0
0
000
dc_histogram_defs 2,266,6710.00
01,869100
dc_object_ids
271,7710.00
0558 99
dc_objects
9,2910.10
3880100
dc_outlines
0
0
000
dc_profiles
3,9510.00
01 20
dc_rollback_segments
1,4890.00
0 33 79
dc_segments
13,7730.00
0462100
dc_sequence_grants
0
0
000
dc_sequences
2081.00
208 15 88
dc_synonyms
1300.00
0133 99
dc_tablespace_quotas
0
0
06 32
dc_tablespaces
520.00
0 30 79
dc_used_extents
0
0
0137 42
dc_user_grants
39,7530.00
0 24 96
dc_usernames
8,3720.00
0 36 80
dc_users
307,3640.00
0 29 78
ifs_acl_cache_entries
0
0
000

-------------------------------------------------------------

Library Cache Activity for DB: ORACLEInstance: ORACLESnaps: 19 -21
->"Pct Misses"should be very low

Get PctPinPct
Invali-
Namespace RequestsMiss Requests Miss Reloadsdations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY
13,0740.0 13,0770.0
30
CLUSTER
90.0
100.0
00
INDEX
0
0
00
OBJECT
0
0
00
PIPE
0
0
00
SQL AREA
70,0853.45,248,5910.14311
TABLE/PROCEDURE 13,6060.1 96,2090.1 270
TRIGGER
110.0
11 18.2
20

-------------------------------------------------------------
SGA Memory Summary for DB: ORACLEInstance: ORACLESnaps: 19 -21
SGA regions
Size in Bytes
------------------------------ ----------------
Database Buffers
838,860,800
Fixed Size
103,396
Redo Buffers
10,502,144
Variable Size
663,953,408

----------------
sum
1,513,419,748

-------------------------------------------------------------

SGA breakdown difference for DB: ORACLEInstance: ORACLESnaps: 19 -21
PoolName
Begin valueEnd valueDifference
----------- ------------------------ -------------- -------------- -----------
java pool free memory
20,971,520 20,971,520 0
large poolfree memory
614,400614,400 0
shared pool DML locks
979,104979,104 0
shared pool KGFF heap
142,960142,960 0
shared pool KGK heap
19,896 19,896 0
shared pool KQLS heap
1,213,0801,140,064 -73,016
shared pool PL/SQL DIANA
1,492,2481,448,496 -43,752
shared pool PL/SQL MPCODE
4,461,5604,656,384 194,824
shared pool PL/SQL PPCODE
70,432 45,304 -25,128
shared pool PL/SQL SOURCE
15,792 15,888
96
shared pool PLS non-lib hp
2,136
2,136 0
shared pool State objects
122,152,656122,152,656 0
shared pool db_block_buffers
27,033,600 27,033,600 0
shared pool db_block_hash_buckets 3,465,2643,465,264 0
shared pool db_handles
1,056,0001,056,000 0
shared pool dictionary cache
3,239,9203,247,768 7,848
shared pool dlm process array
1,076,0961,076,096 0
shared pool dlm shared memory
33,521,147 33,521,147 0
shared pool enqueue_resources
639,392639,392 0
shared pool event statistics per ses4,600,4004,600,400 0
shared pool fixed allocation callbac
2,072
2,072 0
shared pool free memory
53,748,504 57,548,416 3,799,912
shared pool gc_*
17,612,800 17,612,800 0
shared pool kclnb
614,424614,424 0
shared pool ktlbk state objects
780,952780,952 0
shared pool library cache
99,067,520 93,830,944-5,236,576
shared pool miscellaneous
5,828,8325,913,71284,880
shared pool processes
1,392,0001,392,000 0
shared pool sessions
3,222,4003,222,400 0
shared pool sql area
252,631,528253,922,008 1,290,480
shared pool table columns
25,752 23,576-2,176
shared pool table definiti
5,336
4,608-728
shared pool transactions
2,214,6402,214,640 0
shared pool trigger inform
896
896 0
shared pool view columns d
2,784
2,784 0

db_block_buffers
838,860,800838,860,800 0

fixed_sga
83,076 83,076 0

log_buffer
10,485,760 10,485,760 0

-------------------------------------------------------------
init.ora Parameters for DB: ORACLEInstance: ORACLESnaps: 19 -21

End value
Parameter Name
Begin value
(if different)
----------------------------- --------------------------------- --------------
_ipc_net
ics0
_lm_dd_interval
1
background_dump_dest
/ora/oracle8i/admin/ORACLE_P/bdu
compatible
8.1.7
control_files
/dev/disk1/dsk21b, /dev/eva_s
core_dump_dest
/ora/oracle8i/admin/ORACLE_P/cdu
cursor_sharing
exact
db_block_buffers
102400
db_block_lru_latches
8
db_block_size
8192
db_file_multiblock_read_count 32
db_files
300
db_name
ORACLE
global_names
FALSE
ifile
/ora/oracle8i/app/oracle/product/
java_pool_size
20971520
job_queue_processes 6
large_pool_size
614400
lm_locks
193906
lm_ress
177359
log_archive_dest_1
LOCATION=/arc_p MANDATORY
log_archive_format
arch_%t_%s.arc
log_archive_start
TRUE
log_buffer
10485760
log_checkpoint_interval 999999999
log_checkpoint_timeout0
max_enabled_roles
30
open_cursors
8000
open_links
10
optimizer_mode
RULE
parallel_server
TRUE
processes
1200
rollback_segments
RBS01, RBS02, RBS03, RBS04, RBS05
service_names
ORACLE
session_cached_cursors50
shared_pool_size
419430400
sort_area_retained_size 5242880
sort_area_size
20971520
thread
1
timed_statistics
TRUE
user_dump_dest
/ora/oracle8i/admin/ORACLE_P/udu
utl_file_dir
*

-------------------------------------------------------------
End of Report

麻烦各位大师了，比较长。烦指各位指教！

千问 · 2014-5-9 08:24:37

以附件上传，问题主要是一些sql没有写好。
SQL*Net message from dblink
是远程连接的表？

千问 · 2014-5-9 08:24:37

多谢大师，能说详细些吗？我想好好学学这个statspack。多谢！

千问 · 2014-5-9 08:24:37

Statspack的第一部分内容，也就是你没贴的那一部分，是非常重要的……
1。 DB Version没了
2。时间间隔没了
3。session数也没了

千问 · 2014-5-9 08:24:37

STATSPACK report for
DB Name DB IdInstance Inst Num Release OPS Host
------------ ----------- ------------ -------- ----------- --- ------------
ORACLE 3850037851 ORACLE
1 8.1.7.4.0 YES ORACLESERVER

Snap Id Snap TimeSessions

------- ------------------ --------
Begin Snap: 19 17-Mar-06 09:00:06226
End Snap: 21 17-Mar-06 11:00:02226
Elapsed:
119.93 (mins)