Skip to Main Content

Oracle Database Discussions


For appeals, questions and feedback about Oracle Forums, please email Please ask technical questions in the appropriate category. Thank you!

about "session cursor cache hits" and "parse count(total)" statistics

872581Nov 15 2012 — edited Dec 7 2012
Hi, all.

The database is on a linux.

The following is from v$sysstat.
select * from v$sysstat
where name in
('session cursor cache hits',
'parse count (total)',
'parse count (hard)')

session cursor cache hits : 346468246
parse count (total) :        184787866
parse count (hard) :          35299555

* "session cursor cache hits" definition :

Number of hits in the session cursor cache. A hit means that the SQL statement did not have to be reparsed. Subtract this statistic from "parse count (total)" to determine the real number of parses that occurred.

which means that (parse count(total) - session cursor cache hits = real number of parses.


The value of "session cursor cache hits" is bigger than "parse count (total)".

How does it possibile?

Thanks in advance.

Best Regards.
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 4 2013
Added on Nov 15 2012