bstat/estat - statistics
avg # of connections: 7
Statistic Total Per Transact Per Logon Per Second
--------------------------- ------------ ------------ ------------ ------------
CPU used by this session 392 392 56 8.52
CPU used when call started 392 392 56 8.52
CR blocks created 7 7 1 .15
SQL*Net roundtrips to/from 10039 10039 1434.14 218.24
background timeouts 45 45 6.43 .98
buffer is not pinned count 12178 12178 1739.71 264.74
buffer is pinned count 300 300 42.86 6.52
bytes received via SQL*Net 692250 692250 98892.86 15048.91
bytes sent via SQL*Net to c 2505184 2505184 357883.43 54460.52
calls to get snapshot scn: 210 210 30 4.57
calls to kcmgas 7 7 1 .15
calls to kcmgcs 3 3 .43 .07
cluster key scan block gets 113 113 16.14 2.46
cluster key scans 69 69 9.86 1.5
commit cleanouts 23 23 3.29 .5
commit cleanouts successful 23 23 3.29 .5
consistent changes 7 7 1 .15
consistent gets 12316 12316 1759.43 267.74
cursor authentications 14 14 2 .3
data blocks consistent read 7 7 1 .15
db block changes 140 140 20 3.04
db block gets 164 164 23.43 3.57
deferred (CURRENT) block cl 6 6 .86 .13
enqueue releases 88 88 12.57 1.91
enqueue requests 83 83 11.86 1.8
execute count 188 188 26.86 4.09
free buffer requested 2155 2155 307.86 46.85
logons cumulative 4 4 .57 .09
messages received 4 4 .57 .09
messages sent 4 4 .57 .09
no work - consistent read g 12006 12006 1715.14 261
opened cursors cumulative 117 117 16.71 2.54
parse count (hard) 27 27 3.86 .59
parse count (total) 132 132 18.86 2.87
parse time cpu 26 26 3.71 .57
parse time elapsed 26 26 3.71 .57
physical reads 2152 2152 307.43 46.78
physical reads direct 16 16 2.29 .35
physical writes 16 16 2.29 .35
physical writes direct 16 16 2.29 .35
physical writes non checkpo 16 16 2.29 .35
prefetched blocks 1819 1819 259.86 39.54
process last non-idle time 371381205 371381205 53054457.86 8073504.46
recursive calls 2626 2626 375.14 57.09
recursive cpu usage 19 19 2.71 .41
redo blocks written 81 81 11.57 1.76
redo entries 86 86 12.29 1.87
redo size 46860 46860 6694.29 1018.7
redo synch time 4 4 .57 .09
redo synch writes 3 3 .43 .07
redo wastage 1044 1044 149.14 22.7
redo write time 9 9 1.29 .2
redo writes 4 4 .57 .09
rollbacks only - consistent 7 7 1 .15
rows fetched via callback 22 22 3.14 .48
session connect time 371381205 371381205 53054457.86 8073504.46
session logical reads 12480 12480 1782.86 271.3
session pga memory 791460 791460 113065.71 17205.65
session pga memory max 791460 791460 113065.71 17205.65
session uga memory -2240 -2240 -320 -48.7
session uga memory max 117628 117628 16804 2557.13
sorts (disk) 2 2 .29 .04
sorts (memory) 40 40 5.71 .87
sorts (rows) 3128 3128 446.86 68
table fetch by rowid 293 293 41.86 6.37
table fetch continued row 28 28 4 .61
table scan blocks gotten 11686 11686 1669.43 254.04
table scan rows gotten 100002 100002 14286 2173.96
table scans (long tables) 1 1 .14 .02
table scans (short tables) 2 2 .29 .04
total file opens 5 5 .71 .11
user calls 10049 10049 1435.57 218.46
user commits 1 1 .14 .02
Questions or comments ? Send a note to Kyle Hailey