[c3p0-users] Statement cache hit ratio

[Philip Z. <ph...@cl...>]

Hi there,

I'm trying to find cache hit ratios on my statement cache, and I'm having
trouble finding the metrics.  Do they exist?

I'm using Hibernate, and I'm seeing from heap dumps that I have lots of
queries in the statement cache, with various numbers of ?'s in statements
like "SELECT ... FROM ... WHERE id IN (?, ?, ?, ..., ?)"  I'm trying to
figure out how big of an issue that is.

Thanks!

Cheers,

-- Philip