Here’s an extract from a report of activity in an Oracle session that I’ve just been running. Spot the anomaly:
Name Value
---- -----
session cursor cache hits 3
parse count (total) 5
parse count (hard) 31
execute count 35
There are no tricks involved with this output, though the database activity is a little unusual, and I haven’t faked any numbers. So how come I’ve got more “hard parses” than “parses” ? (more…)
