oracle av rd ms,Oracle AWR报告生成与查看
接上一段报告文件
Instance Activity Stats DB/Inst: PENG/peng Snaps: 64-70
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
CPU used by this session 1,523 0.1 1.5
CPU used when call started 993 0.1 1.0
CR blocks created 20 0.0 0.0
DB time 690,870 54.9 662.4
DBWR checkpoint buffers written 2,501 0.2 2.4
DBWR transaction table writes 199 0.0 0.2
DBWR undo block writes 503 0.0 0.5
IMU Flushes 94 0.0 0.1
IMU Redo allocation size 377,272 30.0 361.7
IMU commits 951 0.1 0.9
IMU contention 1 0.0 0.0
IMU recursive-transaction flush 1 0.0 0.0
IMU undo allocation size 2,425,628 192.7 2,325.6
SMON posted for undo segment shr 3 0.0 0.0
SQL*Net roundtrips to/from clien 276 0.0 0.3
active txn count during cleanout 119 0.0 0.1
background timeouts 21,636 1.7 20.7
buffer is not pinned count 35,952 2.9 34.5
buffer is pinned count 36,843 2.9 35.3
bytes received via SQL*Net from 66,804 5.3 64.1
bytes sent via SQL*Net to client 554,180 44.0 531.3
calls to get snapshot scn: kcmgs 88,039 7.0 84.4
calls to kcmgas 1,927 0.2 1.9
calls to kcmgcs 332 0.0 0.3
change write time 142 0.0 0.1
cleanout - number of ktugct call 146 0.0 0.1
cleanouts only - consistent read 6 0.0 0.0
cluster key scan block gets 1,221 0.1 1.2
cluster key scans 777 0.1 0.7
commit batch/immediate performed 1 0.0 0.0
commit batch/immediate requested 1 0.0 0.0
commit cleanout failures: callba 22 0.0 0.0
commit cleanouts 4,835 0.4 4.6
commit cleanouts successfully co 4,813 0.4 4.6
commit immediate performed 1 0.0 0.0
commit immediate requested 1 0.0 0.0
commit txn count during cleanout 88 0.0 0.1
concurrency wait time 1,163 0.1 1.1
consistent changes 52,450 4.2 50.3
consistent gets 95,246 7.6 91.3
consistent gets - examination 33,417 2.7 32.0
consistent gets direct 30 0.0 0.0
consistent gets from cache 95,216 7.6 91.3
cursor authentications 325 0.0 0.3
data blocks consistent reads - u 21 0.0 0.0
db block changes 74,863 6.0 71.8
db block gets 177,282 14.1 170.0
db block gets from cache 177,282 14.1 170.0
deferred (CURRENT) block cleanou 3,249 0.3 3.1
enqueue conversions 1,373 0.1 1.3
enqueue releases 62,842 5.0 60.3
enqueue requests 62,842 5.0 60.3
execute count 21,246 1.7 20.4
free buffer inspected 2,656 0.2 2.6
free buffer requested 15,013 1.2 14.4
heap block compress 98 0.0 0.1
hot buffers moved to head of LRU 949 0.1 0.9
immediate (CR) block cleanout ap 6 0.0 0.0
immediate (CURRENT) block cleano 655 0.1 0.6
index crx upgrade (positioned) 4,769 0.4 4.6
Instance Activity Stats DB/Inst: PENG/peng Snaps: 64-70
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
index fast full scans (full) 4 0.0 0.0
index fetch by key 18,046 1.4 17.3
index scans kdiixs1 13,749 1.1 13.2
leaf node 90-10 splits 34 0.0 0.0
leaf node splits 59 0.0 0.1
lob reads 7,701 0.6 7.4
lob writes 13,894 1.1 13.3
lob writes unaligned 13,894 1.1 13.3
logons cumulative 345 0.0 0.3
messages received 3,184 0.3 3.1
messages sent 3,184 0.3 3.1
no buffer to keep pinned count 0 0.0 0.0
no work - consistent read gets 37,580 3.0 36.0
opened cursors cumulative 12,246 1.0 11.7
parse count (failures) 3 0.0 0.0
parse count (hard) 381 0.0 0.4
parse count (total) 10,660 0.9 10.2
parse time cpu 121 0.0 0.1
parse time elapsed 136 0.0 0.1
physical read IO requests 855 0.1 0.8
physical read bytes 13,533,184 1,074.9 12,975.3
physical read total IO requests 9,684 0.8 9.3
physical read total bytes 157,830,656 12,536.4 151,323.7
physical read total multi block 146 0.0 0.1
physical reads 1,652 0.1 1.6
physical reads cache 1,622 0.1 1.6
physical reads cache prefetch 797 0.1 0.8
physical reads direct 30 0.0 0.0
physical reads direct (lob) 30 0.0 0.0
physical reads direct temporary 0 0.0 0.0
physical reads prefetch warmup 380 0.0 0.4
physical write IO requests 1,752 0.1 1.7
physical write bytes 20,488,192 1,627.4 19,643.5
physical write total IO requests 9,758 0.8 9.4
physical write total bytes 136,588,288 10,849.2 130,957.1
physical write total multi block 1,467 0.1 1.4
physical writes 2,501 0.2 2.4
physical writes direct 0 0.0 0.0
physical writes direct temporary 0 0.0 0.0
physical writes from cache 2,501 0.2 2.4
physical writes non checkpoint 888 0.1 0.9
prefetch warmup blocks aged out 19 0.0 0.0
recursive calls 140,373 11.2 134.6
recursive cpu usage 1,054 0.1 1.0
redo blocks written 11,910 1.0 11.4
redo entries 9,851 0.8 9.4
redo size 5,534,940 439.6 5,306.8
redo synch time 87 0.0 0.1
redo synch writes 211 0.0 0.2
redo wastage 352,632 28.0 338.1
redo write time 379 0.0 0.4
redo writer latching time 3 0.0 0.0
redo writes 1,290 0.1 1.2
rollback changes - undo records 2 0.0 0.0
rollbacks only - consistent read 20 0.0 0.0
rows fetched via callback 7,974 0.6 7.7
session cursor cache hits 4,536 0.4 4.4
session logical reads 272,528 21.7 261.3
session pga memory 235,698,068 18,721.4 225,980.9
session pga memory max 783,382,420 62,223.7 751,085.7
Instance Activity Stats DB/Inst: PENG/peng Snaps: 64-70
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
session uga memory 859,005,419,284 68,230,419.1 #############
session uga memory max 181,044,444 14,380.3 173,580.5
shared hash latch upgrades - no 5,757 0.5 5.5
sorts (disk) 0 0.0 0.0
sorts (memory) 5,902 0.5 5.7
sorts (rows) 70,812 5.6 67.9
sql area evicted 0 0.0 0.0
sql area purged 3 0.0 0.0
switch current to new buffer 22 0.0 0.0
table fetch by rowid 25,758 2.1 24.7
table fetch continued row 89 0.0 0.1
table scan blocks gotten 14,470 1.2 13.9
table scan rows gotten 589,154 46.8 564.9
table scans (long tables) 3 0.0 0.0
table scans (short tables) 3,385 0.3 3.3
total number of times SMON poste 5 0.0 0.0
transaction rollbacks 1 0.0 0.0
undo change vector size 1,815,128 144.2 1,740.3
user I/O wait time 301 0.0 0.3
user calls 1,392 0.1 1.3
user commits 1,043 0.1 1.0
workarea executions - onepass 0 0.0 0.0
workarea executions - optimal 3,391 0.3 3.3
-------------------------------------------------------------
Instance Activity Stats - Absolute Values DB/Inst: PENG/peng Snaps: 64-70
-> Statistics with absolute values (should not be diffed)
Statistic Begin Value End Value
-------------------------------- --------------- ---------------
opened cursors current 41 72
logons current 19 22
session cursor cache count 1,073 4,225
-------------------------------------------------------------
Instance Activity Stats - Thread Activity DB/Inst: PENG/peng Snaps: 64-70
-> Statistics identified by '(derived)' come from sources other than SYSSTAT
Statistic Total per Hour
-------------------------------- ------------------ ---------
log switches (derived) 0 .00
-------------------------------------------------------------
Tablespace IO Stats DB/Inst: PENG/peng Snaps: 64-70
-> 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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
SYSAUX
564 0 3.3 1.9 1,167 0 0 0.0
SYSTEM
470 0 2.8 1.9 162 0 0 0.0
UNDOTBS1
2 0 10.0 1.0 423 0 1 10.0
-------------------------------------------------------------
File IO Stats DB/Inst: PENG/peng Snaps: 64-70
-> ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
SYSAUX /Oracle/oradata/peng/sysaux01.dbf
564 0 3.3 1.9 1,167 0 0 0.0
SYSTEM /oracle/oradata/peng/system01.dbf
470 0 2.8 1.9 162 0 0 0.0
UNDOTBS1 /oracle/oradata/peng/undotbs01.dbf
2 0 10.0 1.0 423 0 1 10.0
-------------------------------------------------------------
Buffer Pool Statistics DB/Inst: PENG/peng Snaps: 64-70
-> Standard block size Pools D: default, K: keep, R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
Free Writ Buffer
Number of Pool Buffer Physical Physical Buff Comp Busy
P Buffers Hit% Gets Reads Writes Wait Wait Waits
--- ---------- ---- -------------- ------------ ----------- ---- ---- ----------
D 7,485 99 274,079 1,748 2,501 0 0 1
-------------------------------------------------------------
Instance Recovery Stats DB/Inst: PENG/peng Snaps: 64-70
-> 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 13 198 461 1373 184320 1373 N/A
E 0 13 204 462 4753 184320 4753 N/A
-------------------------------------------------------------
Buffer Pool Advisory DB/Inst: PENG/peng Snap: 70
-> Only rows with estimated physical reads >0 are displayed
-> ordered by Block Size, Buffers For Estimate
Est
Phys
Size for Size Buffers for Read Estimated
P Est (M) Factor Estimate Factor Physical Reads
--- -------- ------ ---------------- ------ ------------------
D 4 .1 499 2.1 17,388
D 8 .1 998 1.7 13,908
D 12 .2 1,497 1.4 11,604
D 16 .3 1,996 1.2 10,345
D 20 .3 2,495 1.2 9,727
D 24 .4 2,994 1.1 9,205
D 28 .5 3,493 1.1 9,003
D 32 .5 3,992 1.1 8,777
D 36 .6 4,491 1.1 8,741
D 40 .7 4,990 1.0 8,563
D 44 .7 5,489 1.0 8,468
D 48 .8 5,988 1.0 8,397
D 52 .9 6,487 1.0 8,338
D 56 .9 6,986 1.0 8,302
D 60 1.0 7,485 1.0 8,302
D 64 1.1 7,984 1.0 8,302
D 68 1.1 8,483 1.0 8,302
D 72 1.2 8,982 1.0 8,302
D 76 1.3 9,481 1.0 8,302
D 80 1.3 9,980 1.0 8,290
-------------------------------------------------------------
PGA Aggr Summary DB/Inst: PENG/peng Snaps: 64-70
-> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
--------------- ------------------ --------------------------
100.0 126 0
-------------------------------------------------------------
Warning: pga_aggregate_target was set too low for current workload, as this
value was exceeded during this interval. Use the PGA Advisory view
to help identify a different value for pga_aggregate_target.
PGA Aggr Target Stats DB/Inst: PENG/peng Snaps: 64-70
-> B: Begin snap E: End snap (rows dentified with B or E contain data
which is absolute i.e. not diffed over the interval)
-> 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 %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 16 4 83.4 0.0 .0 .0 .0 3,276
E 16 4 88.2 0.0 .0 .0 .0 3,276
-------------------------------------------------------------
PGA Aggr Target Histogram DB/Inst: PENG/peng Snaps: 64-70
-> Optimal Executions are purely in-memory operations
Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- -------------- ------------ ------------
2K 4K 3,243 3,243 0 0
64K 128K 6 6 0 0
512K 1024K 160 160 0 0
-------------------------------------------------------------
PGA Memory Advisory DB/Inst: PENG/peng Snap: 70
-> 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.8 153.6 8.0 95.0 2
16 1.0 153.6 2.0 99.0 2
19 1.2 153.6 2.0 99.0 2
22 1.4 153.6 2.0 99.0 2
26 1.6 153.6 2.0 99.0 2
29 1.8 153.6 2.0 99.0 2
32 2.0 153.6 2.0 99.0 2
48 3.0 153.6 0.0 100.0 0
64 4.0 153.6 0.0 100.0 0
96 6.0 153.6 0.0 100.0 0
128 8.0 153.6 0.0 100.0 0
-------------------------------------------------------------
Shared Pool Advisory DB/Inst: PENG/peng Snap: 70
-> 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
---------- ----- -------- ------------ ------- ------ ------- ------ -----------
52 .6 12 1,058 293 1.0 12 1.2 37,986
64 .7 23 2,176 295 1.0 10 1.0 38,204
76 .9 26 3,063 295 1.0 10 1.0 38,204
88 1.0 26 3,063 295 1.0 10 1.0 38,204
100 1.1 26 3,063 295 1.0 10 1.0 38,204
112 1.3 26 3,063 295 1.0 10 1.0 38,204
124 1.4 26 3,063 295 1.0 10 1.0 38,204
136 1.5 26 3,063 295 1.0 10 1.0 38,204
148 1.7 26 3,063 295 1.0 10 1.0 38,204
160 1.8 26 3,063 295 1.0 10 1.0 38,204
172 2.0 26 3,063 295 1.0 10 1.0 38,204
184 2.1 26 3,063 295 1.0 10 1.0 38,204
-------------------------------------------------------------
SGA Target Advisory DB/Inst: PENG/peng Snap: 70
SGA Target SGA Size Est DB Est Physical
Size (M) Factor Time (s) Reads
---------- ---------- ------------ ----------------
80 0.5 47 10,303
120 0.8 44 8,481
160 1.0 44 8,302
200 1.3 44 8,302
240 1.5 44 8,302
280 1.8 44 8,302
320 2.0 44 8,302
-------------------------------------------------------------
Streams Pool Advisory DB/Inst: PENG/peng Snap: 70
No data exists for this section of the report.
-------------------------------------------------------------
Java Pool Advisory DB/Inst: PENG/peng Snap: 70
No data exists for this section of the report.
-------------------------------------------------------------
Buffer Wait Statistics DB/Inst: PENG/peng Snaps: 64-70
-> ordered by wait time desc, waits desc
Class Waits Total Wait Time (s) Avg Time (ms)
------------------ ----------- ------------------- --------------
undo header 1 0 10
-------------------------------------------------------------
Enqueue Activity DB/Inst: PENG/peng Snaps: 64-70
No data exists for this section of the report.
-------------------------------------------------------------
Undo Segment Summary DB/Inst: PENG/peng Snaps: 64-70
-> 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) Concurcy TR (mins) OOS eS/eR/eU
---- ---------- --------------- -------- -------- --------- ----- --------------
1 .3 1,878 0 3 15/15 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Undo Segment Stats DB/Inst: PENG/peng Snaps: 64-70
-> Most recent 35 Undostat rows, ordered by 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
------------ ----------- ------------ ------- ------- ------- ----- ------------
13-Dec 05:22 3 33 0 1 15 0/0 0/0/0/0/0/0
13-Dec 05:12 4 151 0 1 15 0/0 0/0/0/0/0/0
13-Dec 05:02 102 181 0 3 15 0/0 0/0/0/0/0/0
13-Dec 04:52 5 44 0 3 15 0/0 0/0/0/0/0/0
13-Dec 04:42 5 91 0 1 15 0/0 0/0/0/0/0/0
13-Dec 04:32 4 44 0 1 15 0/0 0/0/0/0/0/0
13-Dec 04:22 5 119 0 1 15 0/0 0/0/0/0/0/0
13-Dec 04:12 1 50 0 1 15 0/0 0/0/0/0/0/0
13-Dec 04:02 41 102 0 3 15 0/0 0/0/0/0/0/0
13-Dec 03:52 2 52 0 1 15 0/0 0/0/0/0/0/0
13-Dec 03:42 5 71 0 1 15 0/0 0/0/0/0/0/0
13-Dec 03:32 0 28 0 0 15 0/0 0/0/0/0/0/0
13-Dec 03:22 11 175 0 3 15 0/0 0/0/0/0/0/0
13-Dec 03:12 0 28 0 0 15 0/0 0/0/0/0/0/0
13-Dec 03:02 50 140 0 3 15 0/0 0/0/0/0/0/0
13-Dec 02:52 2 58 0 1 15 0/0 0/0/0/0/0/0
13-Dec 02:42 7 64 0 2 15 0/0 0/0/0/0/0/0
13-Dec 02:32 4 51 0 1 15 0/0 0/0/0/0/0/0
13-Dec 02:22 3 63 0 1 15 0/0 0/0/0/0/0/0
13-Dec 02:12 3 47 0 1 15 0/0 0/0/0/0/0/0
13-Dec 02:02 50 286 0 3 15 0/0 0/0/0/0/0/0
-------------------------------------------------------------
Latch Activity DB/Inst: PENG/peng Snaps: 64-70
-> "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 Name Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
ASM db client latch 4,669 0.0 N/A 0 0 N/A
AWR Alerted Metric Eleme 24,085 0.0 N/A 0 0 N/A
Consistent RBA 1,290 0.0 N/A 0 0 N/A
FAL request queue 135 0.0 N/A 0 0 N/A
FAL subheap alocation 135 0.0 N/A 0 0 N/A
FIB s.o chain latch 14 0.0 N/A 0 0 N/A
FOB s.o list latch 122 0.0 N/A 0 0 N/A
In memory undo latch 10,772 0.0 N/A 0 2,754 0.0
JS mem alloc latch 18 0.0 N/A 0 0 N/A
JS queue access latch 18 0.0 N/A 0 0 N/A
JS queue state obj latch 48,574 0.0 N/A 0 0 N/A
JS slv state obj latch 38 0.0 N/A 0 0 N/A
KMG MMAN ready and start 2,240 0.0 N/A 0 0 N/A
KTF sga latch 22 0.0 N/A 0 2,055 0.0
KWQMN job cache list lat 70 0.0 N/A 0 0 N/A
MQL Tracking Latch 0 N/A N/A 0 150 0.0
Memory Management Latch 0 N/A N/A 0 2,240 0.0
OS process 1,266 0.0 N/A 0 0 N/A
OS process allocation 3,087 0.0 N/A 0 0 N/A
OS process: request allo 287 0.0 N/A 0 0 N/A
PL/SQL warning settings 791 0.0 N/A 0 0 N/A
SQL memory manager latch 1,042 0.0 N/A 0 2,238 0.0
SQL memory manager worka 221,844 0.0 N/A 0 0 N/A
Shared B-Tree 250 0.0 N/A 0 0 N/A
active checkpoint queue 3,992 0.0 N/A 0 0 N/A
active service list 14,612 0.0 N/A 0 2,280 0.0
archive control 137 0.0 N/A 0 0 N/A
archive process latch 2,508 0.0 N/A 0 0 N/A
cache buffer handles 118 0.0 N/A 0 0 N/A
cache buffers chains 694,220 0.0 N/A 0 6,901 0.0
cache buffers lru chain 33,864 0.0 N/A 0 2,925 0.0
cache table scan latch 0 N/A N/A 0 42 0.0
channel handle pool latc 287 0.0 N/A 0 0 N/A
channel operations paren 32,937 0.0 N/A 0 0 N/A
checkpoint queue latch 52,881 0.0 N/A 0 1,892 0.0
client/application info 5,034 0.0 N/A 0 0 N/A
commit callback allocati 136 0.0 N/A 0 0 N/A
compile environment latc 345 0.0 N/A 0 0 N/A
dml lock allocation 7,686 0.0 N/A 0 0 N/A
dummy allocation 687 0.0 N/A 0 0 N/A
enqueue hash chains 127,145 0.0 N/A 0 0 N/A
enqueues 114,504 0.0 N/A 0 0 N/A
event group latch 145 0.0 N/A 0 0 N/A
file cache latch 375 0.0 N/A 0 0 N/A
hash table column usage 333 0.0 N/A 0 22,822 0.0
hash table modification 224 0.0 N/A 0 0 N/A
job workq parent latch 0 N/A N/A 0 400 0.0
job_queue_processes free 1 0.0 N/A 0 0 N/A
job_queue_processes para 312 0.0 N/A 0 0 N/A
kks stats 539 0.0 N/A 0 0 N/A
kokc descriptor allocati 72 0.0 N/A 0 0 N/A
ksuosstats global area 460 0.0 N/A 0 0 N/A
ktm global data 31 0.0 N/A 0 0 N/A
kwqbsn:qsga 250 0.0 N/A 0 0 N/A
lgwr LWN SCN 3,069 0.0 N/A 0 0 N/A
library cache 92,254 0.0 N/A 0 0 N/A
library cache load lock 1,204 0.0 N/A 0 0 N/A
library cache lock 60,997 0.0 N/A 0 0 N/A
library cache lock alloc 3,978 0.0 N/A 0 0 N/A
library cache pin 27,897 0.0 N/A 0 0 N/A
Latch Activity DB/Inst: PENG/peng Snaps: 64-70
-> "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 Name Requests Miss /Miss (s) Requests Miss
------------------------ -------------- ------ ------ ------ ------------ ------
library cache pin alloca 1,221 0.0 N/A 0 0 N/A
list of block allocation 499 0.0 N/A 0 0 N/A
loader state object free 60 0.0 N/A 0 0 N/A
messages 51,709 0.0 N/A 0 0 N/A
mostly latch-free SCN 3,069 0.0 N/A 0 0 N/A
multiblock read objects 368 0.0 N/A 0 0 N/A
ncodef allocation latch 108 0.0 N/A 0 0 N/A
object queue header heap 4,090 0.0 N/A 0 78 0.0
object queue header oper 41,265 0.0 N/A 0 0 N/A
object stats modificatio 107 0.0 N/A 0 0 N/A
parallel query alloc buf 896 0.0 N/A 0 0 N/A
parameter list 92 0.0 N/A 0 0 N/A
parameter table allocati 355 0.0 N/A 0 0 N/A
post/wait queue 274 0.0 N/A 0 122 0.0
process allocation 287 0.0 N/A 0 145 0.0
process group creation 287 0.0 N/A 0 0 N/A
qmn state object latch 260 0.0 N/A 0 0 N/A
qmn task queue latch 1,429 7.3 1.0 0 0 N/A
redo allocation 9,867 0.0 1.0 0 9,847 0.0
redo copy 0 N/A N/A 0 9,847 0.1
redo writing 12,568 0.0 N/A 0 0 N/A
resmgr group change latc 1,022 0.0 N/A 0 0 N/A
resmgr:active threads 415 0.0 N/A 0 0 N/A
resmgr:actses change gro 205 0.0 N/A 0 0 N/A
resmgr:free threads list 409 0.0 N/A 0 0 N/A
resmgr:schema config 6 0.0 N/A 0 0 N/A
row cache objects 124,310 0.0 N/A 0 0 N/A
rules engine aggregate s 68 0.0 N/A 0 0 N/A
rules engine rule set st 136 0.0 N/A 0 0 N/A
sequence cache 775 0.0 N/A 0 0 N/A
session allocation 129,798 0.0 N/A 0 0 N/A
session idle bit 3,183 0.0 N/A 0 0 N/A
session state list latch 743 0.0 N/A 0 0 N/A
session switching 108 0.0 N/A 0 0 N/A
session timer 2,280 0.0 N/A 0 0 N/A
shared pool 52,848 0.0 N/A 0 0 N/A
shared pool sim alloc 16 0.0 N/A 0 0 N/A
shared pool simulator 30,194 0.0 N/A 0 0 N/A
simulator hash latch 35,425 0.0 N/A 0 0 N/A
simulator lru latch 2,501 0.0 N/A 0 32,352 0.0
slave class 139 0.0 N/A 0 0 N/A
slave class create 556 4.9 1.0 2 0 N/A
sort extent pool 173 0.0 N/A 0 0 N/A
state object free list 12 0.0 N/A 0 0 N/A
statistics aggregation 3,360 0.0 N/A 0 0 N/A
temp lob duration state 1 0.0 N/A 0 0 N/A
threshold alerts latch 526 0.0 N/A 0 0 N/A
trace latch 3 0.0 N/A 0 0 N/A
transaction allocation 487 0.0 N/A 0 0 N/A
transaction branch alloc 2,280 0.0 N/A 0 0 N/A
undo global data 9,012 0.0 N/A 0 0 N/A
user lock 400 0.0 N/A 0 0 N/A
-------------------------------------------------------------
Latch Sleep Breakdown DB/Inst: PENG/peng Snaps: 64-70
-> ordered by misses desc
Latch Name
----------------------------------------
Get Requests Misses Sleeps Spin Gets Sleep1 Sleep2 Sleep3
-------------- ----------- ----------- ---------- -------- -------- --------
qmn task queue latch
1,429 104 104 0 0 0 0
slave class create
556 27 27 0 0 0 0
redo allocation
9,867 3 3 0 0 0 0
-------------------------------------------------------------
Latch Miss Sources DB/Inst: PENG/peng Snaps: 64-70
-> 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 104 104
redo allocation kcrfw_redo_gen: redo alloc 0 3 0
slave class create ksvcreate 0 26 0
slave class create ksvcldel 0 1 0
-------------------------------------------------------------
Parent Latch Statistics DB/Inst: PENG/peng Snaps: 64-70
No data exists for this section of the report.
-------------------------------------------------------------
Child Latch Statistics DB/Inst: PENG/peng Snaps: 64-70
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Logical Reads DB/Inst: PENG/peng Snaps: 64-70
-> Total Logical Reads: 272,528
-> Captured Segments account for 27.7% of Total
Tablespace Subobject Obj. Logical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SYS SYSTEM I_SYSAUTH1 INDEX 7,776 2.85
SYS SYSTEM JOB$ TABLE 4,832 1.77
SYS SYSAUX WRH$_LATCH_NAME_PK INDEX 3,200 1.17
SYS SYSTEM I_HH_OBJ#_INTCOL# INDEX 2,944 1.08
SYSMAN SYSAUX MGMT_CURRENT_METRICS INDEX 2,864 1.05
-------------------------------------------------------------
Segments by Physical Reads DB/Inst: PENG/peng Snaps: 64-70
-> Total Physical Reads: 1,652
-> Captured Segments account for 47.6% of Total
Tablespace Subobject Obj. Physical
Owner Name Object Name Name Type Reads %Total
---------- ---------- -------------------- ---------- ----- ------------ -------
SYS SYSTEM TAB$ TABLE 422 25.54
SYS SYSAUX WRH$_SQL_PLAN TABLE 56 3.39
SYS SYSAUX WRH$_SYSMETRIC_SUMMA TABLE 22 1.33
SYS SYSAUX WRH$_LATCH 0748923_62 TABLE 16 .97
SYS SYSAUX WRH$_SQLSTAT 0748923_62 TABLE 16 .97
-------------------------------------------------------------
Segments by Row Lock Waits DB/Inst: PENG/peng Snaps: 64-70
-> % of Capture shows % of row lock waits for each top segment compared
-> with total row lock waits for all segments captured by the Snapshot
Row
Tablespace Subobject Obj. Lock % of
Owner Name Object Name Name Type Waits Capture
---------- ---------- -------------------- ---------- ----- ------------ -------
SYS SYSTEM SMON_SCN_TIME TABLE 6 100.00
-------------------------------------------------------------
Segments by ITL Waits DB/Inst: PENG/peng Snaps: 64-70
No data exists for this section of the report.
-------------------------------------------------------------
Segments by Buffer Busy Waits DB/Inst: PENG/peng Snaps: 64-70
No data exists for this section of the report.
-------------------------------------------------------------
Dictionary Cache Stats DB/Inst: PENG/peng Snaps: 64-70
-> "Pct Misses" should be very low (< 2% in most cases)
-> "Final Usage" is the number of cache entries being used
Get Pct Scan Pct Mod Final
Cache Requests Miss Reqs Miss Reqs Usage
------------------------- ------------ ------ ------- ----- -------- ----------
dc_awr_control 138 0.0 0 N/A 13 1
dc_database_links 13 0.0 0 N/A 0 1
dc_global_oids 591 1.9 0 N/A 0 32
dc_histogram_data 4,035 3.3 0 N/A 0 407
dc_histogram_defs 12,609 8.3 0 N/A 0 2,703
dc_object_ids 6,134 2.7 0 N/A 0 668
dc_objects 3,326 7.3 0 N/A 16 797
dc_profiles 207 0.0 0 N/A 0 1
dc_rollback_segments 809 0.0 0 N/A 0 22
dc_segments 2,991 5.7 0 N/A 12 525
dc_sequences 5 60.0 0 N/A 5 6
dc_tablespaces 6,022 0.0 0 N/A 0 6
dc_usernames 804 0.1 0 N/A 0 42
dc_users 5,370 0.0 0 N/A 0 42
outstanding_alerts 228 14.9 0 N/A 68 15
-------------------------------------------------------------
Library Cache Activity DB/Inst: PENG/peng Snaps: 64-70
-> "Pct Misses" should be very low
Get Pct Pin Pct Invali-
Namespace Requests Miss Requests Miss Reloads dations
--------------- ------------ ------ -------------- ------ ---------- --------
BODY 2,147 0.5 2,743 0.4 0 0
CLUSTER 4 0.0 5 0.0 0 0
INDEX 70 17.1 162 7.4 0 0
SQL AREA 4,118 12.7 28,229 3.5 0 0
TABLE/PROCEDURE 1,416 17.4 9,035 5.8 0 0
TRIGGER 38 0.0 627 0.0 0 0
-------------------------------------------------------------
Process Memory Summary DB/Inst: PENG/peng Snaps: 64-70
-> 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
-> ordered by Begin/End snapshot, Alloc (MB) desc
Hist
Avg Std Dev Max Max
Alloc Used Alloc Alloc Alloc Alloc Num Num
Category (MB) (MB) (MB) (MB) (MB) (MB) Proc Alloc
- -------- --------- --------- -------- -------- ------- ------- ------ ------
B Other 79.3 N/A 3.8 7.6 22 22 21 21
Freeable 3.6 .0 .9 .3 1 N/A 4 4
SQL .4 .2 .0 .0 0 2 11 9
PL/SQL .1 .1 .0 .0 0 0 19 19
E Other 82.2 N/A 3.4 7.1 22 22 24 24
Freeable 5.5 .0 .9 .2 1 N/A 6 6
SQL .4 .2 .0 .0 0 3 14 12
PL/SQL .2 .1 .0 .0 0 0 22 22
-------------------------------------------------------------
SGA Memory Summary DB/Inst: PENG/peng Snaps: 64-70
End Size (Bytes)
SGA regions Begin Size (Bytes) (if different)
------------------------------ ------------------- -------------------
Database Buffers 62,914,560
Fixed Size 1,266,392
Redo Buffers 2,924,544
Variable Size 100,666,664
-------------------
sum 167,772,160
-------------------------------------------------------------
SGA breakdown difference DB/Inst: PENG/peng Snaps: 64-70
-> ordered by Pool, Name
-> N/A 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 free memory 4.0 4.0 0.00
large PX msg pool .3 .3 0.00
large free memory 3.8 3.8 0.00
shared ASH buffers 2.0 2.0 0.00
shared CCursor 2.1 3.5 65.73
shared Heap0: KGL N/A 1.2 N/A
shared KCB Table Scan Buffer 3.8 3.8 0.00
shared KGLS heap 2.4 3.2 36.30
shared KQR M PO 1.4 2.1 50.37
shared KSFD SGA I/O b 3.8 3.8 0.00
shared KSXR receive buffers 1.0 1.0 0.00
shared KTI-UNDO 1.2 1.2 0.00
shared PCursor 1.1 1.6 43.72
shared PL/SQL DIANA 1.2 1.3 13.81
shared PL/SQL MPCODE 2.0 3.3 62.51
shared event statistics per sess 1.3 1.3 0.00
shared free memory 30.1 11.7 -61.02
shared kglsim hash table bkts 2.0 2.0 0.00
shared library cache 3.3 3.8 14.75
shared private strands 1.1 1.1 0.00
shared row cache 3.6 3.6 0.00
shared sql area 6.3 18.3 188.21
buffer_cache 60.0 60.0 0.00
fixed_sga 1.2 1.2 0.00
log_buffer 2.8 2.8 0.00
-------------------------------------------------------------
Streams CPU/IO Usage DB/Inst: PENG/peng Snaps: 64-70
No data exists for this section of the report.
-------------------------------------------------------------
Streams Capture DB/Inst: PENG/peng Snaps: 64-70
No data exists for this section of the report.
-------------------------------------------------------------
Streams Apply DB/Inst: PENG/peng Snaps: 64-70
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Queues DB/Inst: PENG/peng Snaps: 64-70
No data exists for this section of the report.
-------------------------------------------------------------
Buffered Subscribers DB/Inst: PENG/peng Snaps: 64-70
No data exists for this section of the report.
-------------------------------------------------------------
Rule Set DB/Inst: PENG/peng Snaps: 64-70
No data exists for this section of the report.
-------------------------------------------------------------
Resource Limit Stats DB/Inst: PENG/peng Snap: 70
No data exists for this section of the report.
-------------------------------------------------------------
init.ora Parameters DB/Inst: PENG/peng Snaps: 64-70
End value
Parameter Name Begin value (if different)
----------------------------- --------------------------------- --------------
audit_file_dest /oracle/admin/peng/adump
background_dump_dest /oracle/admin/peng/bdump
compatible 10.2.0.3.0
control_files /oracle/oradata/peng/control01.ct
core_dump_dest /oracle/admin/peng/cdump
db_block_size 8192
db_domain
db_file_multiblock_read_count 16
db_name peng
db_recovery_file_dest /oracle/flash_recovery_area
db_recovery_file_dest_size 4294967296
dispatchers (PROTOCOL=TCP) (SERVICE=pengXDB)
job_queue_processes 10
open_cursors 300
pga_aggregate_target 16777216
processes 150
remote_login_passwordfile EXCLUSIVE
sga_target 167772160
undo_management AUTO
undo_tablespace UNDOTBS1
user_dump_dest /oracle/admin/peng/udump
-------------------------------------------------------------
End of Report