AWR: time model statistics and instance activity stats
hi men,
why there is a difference on the statistic "parse time elapsed" between "Time Model Statistics" and "Instance Activity Stats" ?
Time Model Statistics DB/Inst: PROD/PROD1 Snaps: 36907-36908
-> Total time in database user-calls (DB Time): 14741.7s
-> Statistics including the word "background" measure background process
time, and so do not contribute to the DB time statistic
-> Ordered by % or DB time desc, Statistic name
Statistic Name Time (s) % of DB Time
------------------------------------------ ------------------ ------------
sql execute elapsed time 13,068.3 88.6
DB CPU 7,823.7 53.1
parse time elapsed 1,545.2 10.5
hard parse elapsed time 1,415.0 9.6
and
Instance Activity Stats DB/Inst: PROD/PROD1 Snaps: 36907-36908
Statistic Total per Second per Trans
-------------------------------- ------------------ -------------- -------------
index fast full scans (full) 93,194 107.7 3.3
index fast full scans (rowid ran 0 0.0 0.0
index fetch by key 60,533,931 69,971.6 2,128.9
index scans kdiixs1 11,340,290 13,108.3 398.8
leaf node 90-10 splits 61 0.1 0.0
leaf node splits 705 0.8 0.0
lob reads 84 0.1 0.0
lob writes 110 0.1 0.0
lob writes unaligned 110 0.1 0.0
logons cumulative 715 0.8 0.0
messages received 100,846 116.6 3.6
messages sent 100,846 116.6 3.6
no buffer to keep pinned count 0 0.0 0.0
no work - consistent read gets 92,275,158 106,661.6 3,245.1
opened cursors cumulative 264,176 305.4 9.3
parse count (failures) 8 0.0 0.0
parse count (hard) 49,952 57.7 1.8
parse count (total) 1,799,634 2,080.2 63.3
parse time cpu 83,941 97.0 3.0
parse time elapsed 105,650 122.1 3.7
thank's so much by advance.