statement caching in oracle

From: <miso_pach_at_my-deja.com>
Date: Thu, 11 Jan 2001 23:28:46 GMT
Message-ID: <93lfj4$274$1@nnrp1.deja.com>

In my java program i repetedly call certain queries. I would like to take advantage of a statement cache, so that these queries would not have to be parsed by the database every time and thus improve the performance.

I am using the latest JDBC thin driver (8.1.7), which provides API for setting the size of the clients statemet cache. This works fine with a physical instance of a PooledConnection. However if am trying to use it in combination with OracleConnectionCacheImpl class I will only get access to logical connections which don't let you set their statement cache. I tried calling

                setStmtCacheSize()

on the OracleConnectionCacheImpl which didn't work. The prepare statement on the 2nd connection just hanged. The first connection was bizzarly fine..

How can I set the statement cache for all connection created by the OracleConnectionCacheImpl class?

Insted of setting this from the java program I could surly set the connection cache somehow for the whole database. How do I do that? This could be a workaround if the oracle's java API doesn't let me do it.

any responses would be appreciated.

thanks,

Miso

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 11 2001 - 17:28:46 CST