Forum Stats

  • 3,767,811 Users
  • 2,252,720 Discussions
  • 7,874,334 Comments

Discussions

How can I tell if client result cache is working?

adi999
adi999 Member Posts: 12
edited Jun 18, 2015 7:50AM in Oracle Call Interface (OCI)

I've recently been having a discussion on the ODP.net thread about client results cache and I've been directed to ask the question on this thread.

Using client result cache with ODP still shows as execution on AWR, is the cache working?

I know I've got the client results cache switched on (hint in query, parameter set, database restarted), and the explain plan shows that the results are being served from cache, but I still see the queries showing as executed in the EM graphs and AWR reports. I wouldn't expect that if the query never left the application server?

So, how can I tell if a query sent from my application was a hit on the client results cache, or the result cache on the server?

Cheers,

Adrian

This discussion has been closed.