When a query is cached, any parameter values entered at execution time are included in the QueryCacheEntryKey, and queries with dissimilar values are cached separately. For example, if the same query is executed twice, each time with different parameter values, two entries are created in the QueryCache. If the query is executed again with parameters that were already used, the query should be found in cache.

Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices