messages
sent 67,830 80.5 0.9
no buffer to keep pinned
count 0 0.0 0.0 no work - consistent read
gets 14,240,381 16,892.5 188.4
opened cursors
cumulative 84,306 100.0 1.1 parse count
(failures) 6,074 7.2 0.1 parse count
(hard) 6,090 7.2 0.1 parse count
(total) 191,531 227.2 2.5
通过parse count (hard)和parse count (total)，可以计算soft parse率为： 100-100*(parse count (hard)/parse count (total)) =100-100*(1-6090/191531)=96.82
parse time
cpu 44 0.1 0.0 parse time
elapsed 635 0.8 0.0 physical
reads 26,524 31.5 0.4
physical reads
direct 288 0.3 0.0 physical
writes 87,993 104.4 1.2
physical writes
direct 128 0.2 0.0
physical writes non
checkpoint 29,010 34.4 0.4 pinned buffers
inspected 0 0.0 0.0 prefetch clients -
default 0 0.0 0.0 prefetched
blocks 16,550 19.6 0.2 prefetched blocks aged out
before 0 0.0 0.0 process last non-idle
time 0 0.0 0.0
recursive
calls 1,398,277 1,658.7 18.5 recursive cpu
usage 27,349 32.4 0.4 redo blocks
written 749,639 889.3 9.9 redo buffer allocation
retries 13 0.0 0.0
redo
entries 1,343,828 1,594.1 17.8
redo log space
requests 19 0.0 0.0 redo log space wait
time 38 0.1 0.0 redo ordering
marks 0 0.0 0.0 redo
size 355,818,888 422,086.5 4,706.2
redo synch
time 10,483 12.4 0.1 redo synch
writes 74,372 88.2 1.0 redo
wastage 15,765,096 18,701.2 208.5
redo write
time 6,171 7.3 0.1 redo writer latching
time 3 0.0 0.0
redo
writes 67,055 79.5 0.9
rollback changes - undo records
a 250 0.3 0.0
rows fetched via
callback 310,070 367.8 4.1 session connect
time 0 0.0 0.0 session cursor cache
count 1,818 2.2 0.0 session cursor cache
hits 168,798 200.2 2.2 session logical
reads 19,558,052 23,200.5 258.7 session pga
memory 549,909,680 652,324.7 7,273.4
Instance Activity Stats for DB: ORA92 Instance: ora92 Snaps: 13 -14
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
session pga memory
max 1,185,992,768 1,406,871.6 15,686.5 session uga memory 3,015,076,014,672 ############## ############
session uga memory
max 175,484,416 208,166.6 2,321.0 shared hash latch upgrades - no
w 675,962 801.9 8.9 shared hash latch upgrades -
wait 3,460 4.1 0.1
sorts
(disks) 0 0 0
磁盘排序一般不能超过5％。如果超过5％，需要设置参数PGA_AGGREGATE_TARGET或者 SORT_AREA_SIZE，注意，这里SORT_AREA_SIZE是分配给每个用户的，PGA_AGGREGATE_TARGET则是针对所有的session的一个总数设置。
sorts
(memory) 180,293 213.9 2.4
内存中的排序数量
sorts
(rows) 511,574 606.9 6.8
summed dirty queue
length 430 0.5 0.0 switch current to new
buffer 59,534 70.6 0.8