Odd problem with cache...

Giganews Newsgroups
Subject: Odd problem with cache...
Posted by:  Alfons Ã…berg (kno…@ms.xom)
Date: Tue, 5 Sep 2006

At my job we have an odd problem with and 8.1.7 DB.

We've a Java JDBC quuery, which uses bind variables. One the first execute
the performance is slow - succeding fast. Now, starting a new browser
session and executing the exact same piece of code - the above pattern
happens again. Should the query be cached at this point?

I should mentioned that this behaviour occours at  both our development
systems and our production environment. Both with very little user
activity - hence the cache shouldn't be flushed in between.

Do Oracle keep a kind of session cache or what?

Regards, Alfman

Replies