Re: Caching sql query not happening

I am looking at the SQL area and this has

load count 335
parse calls 335
executions 335

and it seems that it is being parsed every time.

Vikas
----- Original Message -----
From: "Paul Baumgartel" <paul.baumgartel_at_gmail.com> To: <g_vikas_at_hotmail.com>
Cc: <oracle-l_at_freelists.org>
Sent: Friday, June 03, 2005 4:17 PM
Subject: Re: Caching sql query not happening

> What's your evidence that it's never stored in the shared pool? Do
> you not find it in V$SQL/V$SQLAREA after a parse?
>
>
> --=20
> Paul Baumgartel
> paul.baumgartel_at_aya.yale.edu
>
> On 6/3/05, Vikas Gautam <g_vikas_at_hotmail.com> wrote:
>>=20
>> > Does anyone know why a statement such as:
>> >
>> > SELECT ID
>> > FROM ELSR dups
>> > WHERE (dups.directoryID =3D :"SYS_B_0"
>> > AND dups.DeviceIdentifier =3D :"SYS_B_1"
>> > AND dups.serviceStartTime BETWEEN TIMESTAMP:"SYS_B_2" AND
>> > TIMESTAMP:"SYS_B_3")
>> >
>> > will never cache in the Shared Pool?
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l