本报告详细分析了Oracle数据库实例的性能状况，包括主机配置、快照对比、缓存使用情况及实例恢复统计等关键信息，有助于理解数据库运行状态并进行性能调优。
STATSPACK report for
Database DB Id Instance Inst Num Startup Time Release RAC
~~~~~~~~ ----------- ------------ -------- --------------- ----------- ---
1242466141 orcl 1 30-3月 -10 22:2 10.2.0.3.0 NO
1
Host Name: LENOVO-THINK Num CPUs: 2 Phys Memory (MB): 2,043
~~~~
Snapshot Snap Id Snap Time Sessions Curs/Sess Comment
~~~~~~~~ ---------- ------------------ -------- --------- -------------------
Begin Snap: 1 30-3月 -10 23:12:40 17 3.6
End Snap: 4 30-3月 -10 23:21:48 17 5.1
Elapsed: 9.13 (mins)
Cache Sizes Begin End
~~~~~~~~~~~ ---------- ----------
Buffer Cache: 108M Std Block Size: 8K
Shared Pool Size: 140M Log Buffer: 6,825K
Load Profile Per Second Per Transaction
~~~~~~~~~~~~ --------------- ---------------
Redo size: 4,349.53 46,736.16
Logical reads: 20.93 224.94
Block changes: 10.33 110.98
Physical reads: 0.00 0.04
Physical writes: 1.18 12.63
User calls: 0.17 1.80
Parses: 2.57 27.59
Hard parses: 0.13 1.37
Sorts: 1.05 11.25
Logons: 0.02 0.24
Executes: 4.86 52.18
Transactions: 0.09
% Blocks changed per Read: 49.34 Recursive Call %: 99.49
Rollback per transaction %: 0.00 Rows per Sort: 40.26
Instance Efficiency Percentages
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.98 In-memory Sort %: 100.00
Library Hit %: 94.36 Soft Parse %: 95.02
Execute to Parse %: 47.13 Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 24.32 % Non-Parse CPU: 95.00
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 69.18 70.43
% SQL with executions>1: 58.99 63.05
% Memory for SQL w/exec>1: 57.65 63.73
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ------------ ----------- ------ ------
control file parallel write 182 2 12 41.8
CPU time 2 35.7
control file sequential read 641 1 1 13.3
log file parallel write 311 0 1 3.4
db file parallel write 207 0 1 2.9
-------------------------------------------------------------
Host CPU (CPUs: 2)
~~~~~~~~ Load Average
Begin End User System Idle WIO WCPU
------- ------- ------- ------- ------- ------- --------
3.17 4.53 92.31
Instance CPU
~~~~~~~~~~~~
% of total CPU for Instance: 0.26
% of busy CPU for Instance: 3.41
%DB time waiting for CPU - Resource Mgr:
Memory Statistics Begin End
~~~~~~~~~~~~~~~~~ ------------ ------------
Host Mem (MB): 2,042.9 2,042.9
SGA use (MB): 280.0 280.0
PGA use (MB): 25.2 24.7
% Host Mem used for SGA+PGA: 14.9 14.9
-------------------------------------------------------------
Time Model System Stats DB/Inst: ORCL/orcl Snaps: 1-4
-> Ordered by % of DB time desc, Statistic name
Statistic Time (s) % of DB time
----------------------------------- -------------------- ------------
sql execute elapsed time 3.6 93.0
DB CPU 1.9 49.7
parse time elapsed 0.8 19.5
hard parse elapsed time 0.7 18.7
PL/SQL compilation elapsed time 0.3 8.6
failed parse elapsed time 0.3 7.8
PL/SQL execution elapsed time 0.1 2.3
connection management call elapsed 0.0 .2
repeated bind elapsed time 0.0 .1
DB time 3.9
background elapsed time 3.3
background cpu time 0.9
-------------------------------------------------------------
Wait Events DB/Inst: ORCL/orcl Snaps: 1-4
-> s - second, cs - centisecond, ms - millisecond, us - microsecond
-> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)
Avg
%Time Total Wait wait Waits
Event Waits -outs Time (s) (ms) /txn
--------------------------------- ------------ ------ ---------- ------ --------
control file parallel write 182 0 2 12 3.6
control file sequential read 641 0 1 1 12.6
log file parallel write 311 0 0 1 6.1
db file parallel write 207 0 0 1 4.1
log file sync 17 0 0 4 0.3
db file sequential read 2 0 0 33 0.0
latch free 9 0 0 0 0.2
virtual circuit status 19 100 570 30014 0.4
Streams AQ: qmn slave idle wait 20 0 562 28102 0.4
Streams AQ: qmn coordinator idle 34 62 562 16531 0.7
jobq slave wait 183 95 547 2987 3.6
SQL*Net message from client 43 0 333 7738 0.8
-------------------------------------------------------------
Background Wait Events DB/Inst: ORCL/orcl Snaps: 1-4
-> %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)
Avg
%Time Total Wait wait Waits
Event Waits -outs Time (s) (ms) /txn
--------------------------------- ------------ ------ ---------- ------ --------
control file parallel write 182 0 2 12 3.6
log file parallel write 311 0 0 1 6.1
db file parallel write 207 0 0 1 4.1
events in waitclass Other 22 0 0 0 0.4
rdbms ipc message 1,999 87 4,384 2193 39.2
smon timer 2 100 600 ###### 0.0
Streams AQ: qmn slave idle wait 20 0 562 28102 0.4
Streams AQ: qmn coordinator idle 34 62 562 16531 0.7
pmon timer 183 100 545 2978 3.6
-------------------------------------------------------------
Wait Event Histogram DB/Inst: ORCL/orcl Snaps: 1-4
-> Total Waits - units: K is 1000, M is 1000000, G is 1000000000
-> % of Waits - column heading: <=1s is truly <1024ms, >1s is truly >=1024ms
-> % of Waits - value: .0 indicates value was <.05%, null is truly 0
-> Ordered by Event (idle events last)
Total ----------------- % of Waits ------------------
Event Waits <1ms <2ms <4ms <8ms <16ms <32ms <=1s >1s
-------------------------- ----- ----- ----- ----- ----- ----- ----- ----- -----
LGWR wait for redo copy 13 100.0
SQL*Net break/reset to cli 6 100.0
control file parallel writ 182 52.2 26.4 3.3 .5 2.2 12.6 2.2 .5
control file sequential re 641 92.5 3.9 .8 .2 1.9 .2 .6
db file parallel write 207 92.3 6.3 .5 1.0
db file sequential read 2 50.0 50.0
latch free 9 88.9 11.1
log file parallel write 311 96.8 .3 .6 .6 .3 1.3
log file sync 17 58.8 11.8 5.9 11.8 11.8
SQL*Net message from clien 43 48.8 11.6 7.0 7.0 2.3 2.3 4.7 16.3
SQL*Net message to client 43 100.0
SQL*Net more data from cli 1 100.0
Streams AQ: qmn coordinato 34 38.2 61.8
Streams AQ: qmn slave idle 20 100.0
dispatcher timer 10 100.0
jobq slave wait 183 .5 99.5
pmon timer 183 1.1 98.9
rdbms ipc message 1999 10.4 .8 .3 .3 .3 .1 27.8 60.2
smon timer 2 100.0
virtual circuit status 19 100.0
-------------------------------------------------------------
SQL ordered by CPU DB/Inst: ORCL/orcl Snaps: 1-4
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total DB CPU (s): 2
-> Captured SQL accounts for 14.0% of Total DB CPU
-> SQL reported below exceeded 1.0% of Total DB CPU
CPU CPU per Elapsd Old
Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
0.08 9 0.01 4.2 0.14 1,724 2689373535
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_J
OB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :
b := 0; END IF; END;
0.04 247 0.00 2.3 0.04 970 260339297
insert into sys.col_usage$ values ( :objn, :coln, decode(bit
and(:flag,1),0,0,1), decode(bitand(:flag,2),0,0,1), decode(b
itand(:flag,4),0,0,1), decode(bitand(:flag,8),0,0,1), decode
(bitand(:flag,16),0,0,1), decode(bitand(:flag,32),0,0,1), :t
ime)
0.03 109 0.00 1.5 0.03 327 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
-------------------------------------------------------------
SQL ordered by Elapsed DB/Inst: ORCL/orcl Snaps: 1-4
-> Resources reported for PL/SQL code includes the resources used by all SQL
statements called by the code.
-> Total DB Time (s): 4
-> Captured SQL accounts for 10.2% of Total DB Time
-> SQL reported below exceeded 1.0% of Total DB Time
Elapsed Elap per CPU Old
Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
0.14 9 0.02 3.5 0.08 1 2689373535
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_J
OB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :
b := 0; END IF; END;
0.07 207 0.00 1.9 0.02 2 2803285
update sys.mon_mods$ set inserts = inserts + :ins, updates = upd
ates + :upd, deletes = deletes + :del, flags = (decode(bitand(fl
ags, :flag), :flag, flags, flags + :flag)), drop_segments = drop
_segments + :dropseg, timestamp = :time where obj# = :objn
0.04 247 0.00 1.1 0.04 1 260339297
insert into sys.col_usage$ values ( :objn, :coln, decode(bit
and(:flag,1),0,0,1), decode(bitand(:flag,2),0,0,1), decode(b
itand(:flag,4),0,0,1), decode(bitand(:flag,8),0,0,1), decode
(bitand(:flag,16),0,0,1), decode(bitand(:flag,32),0,0,1), :t
ime)
-------------------------------------------------------------
SQL ordered by Gets DB/Inst: ORCL/orcl Snaps: 1-4
-> 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: 11,472
-> Captured SQL accounts for 35.1% 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
--------------- ------------ -------------- ------ -------- --------- ----------
1,724 9 191.6 15.0 0.08 0.14 2689373535
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_J
OB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :
b := 0; END IF; END;
970 247 3.9 8.5 0.04 0.04 260339297
insert into sys.col_usage$ values ( :objn, :coln, decode(bit
and(:flag,1),0,0,1), decode(bitand(:flag,2),0,0,1), decode(b
itand(:flag,4),0,0,1), decode(bitand(:flag,8),0,0,1), decode
(bitand(:flag,16),0,0,1), decode(bitand(:flag,32),0,0,1), :t
ime)
826 332 2.5 7.2 0.02 0.02 3665763022
update sys.col_usage$ set equality_preds = equality_preds
+ decode(bitand(:flag,1),0,0,1), equijoin_preds = equijoi
n_preds + decode(bitand(:flag,2),0,0,1), nonequijoin_preds
= nonequijoin_preds + decode(bitand(:flag,4),0,0,1), range_pre
ds = range_preds + decode(bitand(:flag,8),0,0,1),
496 207 2.4 4.3 0.02 0.07 2803285
update sys.mon_mods$ set inserts = inserts + :ins, updates = upd
ates + :upd, deletes = deletes + :del, flags = (decode(bitand(fl
ags, :flag), :flag, flags, flags + :flag)), drop_segments = drop
_segments + :dropseg, timestamp = :time where obj# = :objn
448 65 6.9 3.9 0.01 0.01 4143084494
select privilege#,level from sysauth$ connect by grantee#=prior
privilege# and privilege#>0 start with grantee#=:1 and privilege
#>0
327 109 3.0 2.9 0.03 0.03 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
153 21 7.3 1.3 0.00 0.00 1200253560
Module: EM_PING
INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATIO
N, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL)
VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 ,
1,32), :B5 , SUBSTR(:B4 ,1,128), SUBSTR(:B3 ,1,128), SUBSTR(:B2
,1,128), SUBSTR(:B1 ,1,256))
153 28 5.5 1.3 0.00 0.00 1938912649
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VAL
UE = :B2 , STRING_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC
_GUID = :B5 AND KEY_VALUE = :B4 AND COLLECTION_TIMESTAMP < :B3
SQL ordered by Gets DB/Inst: ORCL/orcl Snaps: 1-4
-> 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: 11,472
-> Captured SQL accounts for 35.1% 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
--------------- ------------ -------------- ------ -------- --------- ----------
-------------------------------------------------------------
SQL ordered by Reads DB/Inst: ORCL/orcl Snaps: 1-4
-> End Disk Reads Threshold: 1000 Total Disk Reads: 2
-> Captured SQL accounts for 200.0% 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
--------------- ------------ -------------- ------ -------- --------- ----------
2 207 0.0 100.0 0.02 0.07 2803285
update sys.mon_mods$ set inserts = inserts + :ins, updates = upd
ates + :upd, deletes = deletes + :del, flags = (decode(bitand(fl
ags, :flag), :flag, flags, flags + :flag)), drop_segments = drop
_segments + :dropseg, timestamp = :time where obj# = :objn
1 1 1.0 50.0 0.00 0.02 199663413
select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$
where obj#=:1 and intcol#=:2 and row#=:3 order by bucket
1 247 0.0 50.0 0.04 0.04 260339297
insert into sys.col_usage$ values ( :objn, :coln, decode(bit
and(:flag,1),0,0,1), decode(bitand(:flag,2),0,0,1), decode(b
itand(:flag,4),0,0,1), decode(bitand(:flag,8),0,0,1), decode
(bitand(:flag,16),0,0,1), decode(bitand(:flag,32),0,0,1), :t
ime)
1 9 0.1 50.0 0.08 0.14 2689373535
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate;
broken BOOLEAN := FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_J
OB_PROCS(); :mydate := next_date; IF broken THEN :b := 1; ELSE :
b := 0; END IF; END;
-------------------------------------------------------------
SQL ordered by Executions DB/Inst: ORCL/orcl Snaps: 1-4
-> End Executions Threshold: 100 Total Executions: 2,661
-> Captured SQL accounts for 66.3% 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
------------ --------------- ---------------- ----------- ---------- ----------
332 111 0.3 0.00 0.00 3665763022
update sys.col_usage$ set equality_preds = equality_preds
+ decode(bitand(:flag,1),0,0,1), equijoin_preds = equijoi
n_preds + decode(bitand(:flag,2),0,0,1), nonequijoin_preds
= nonequijoin_preds + decode(bitand(:flag,4),0,0,1), range_pre
ds = range_preds + decode(bitand(:flag,8),0,0,1),
247 247 1.0 0.00 0.00 260339297
insert into sys.col_usage$ values ( :objn, :coln, decode(bit
and(:flag,1),0,0,1), decode(bitand(:flag,2),0,0,1), decode(b
itand(:flag,4),0,0,1), decode(bitand(:flag,8),0,0,1), decode
(bitand(:flag,16),0,0,1), decode(bitand(:flag,32),0,0,1), :t
ime)
207 130 0.6 0.00 0.00 2803285
update sys.mon_mods$ set inserts = inserts + :ins, updates = upd
ates + :upd, deletes = deletes + :del, flags = (decode(bitand(fl
ags, :flag), :flag, flags, flags + :flag)), drop_segments = drop
_segments + :dropseg, timestamp = :time where obj# = :objn
207 0 0.0 0.00 0.00 2396279102
lock table sys.mon_mods$ in exclusive mode nowait
144 0 0.0 0.00 0.00 2554034351
lock table sys.col_usage$ in exclusive mode nowait
109 9 0.1 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
100 100 1.0 0.00 0.00 1693927332
select count(*) from sys.job$ where (next_date > sysdate) and (n
ext_date < (sysdate+5/86400))
65 291 4.5 0.00 0.00 4143084494
select privilege#,level from sysauth$ connect by grantee#=prior
privilege# and privilege#>0 start with grantee#=:1 and privilege
#>0
28 28 1.0 0.00 0.00 688250911
SELECT DISTINCT METRIC_GUID FROM MGMT_METRICS WHERE TARGET_TYPE
= :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1
28 28 1.0 0.00 0.00 792991232
SELECT DECODE(METRIC_TYPE, 6, 0, 7, 1, METRIC_TYPE), METRIC_GUID
, METRIC_LABEL, COLUMN_LABEL FROM MGMT_METRICS WHERE TARGET_TYPE
= :B3 AND METRIC_NAME = :B2 AND METRIC_COLUMN = :B1
28 28 1.0 0.00 0.00 1938912649
UPDATE MGMT_CURRENT_METRICS SET COLLECTION_TIMESTAMP = :B3 , VAL
SQL ordered by Executions DB/Inst: ORCL/orcl Snaps: 1-4
-> End Executions Threshold: 100 Total Executions: 2,661
-> Captured SQL accounts for 66.3% 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
------------ --------------- ---------------- ----------- ---------- ----------
UE = :B2 , STRING_VALUE = :B1 WHERE TARGET_GUID = :B6 AND METRIC
_GUID = :B5 AND KEY_VALUE = :B4 AND COLLECTION_TIMESTAMP < :B3
28 28 1.0 0.00 0.00 4203089485
SELECT TARGET_GUID FROM MGMT_TARGETS WHERE TARGET_NAME = :B2 AND
TARGET_TYPE = :B1
-------------------------------------------------------------
SQL ordered by Parse Calls DB/Inst: ORCL/orcl Snaps: 1-4
-> End Parse Calls Threshold: 1000 Total Parse Calls: 1,407
-> Captured SQL accounts for 95.7% of Total Parse Calls
-> SQL reported below exceeded 1.0% of Total Parse Calls
% Total Old
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
493 247 35.04 260339297
insert into sys.col_usage$ values ( :objn, :coln, decode(bit
and(:flag,1),0,0,1), decode(bitand(:flag,2),0,0,1), decode(b
itand(:flag,4),0,0,1), decode(bitand(:flag,8),0,0,1), decode
(bitand(:flag,16),0,0,1), decode(bitand(:flag,32),0,0,1), :t
ime)
207 207 14.71 2803285
update sys.mon_mods$ set inserts = inserts + :ins, updates = upd
ates + :upd, deletes = deletes + :del, flags = (decode(bitand(fl
ags, :flag), :flag, flags, flags + :flag)), drop_segments = drop
_segments + :dropseg, timestamp = :time where obj# = :objn
207 207 14.71 2396279102
lock table sys.mon_mods$ in exclusive mode nowait
144 144 10.23 2554034351
lock table sys.col_usage$ in exclusive mode nowait
144 332 10.23 3665763022
update sys.col_usage$ set equality_preds = equality_preds
+ decode(bitand(:flag,1),0,0,1), equijoin_preds = equijoi
n_preds + decode(bitand(:flag,2),0,0,1), nonequijoin_preds
= nonequijoin_preds + decode(bitand(:flag,4),0,0,1), range_pre
ds = range_preds + decode(bitand(:flag,8),0,0,1),
65 65 4.62 4143084494
select privilege#,level from sysauth$ connect by grantee#=prior
privilege# and privilege#>0 start with grantee#=:1 and privilege
#>0
-------------------------------------------------------------
Instance Activity Stats DB/Inst: ORCL/orcl Snaps: 1-4
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
CPU used by this session 180 0.3 3.5
CPU used when call started 177 0.3 3.5
CR blocks created 0 0.0 0.0
DB time 54,435 99.3 1,067.4
DBWR checkpoint buffers written 644 1.2 12.6
DBWR checkpoints 0 0.0 0.0
DBWR object drop buffers written 0 0.0 0.0
DBWR transaction table writes 12 0.0 0.2
DBWR undo block writes 103 0.2 2.0
IMU CR rollbacks 0 0.0 0.0
IMU Flushes 3 0.0 0.1
IMU Redo allocation size 92,320 168.5 1,810.2
IMU commits 48 0.1 0.9
IMU undo allocation size 133,400 243.4 2,615.7
PX local messages recv'd 0 0.0 0.0
PX local messages sent 0 0.0 0.0
SMON posted for dropping temp seg 0 0.0 0.0
SQL*Net roundtrips to/from client 41 0.1 0.8
active txn count during cleanout 106 0.2 2.1
application wait time 0 0.0 0.0
background timeouts 1,743 3.2 34.2
buffer is not pinned count 902 1.7 17.7
buffer is pinned count 1,328 2.4 26.0
bytes received via SQL*Net from c 13,850 25.3 271.6
bytes sent via SQL*Net to client 11,951 21.8 234.3
calls to get snapshot scn: kcmgss 3,149 5.8 61.8
calls to kcmgas 538 1.0 10.6
calls to kcmgcs 56 0.1 1.1
change write time 5 0.0 0.1
cleanout - number of ktugct calls 116 0.2 2.3
cleanouts only - consistent read 1 0.0 0.0
cluster key scan block gets 15 0.0 0.3
cluster key scans 11 0.0 0.2
commit batch/immediate performed 0 0.0 0.0
commit batch/immediate requested 0 0.0 0.0
commit cleanout failures: callbac 13 0.0 0.3
commit cleanouts 956 1.7 18.8
commit cleanouts successfully com 943 1.7 18.5
commit immediate performed 0 0.0 0.0
commit immediate requested 0 0.0 0.0
commit txn count during cleanout 57 0.1 1.1
concurrency wait time 0 0.0 0.0
consistent changes 0 0.0 0.0
consistent gets 5,678 10.4 111.3
consistent gets - examination 2,341 4.3 45.9
consistent gets from cache 5,678 10.4 111.3
cursor authentications 69 0.1 1.4
data blocks consistent reads - un 0 0.0 0.0
db block changes 5,660 10.3 111.0
db block gets 5,794 10.6 113.6
db block gets direct 0 0.0 0.0
db block gets from cache 5,794 10.6 113.6
deferred (CURRENT) block cleanout 556 1.0 10.9
enqueue conversions 246 0.5 4.8
enqueue releases 5,581 10.2 109.4
enqueue requests 5,581 10.2 109.4
Instance Activity Stats DB/Inst: ORCL/orcl Snaps: 1-4
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
enqueue timeouts 0 0.0 0.0
enqueue waits 0 0.0 0.0
execute count 2,661 4.9 52.2
failed probes on index block recl 0 0.0 0.0
free buffer inspected 391 0.7 7.7
free buffer requested 404 0.7 7.9
heap block compress 3 0.0 0.1
hot buffers moved to head of LRU 142 0.3 2.8
immediate (CR) block cleanout app 1 0.0 0.0
immediate (CURRENT) block cleanou 138 0.3 2.7
index crx upgrade (positioned) 343 0.6 6.7
index fast full scans (full) 1 0.0 0.0
index fetch by key 1,211 2.2 23.8
index scans kdiixs1 1,258 2.3 24.7
leaf node 90-10 splits 5 0.0 0.1
leaf node splits 45 0.1 0.9
lob reads 0 0.0 0.0
lob writes 0 0.0 0.0
lob writes unaligned 0 0.0 0.0
logons cumulative 12 0.0 0.2
messages received 505 0.9 9.9
messages sent 505 0.9 9.9
no buffer to keep pinned count 0 0.0 0.0
no work - consistent read gets 2,084 3.8 40.9
opened cursors cumulative 1,856 3.4 36.4
parse count (failures) 2 0.0 0.0
parse count (hard) 70 0.1 1.4
parse count (total) 1,407 2.6 27.6
parse time cpu 9 0.0 0.2
parse time elapsed 37 0.1 0.7
physical read IO requests 2 0.0 0.0
physical read bytes 16,384 29.9 321.3
physical read total IO requests 643 1.2 12.6
physical read total bytes 10,518,528 19,194.4 206,245.7
physical read total multi block r 0 0.0 0.0
physical reads 2 0.0 0.0
physical reads cache 2 0.0 0.0
physical reads cache prefetch 0 0.0 0.0
physical reads direct 0 0.0 0.0
physical reads direct temporary t 0 0.0 0.0
physical reads prefetch warmup 0 0.0 0.0
physical write IO requests 207 0.4 4.1
physical write bytes 5,275,648 9,627.1 103,444.1
physical write total IO requests 1,065 1.9 20.9
physical write total bytes 16,724,480 30,519.1 327,931.0
physical write total multi block 373 0.7 7.3
physical writes 644 1.2 12.6
physical writes direct 0 0.0 0.0
physical writes direct (lob) 0 0.0 0.0
physical writes from cache 644 1.2 12.6
physical writes non checkpoint 404 0.7 7.9
pinned buffers inspected 1 0.0 0.0
process last non-idle time 1,057 1.9 20.7
recovery blocks read 0 0.0 0.0
recursive calls 18,085 33.0 354.6
recursive cpu usage 167 0.3 3.3
Instance Activity Stats DB/Inst: ORCL/orcl Snaps: 1-4
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
redo blocks read for recovery 0 0.0 0.0
redo blocks written 4,889 8.9 95.9
redo entries 3,067 5.6 60.1
redo ordering marks 178 0.3 3.5
redo size 2,383,544 4,349.5 46,736.2
redo subscn max counts 470 0.9 9.2
redo synch time 8 0.0 0.2
redo synch writes 33 0.1 0.7
redo wastage 73,708 134.5 1,445.3
redo write time 22 0.0 0.4
redo writer latching time 0 0.0 0.0
redo writes 311 0.6 6.1
rollback changes - undo records a 0 0.0 0.0
rollbacks only - consistent read 0 0.0 0.0
rows fetched via callback 100 0.2 2.0
session connect time 0 0.0 0.0
session cursor cache hits 1,105 2.0 21.7
session logical reads 11,472 20.9 224.9
session pga memory 12,037,960 21,967.1 236,038.4
session pga memory max 38,514,504 70,281.9 755,186.4
session uga memory 42,950,698,872 78,377,187.7 ############
session uga memory max 11,899,468 21,714.4 233,322.9
shared hash latch upgrades - no w 369 0.7 7.2
sorts (memory) 574 1.1 11.3
sorts (rows) 23,107 42.2 453.1
sql area evicted 0 0.0 0.0
sql area purged 2 0.0 0.0
switch current to new buffer 2 0.0 0.0
table fetch by rowid 467 0.9 9.2
table fetch continued row 0 0.0 0.0
table scan blocks gotten 688 1.3 13.5
table scan rows gotten 22,468 41.0 440.6
table scans (long tables) 0 0.0 0.0
table scans (short tables) 210 0.4 4.1
total number of times SMON posted 0 0.0 0.0
transaction rollbacks 0 0.0 0.0
undo change vector size 801,188 1,462.0 15,709.6
user I/O wait time 6 0.0 0.1
user calls 92 0.2 1.8
user commits 51 0.1 1.0
workarea executions - optimal 294 0.5 5.8
write clones created in backgroun 0 0.0 0.0
-------------------------------------------------------------
Instance Activity Stats DB/Inst: ORCL/orcl Snaps: 1-4
-> Statistics with absolute values (should not be diffed)
Statistic Begin Value End Value
--------------------------------- --------------- ---------------
logons current 17 17
opened cursors current 62 86
session cursor cache count 1,279 1,478
-------------------------------------------------------------
Instance Activity Stats DB/Inst: ORCL/orcl Snaps: 1-4
-> Statistics identified by '(derived)' come from sources other than SYSSTAT
Statistic Total per Hour
--------------------------------- ------------------ ---------
log switches (derived) 0 .00
-------------------------------------------------------------
OS Statistics DB/Inst: ORCL/orcl Snaps: 1-4
-> ordered by statistic type (CPU use, Virtual Memory, Hardware Config), Name
Statistic Total
------------------------- ----------------------
BUSY_TIME 8,419
IDLE_TIME 101,053
SYS_TIME 4,954
USER_TIME 3,465
VM_IN_BYTES 6,717,440
VM_OUT_BYTES 8,929,280
PHYSICAL_MEMORY_BYTES 2,142,089,216
NUM_CPUS 2
NUM_CPU_CORES 2
-------------------------------------------------------------
Tablespace IO Stats DB/Inst: ORCL/orcl Snaps: 1-4
->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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
SYSTEM
6,333 12 6.2 1.2 473 1 1 0.0
PS_TBS
89 0 12.8 1.0 2,613 5 0 0.0
SYSAUX
811 1 18.1 2.4 439 1 1 0.0
UNDOTBS1
50 0 151.6 1.0 288 1 0 0.0
EXAMPLE
9 0 22.2 1.0 2 0 0 0.0
USERS
7 0 22.9 1.0 2 0 0 0.0
-------------------------------------------------------------
File IO Stats DB/Inst: ORCL/orcl Snaps: 1-4
->Mx Rd Bkt: Max bucket time for single block read
->ordered 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)
-------------- ------- ----- --- ------- ------------ -------- ---------- ------
EXAMPLE E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/EXAMPLE01.DBF
9 0 22.2 1.0 2 0 0
PS_TBS E:/ORACLE/PRODUCT/10.2.0/DB_3/DATABASE/PERFSTAT.DBF
89 0 12.8 1.0 2,613 5 0
SYSAUX E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/SYSAUX01.DBF
811 1 18.1 64 2.4 439 1 1 0.0
SYSTEM E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/SYSTEM01.DBF
6,333 12 6.2 32 1.2 473 1 1 0.0
UNDOTBS1 E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/UNDOTBS01.DBF
50 0 ##### 1.0 288 1 0
USERS E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/USERS01.DBF
7 0 22.9 1.0 2 0 0
-------------------------------------------------------------
File Read Histogram Stats DB/Inst: ORCL/orcl Snaps: 1-4
->Number of single block reads in each time range
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
0 - 2 ms 2 - 4 ms 4 - 8 ms 8 - 16 ms 16 - 32 ms 32+ ms
------------ ------------ ------------ ------------ ------------ ------------
SYSAUX E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/SYSAUX01.DBF
0 0 0 0 0 1
SYSTEM E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/SYSTEM01.DBF
0 0 0 0 1 0
-------------------------------------------------------------
Buffer Pool Statistics DB/Inst: ORCL/orcl Snaps: 1-4
-> Standard block size Pools D: default, K: keep, R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
-> Buffers: the number of buffers. Units of K, M, G are divided by 1000
Free Writ Buffer
Pool Buffer Physical Physical Buffer Comp Busy
P Buffers Hit% Gets Reads Writes Waits Wait Waits
--- ------- ---- -------------- ------------ ----------- ------- ---- ----------
D 13K 100 11,729 2 644 0 0 0
-------------------------------------------------------------
Instance Recovery Stats DB/Inst: ORCL/orcl Snaps: 1-4
-> 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 51 329 85 26816 184320 26816
E 0 51 353 2480 8766 184320 8766
-------------------------------------------------------------
Buffer Pool Advisory DB/Inst: ORCL/orcl End Snap: 4
-> Only rows with estimated physical reads >0 are displayed
-> ordered by Pool, Block Size, Buffers For Estimate
Est
Phys Estimated Est
Size for Size Buffers Read Phys Reads Est Phys % dbtime
P Est (M) Factr (thousands) Factr (thousands) Read Time for Rds
--- -------- ----- ------------ ------ -------------- ------------ --------
D 8 .1 1 2.2 21 113 148.7
D 16 .1 2 1.5 14 74 97.4
D 24 .2 3 1.3 13 64 84.2
D 32 .3 4 1.2 11 54 71.1
D 40 .4 5 1.1 10 50 65.8
D 48 .4 6 1.0 10 47 61.8
D 56 .5 7 1.0 10 46 60.5
D 64 .6 8 1.0 10 45 59.2
D 72 .7 9 1.0 10 45 59.2
D 80 .7 10 1.0 10 45 59.2
D 88 .8 11 1.0 10 45 59.2
D 96 .9 12 1.0 9 44 57.9
D 104 1.0 13 1.0 9 44 57.9
D 108 1.0 13 1.0 9 44 57.9
D 112 1.0 14 1.0 9 44 57.9
D 120 1.1 15 1.0 9 44 57.9
D 128 1.2 16 1.0 9 44 57.9
D 136 1.3 17 1.0 9 44 57.9
D 144 1.3 18 1.0 9 44 57.9
D 152 1.4 19 1.0 9 44 57.9
D 160 1.5 20 1.0 9 41 53.9
-------------------------------------------------------------
PGA Aggr Target Stats DB/Inst: ORCL/orcl Snaps: 1-4
-> B: Begin snap E: End snap (rows identified 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
--------------- ---------------- -------------------------
100.0 32 0
%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 92 72 25.2 0.0 .0 .0 .0 18,841
E 92 72 24.7 0.0 .0 .0 .0 18,841
-------------------------------------------------------------
PGA Aggr Target Histogram DB/Inst: ORCL/orcl Snaps: 1-4
-> Optimal Executions are purely in-memory operations
Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- ------------- ------------ ------------
2K 4K 239 239 0 0
64K 128K 8 8 0 0
128K 256K 3 3 0 0
512K 1024K 42 42 0 0
-------------------------------------------------------------
PGA Memory Advisory DB/Inst: ORCL/orcl End Snap: 4
-> 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
---------- ------- ---------------- ---------------- -------- ----------
12 0.1 77.9 3.1 96.0 2
23 0.3 77.9 0.0 100.0 0
46 0.5 77.9 0.0 100.0 0
69 0.8 77.9 0.0 100.0 0
92 1.0 77.9 0.0 100.0 0
110 1.2 77.9 0.0 100.0 0
129 1.4 77.9 0.0 100.0 0
147 1.6 77.9 0.0 100.0 0
166 1.8 77.9 0.0 100.0 0
184 2.0 77.9 0.0 100.0 0
276 3.0 77.9 0.0 100.0 0
368 4.0 77.9 0.0 100.0 0
552 6.0 77.9 0.0 100.0 0
736 8.0 77.9 0.0 100.0 0
-------------------------------------------------------------
Process Memory Summary Stats DB/Inst: ORCL/orcl Snaps: 1-4
-> B: Begin snap E: End snap
-> All rows below contain absolute values (i.e. not diffed over the interval)
-> Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
-> Num Procs or Allocs: For Begin/End snapshot lines, it is the number of
processes. For Category lines, it is the number of allocations
-> ordered by Begin/End snapshot, Alloc (MB) desc
Hist Num
Avg Std Dev Max Max Procs
Alloc Used Freeabl Alloc Alloc Alloc Alloc or
Category (MB) (MB) (MB) (MB) (MB) (MB) (MB) Allocs
- -------- --------- --------- -------- -------- ------- ------- ------ ------
B -------- 25.6 11.9 .0 1.3 2.0 9 14 19
Other 25.1 1.3 2.0 9 10 19
SQL .4 .2 .0 .0 0 2 8
PL/SQL .2 .1 .0 .0 0 6 17
E -------- 25.0 12.0 .0 1.3 2.0 9 14 19
Other 24.5 1.3 2.0 9 10 19
SQL .3 .1 .0 .0 0 2 8
PL/SQL .2 .1 .0 .0 0 6 17
-------------------------------------------------------------
Top Process Memory (by component) DB/Inst: ORCL/orcl Snaps: 1-4
-> ordered by Begin/End snapshot, Alloc (MB) desc
Alloc Used Freeabl Max Hist Max
PId Category (MB) (MB) (MB) Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
B 6 LGWR -------- 9.1 4.2 .0 9.1 9.6
Other 9.1 9.1 9.6
PL/SQL .0 .0 .0 .0
17 SHAD -------- 3.3 2.0 .0 3.3 4.0
Other 3.2 3.2 3.2
SQL .1 .1 .1 1.3
PL/SQL .0 .0 .0 .0
5 DBW0 -------- 1.7 .3 .0 1.7 1.7
Other 1.7 1.7 1.7
PL/SQL .0 .0 .0 .0
11 MMON -------- 1.5 1.1 .0 1.5 2.8
Other 1.4 1.4 1.8
SQL .1 .0 .1 .9
PL/SQL .0 .0 .0 .0
16 J000 -------- 1.3 .1 .0 1.3 4.0
Other 1.3 1.3 1.5
PL/SQL .1 .0 .1 .1
SQL .0 .0 .0 2.3
15 SHAD -------- 1.2 .6 .0 1.2 14.4
Other 1.2 1.2 8.6
PL/SQL .0 .0 .0 5.5
SQL .0 .0 .0 .2
8 SMON -------- 1.2 .4 .0 1.2 1.2
Other 1.2 1.2 1.2
SQL .0 .0 .0 .2
PL/SQL .0 .0 .0 .0
13 D000 -------- 1.2 .5 .0 1.2 1.2
Other 1.2 1.2 1.2
E 6 LGWR -------- 9.1 4.2 .0 9.1 9.6
Other 9.1 9.1 9.6
PL/SQL .0 .0 .0 .0
17 SHAD -------- 2.7 2.0 .0 2.7 3.5
Other 2.6 2.6 2.6
SQL .1 .0 .1 1.3
PL/SQL .0 .0 .0 .0
5 DBW0 -------- 1.7 .3 .0 1.7 1.7
Other 1.7 1.7 1.7
PL/SQL .0 .0 .0 .0
11 MMON -------- 1.5 1.1 .0 1.5 2.8
Other 1.4 1.4 1.8
SQL .1 .0 .1 .9
PL/SQL .0 .0 .0 .0
16 J000 -------- 1.3 .1 .0 1.3 4.0
Other 1.3 1.3 1.5
PL/SQL .1 .0 .1 .1
SQL .0 .0 .0 2.3
15 SHAD -------- 1.2 .6 .0 1.2 14.4
Other 1.2 1.2 8.6
PL/SQL .0 .0 .0 5.5
SQL .0 .0 .0 .2
8 SMON -------- 1.2 .4 .0 1.2 1.2
Other 1.2 1.2 1.2
SQL .0 .0 .0 .2
Top Process Memory (by component) DB/Inst: ORCL/orcl Snaps: 1-4
-> ordered by Begin/End snapshot, Alloc (MB) desc
Alloc Used Freeabl Max Hist Max
PId Category (MB) (MB) (MB) Alloc (MB) Alloc (MB)
- ------ ------------- ------- ------- -------- ---------- ----------
E 8 PL/SQL .0 .0 .0 .0
13 D000 -------- 1.2 .5 .0 1.2 1.2
Other 1.2 1.2 1.2
-------------------------------------------------------------
Undo Segment Summary DB/Inst: ORCL/orcl Snaps: 1-4
-> Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
-> STO - Snapshot Too Old count, OOS - Out Of Space count
-> Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed
Undo Num Undo Number of Max Qry Max Tx Min/Max STO/ uS/uR/uU/
TS# Blocks (K) Transactions Len (s) Concy TR (mins) OOS eS/eR/eU
---- ---------- --------------- -------- ---------- --------- ----- -----------
1 .2 371 0 2 15/15 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Undo Segment Stats DB/Inst: ORCL/orcl Snaps: 1-4
-> Most recent 35 Undostat rows, ordered by End Time desc
Num Undo Number of Max Qry Max Tx Tun Ret STO/ uS/uR/uU/
End Time Blocks Transactions Len (s) Concy (mins) OOS eS/eR/eU
------------ ----------- ------------ ------- ------- ------- ----- -----------
30-3月 23:2 173 371 0 2 15 0/0 0/0/0/0/0/0
1
-------------------------------------------------------------
Latch Activity DB/Inst: ORCL/orcl Snaps: 1-4
->"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
------------------------ -------------- ------ ------ ------ ------------ ------
ASM db client latch 364 0.0 0 0
Consistent RBA 311 0.0 0 0
FOB s.o list latch 11 0.0 0 0
In memory undo latch 617 0.0 0 173 0.0
JS mem alloc latch 1 0.0 0 0
JS queue access latch 1 0.0 0 0
JS queue state obj latch 4,012 0.0 0 0
JS slv state obj latch 5 0.0 0 0
KMG MMAN ready and start 182 0.0 0 0
KTF sga latch 2 0.0 0 174 0.0
KWQP Prop Status 3 0.0 0 0
MQL Tracking Latch 0 0 11 0.0
Memory Management Latch 0 0 182 0.0
OS process 6 0.0 0 0
OS process allocation 186 0.0 0 0
OS process: request allo 4 0.0 0 0
PL/SQL warning settings 39 0.0 0 0
SQL memory manager latch 3 0.0 0 182 0.0
SQL memory manager worka 12,619 0.0 0 0
Shared B-Tree 29 0.0 0 0
active checkpoint queue 389 0.0 0 0
active service list 1,172 0.0 0 183 0.0
archive control 2 0.0 0 0
cache buffer handles 140 0.0 0 0
cache buffers chains 33,938 0.0 0 397 0.0
cache buffers lru chain 1,700 0.0 0 0
channel handle pool latc 4 0.0 0 0
channel operations paren 2,565 0.0 0 0
checkpoint queue latch 4,921 0.0 0 640 0.0
client/application info 248 0.0 0 0
compile environment latc 51 0.0 0 0
dml lock allocation 1,137 0.0 0 0
dummy allocation 24 0.0 0 0
enqueue hash chains 11,396 0.0 0 0
enqueues 9,345 0.0 0 0
event group latch 2 0.0 0 0
global KZLD latch for me 1 0.0 0 0
hash table column usage 244 0.0 0 4,725 0.0
hash table modification 23 0.0 0 0
job workq parent latch 0 0 20 0.0
job_queue_processes para 19 0.0 0 0
kks stats 112 0.0 0 0
ksuosstats global area 43 0.0 0 0
ktm global data 3 0.0 0 0
kwqbsn:qsga 29 0.0 0 0
lgwr LWN SCN 465 0.0 0 0
library cache 11,352 0.0 0 0
library cache load lock 136 0.0 0 0
library cache lock 6,724 0.0 0 0
library cache lock alloc 294 0.0 0 0
Latch Activity DB/Inst: ORCL/orcl Snaps: 1-4
->"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
------------------------ -------------- ------ ------ ------ ------------ ------
library cache pin 3,266 0.0 0 0
library cache pin alloca 114 0.0 0 0
list of block allocation 49 0.0 0 0
messages 4,787 0.0 0.0 0 0
mostly latch-free SCN 465 0.0 0 0
ncodef allocation latch 9 0.0 0 0
object queue header heap 390 0.0 0 0
object queue header oper 2,799 0.0 0 0
object stats modificatio 1 0.0 0 0
parallel query alloc buf 72 0.0 0 0
parameter table allocati 13 0.0 0 0
post/wait queue 48 0.0 0 17 0.0
process allocation 4 0.0 0 2 0.0
process group creation 4 0.0 0 0
qmn task queue latch 80 12.5 0.9 0 0
redo allocation 1,587 0.0 0 3,081 0.0
redo copy 0 0 3,081 0.4
redo writing 1,708 0.0 0 0
resmgr group change latc 52 0.0 0 0
resmgr:actses active lis 27 0.0 0 0
resmgr:actses change gro 12 0.0 0 0
resmgr:free threads list 24 0.0 0 0
resmgr:schema config 3 0.0 0 0
row cache objects 15,899 0.0 0 0
rules engine rule set st 300 0.0 0 0
sequence cache 15 0.0 0 0
session allocation 19,545 0.0 0 0
session idle bit 224 0.0 0 0
session state list latch 34 0.0 0 0
session switching 9 0.0 0 0
session timer 183 0.0 0 0
shared pool 6,366 0.0 0 0
shared pool sim alloc 2 0.0 0 0
shared pool simulator 742 0.0 0 0
simulator hash latch 1,454 0.0 0 0
simulator lru latch 1,398 0.0 0 18 0.0
sort extent pool 11 0.0 0 0
threshold alerts latch 11 0.0 0 0
transaction allocation 26 0.0 0 0
transaction branch alloc 9 0.0 0 0
undo global data 1,580 0.0 0 0
user lock 24 0.0 0 0
-------------------------------------------------------------
Latch Sleep breakdown DB/Inst: ORCL/orcl Snaps: 1-4
-> ordered by misses desc
Get Spin
Latch Name Requests Misses Sleeps Gets
-------------------------- --------------- ------------ ----------- -----------
qmn task queue latch 80 10 9 1
-------------------------------------------------------------
Latch Miss Sources DB/Inst: ORCL/orcl Snaps: 1-4
-> only latches with sleeps are shown
-> ordered by name, sleeps desc
NoWait Waiter
Latch Name Where Misses Sleeps Sleeps
------------------------ -------------------------- ------- ---------- --------
event range base latch No latch 0 9 9
-------------------------------------------------------------
Dictionary Cache Stats DB/Inst: ORCL/orcl Snaps: 1-4
->"Pct Misses" should be very low (< 2% in most cases)
->"Final Usage" is the number of cache entries being used in End Snapshot
Get Pct Scan Pct Mod Final
Cache Requests Miss Reqs Miss Reqs Usage
------------------------- ------------ ------ ------- ----- -------- ----------
dc_awr_control 9 0.0 0 0 1
dc_global_oids 38 2.6 0 0 128
dc_histogram_data 20 5.0 0 0 1,019
dc_histogram_defs 1,358 33.1 0 0 3,962
dc_object_grants 35 28.6 0 0 34
dc_object_ids 687 0.6 0 0 1,751
dc_objects 321 2.5 0 1 1,840
dc_profiles 12 0.0 0 0 1
dc_rollback_segments 82 0.0 0 0 22
dc_segments 193 1.0 0 0 1,350
dc_tablespaces 1,311 0.0 0 0 9
dc_usernames 18 5.6 0 0 21
dc_users 1,597 0.0 0 0 24
-------------------------------------------------------------
Library Cache Activity DB/Inst: ORCL/orcl Snaps: 1-4
->"Pct Misses" should be very low
Get Pct Pin Pct Invali-
Namespace Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------ ---------- --------
SQL AREA 23 100.0 3,622 6.1 0 0
TABLE/PROCEDURE 447 1.8 1,821 5.3 42 0
BODY 117 0.0 154 0.0 0 0
TRIGGER 6 0.0 37 0.0 0 0
-------------------------------------------------------------
Rule Sets DB/Inst: ORCL/orcl Snaps: 1-4
-> * indicates Rule Set activity (re)started between Begin/End snaps
-> Top 25 ordered by Evaluations desc
No-SQL SQL
Rule * Eval/sec Reloads/sec Eval % Eval %
----------------------------------- - ------------ ----------- ------ ------
SYS.ALERT_QUE_R 0 0 0 0
-------------------------------------------------------------
Shared Pool Advisory DB/Inst: ORCL/orcl End Snap: 4
-> SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
-> Note there is often a 1:Many correlation between a single logical object
in the Library Cache, and the physical number of memory objects associated
with it. Therefore comparing the number of Lib Cache objects (e.g. in
v$librarycache), with the number of Lib Cache Memory Objects is invalid
Est LC Est LC Est LC Est LC
Shared SP Est LC Time Time Load Load Est LC
Pool Size Size Est LC Saved Saved Time Time Mem
Size (M) Factr (M) Mem Obj (s) Factr (s) Factr Obj Hits
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
76 .5 19 2,518 2,857 1.0 48 2.3 270,841
92 .7 33 3,877 2,883 1.0 22 1.0 272,282
108 .8 48 5,901 2,884 1.0 21 1.0 272,379
124 .9 54 6,899 2,884 1.0 21 1.0 272,380
140 1.0 54 6,899 2,884 1.0 21 1.0 272,380
156 1.1 54 6,899 2,884 1.0 21 1.0 272,380
172 1.2 54 6,899 2,884 1.0 21 1.0 272,380
188 1.3 54 6,899 2,884 1.0 21 1.0 272,380
204 1.5 54 6,899 2,884 1.0 21 1.0 272,380
220 1.6 54 6,899 2,884 1.0 21 1.0 272,380
236 1.7 54 6,899 2,884 1.0 21 1.0 272,380
252 1.8 54 6,899 2,884 1.0 21 1.0 272,380
268 1.9 54 6,899 2,884 1.0 21 1.0 272,380
284 2.0 54 6,899 2,884 1.0 21 1.0 272,380
-------------------------------------------------------------
SGA Target Advisory DB/Inst: ORCL/orcl End Snap: 4
SGA Target SGA Size Est DB Est DB Est Physical
Size (M) Factor Time (s) Time Factor Reads
---------- -------- -------- ----------- --------------
140 .5 91 1.2 11,663
210 .8 79 1.0 10,029
280 1.0 76 1.0 9,448
350 1.3 76 1.0 9,448
420 1.5 76 1.0 9,448
490 1.8 76 1.0 9,448
560 2.0 76 1.0 9,448
-------------------------------------------------------------
SGA Memory Summary DB/Inst: ORCL/orcl Snaps: 1-4
End Size (Bytes)
SGA regions Begin Size (Bytes) (if different)
------------------------------ -------------------- --------------------
Database Buffers 113,246,208
Fixed Size 1,290,208
Redo Buffers 7,098,368
Variable Size 171,966,496
-------------------- --------------------
sum 293,601,280
-------------------------------------------------------------
SGA breakdown difference DB/Inst: ORCL/orcl Snaps: 1-4
-> Top 35 rows by size, ordered by Pool, Name (note rows with null values for
Pool column, or Names showing free memory are always shown)
-> Null value for Begin MB or End MB indicates the size of that Pool/Name was
insignificant, or zero in that snapshot
Pool Name Begin MB End MB % Diff
------ ------------------------------ -------------- -------------- --------
java p free memory 20.0 20.0 0.00
large PX msg pool .9 .9 0.00
large free memory 3.1 3.1 0.00
shared ASH buffers 4.0 4.0 0.00
shared CCursor 5.2 5.4 3.94
shared Heap0: KGL 2.6 2.6 0.38
shared KCB Table Scan Buffer 3.8 3.8 0.00
shared KGLS heap 7.4 7.4 0.61
shared KQR M PO 3.5 3.7 6.35
shared KSFD SGA I/O b 3.8 3.8 0.00
shared PCursor 2.6 2.7 6.03
shared PL/SQL DIANA 4.2 4.2 0.00
shared PL/SQL MPCODE 3.7 3.7 0.00
shared XDB Schema Cac 5.4 5.4 0.00
shared event statistics per sess 1.5 1.5 0.00
shared free memory 43.1 41.4 -4.05
shared kglsim hash table bkts 2.0 2.0 0.00
shared library cache 5.6 5.7 0.77
shared row cache 3.6 3.6 0.00
shared sql area 13.6 14.5 7.08
buffer_cache 108.0 108.0 0.00
fixed_sga 1.2 1.2 0.00
log_buffer 6.8 6.8 0.00
-------------------------------------------------------------
SQL Memory Statistics DB/Inst: ORCL/orcl Snaps: 1-4
Begin End % Diff
-------------- -------------- --------------
Avg Cursor Size (KB): 15.34 15.37 .20
Cursor to Parent ratio: 1.01 1.01 -.03
Total Cursors: 1,198 1,228 2.44
Total Parents: 1,185 1,215 2.47
-------------------------------------------------------------
init.ora Parameters DB/Inst: ORCL/orcl Snaps: 1-4
End value
Parameter Name Begin value (if different)
----------------------------- --------------------------------- --------------
audit_file_dest E:/ORACLE/PRODUCT/10.2.0/DB_3/ADM
background_dump_dest E:/ORACLE/PRODUCT/10.2.0/DB_3/ADM
compatible 10.2.0.3.0
control_files E:/ORACLE/PRODUCT/10.2.0/ORADATA/
core_dump_dest E:/ORACLE/PRODUCT/10.2.0/DB_3/ADM
db_block_size 8192
db_domain
db_file_multiblock_read_count 16
db_name orcl
db_recovery_file_dest e:/oracle/product/10.2.0/db_3/fla
db_recovery_file_dest_size 2147483648
dispatchers (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes 10
open_cursors 300
pga_aggregate_target 96468992
processes 150
remote_login_passwordfile EXCLUSIVE
sga_target 293601280
undo_management AUTO
undo_tablespace UNDOTBS1
user_dump_dest E:/ORACLE/PRODUCT/10.2.0/DB_3/ADM
-------------------------------------------------------------
End of Report ( lulu.log )
扫一扫
2129
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
