Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

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

The database is 11.2.0.3 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.

Comments

Pavan Kumar
Hi,
The value of "session cursor cache hits" is bigger than "parse count (total)".
Yes, certainly just increasing the count on successfull hit of cursor found in library cache (session specific cursor), perhaps parse count(total) does not include all hard parses.

- Pavan Kumar N
Nikolay Savvinov
Hi
Subtract this statistic from "parse count (total)" to determine the real number of parses that occurred
can you provide a link to the source?

Best regards,
Nikolay
847540
Hi,

I think this is interesting for you to read:
http://jonathanlewis.wordpress.com/2007/07/03/parse-calls/#comment-39792

Regards
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 4 2013
Added on Nov 15 2012
#general-database-discussions
3 comments
1,262 views