Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Caching sql query not happening

Caching sql query not happening

From: Vikas Gautam <g_vikas_at_hotmail.com>
Date: Fri, 3 Jun 2005 16:09:32 -0500
Message-ID: <BAY101-DAV10F455A661FF14CC527CAA91070@phx.gbl>

> Does anyone know why a statement such as:
>
> SELECT ID
> FROM ELSR dups
> WHERE (dups.directoryID = :"SYS_B_0"
> AND dups.DeviceIdentifier = :"SYS_B_1"
> AND dups.serviceStartTime BETWEEN TIMESTAMP:"SYS_B_2" AND
> TIMESTAMP:"SYS_B_3")
>
> will never cache in the Shared Pool?
>
> In other words, even though all of the parameters are bind variables, this
> will always be parsed seperately, and never cache.
>
> Thanks
> Vikas

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 03 2005 - 17:14:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US