ODP.NET Statement caching

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Tue, 22 Nov 2005 20:19:10 +0100
Message-ID: <43836f2f$0$24900$ba620e4c@news.skynet.be>

In ODP.NET, it is possible to enable "statement caching" at the creation of the connection string.
This is from the docs :

Statement Cache Size
Enables Statement Caching and sets the
cache size, that is, the maximum number of statements that can be cached

I don't really understand this - on what level is the caching done ? Do they mean caching of sql statements in the shared pool ? Or is this some server-side caching on the application server ?

Matthias Received on Tue Nov 22 2005 - 13:19:10 CST