Re: Caching sql query not happening

From: Paul Baumgartel <paul.baumgartel_at_gmail.com>
Date: Fri, 3 Jun 2005 17:17:11 -0400
Message-ID: <f8c47710506031417652900a@mail.gmail.com>

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

Received on Fri Jun 03 2005 - 17:22:07 CDT