Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Help with Shared Pool Problem
So you are saying there is no LRU processing taking place? Nothing is
ever aged out or overwritten?
Ron
-----Original Message-----
From: Ganesh Raja [mailto:ganesh.raja_at_gmail.com]=20
Sent: Thursday, October 14, 2004 8:33 AM
To: Smith, Ron L.
Cc: shaharul.anuar_at_intecbilling.com; oracle-l_at_freelists.org
Subject: Re: Help with Shared Pool Problem
There is No Aging happening .. Let us assume that u are Calling a Select Stmt Again and Again with different Parameters to it and also same parameters .. As Far as Oracle is concerened your stmts have not aged . They are new since it has now only been created or it has been used in the past few mins.
So oracle tries to create new space for the stmt that u are trying to parse now and it fails there ..
HTH
~
Ganesh
On Thu, 14 Oct 2004 08:08:35 -0500, Smith, Ron L. <rlsmith_at_kmg.com>
wrote:
> I know the reason for the Shared pool filling up is because the=20
> programs do not use bind variables.
>=20
>=20
>=20
>=20 >=20
>=20
>=20
>=20 >=20
>=20
>=20
>=20
> =3D =3D3D distribution or copying of the message is prohibited. Please =
let
> me know immediately by return e-mail if you have received =3D3D this=20
> message by mistake, then delete the e-mail message. Thank you.
> --
> http://www.freelists.org/webpage/oracle-l
>=20
>=20
>=20 >=20 >=20 >=20
> =3D distribution or copying of the message is prohibited. Please let =
me=20
> know immediately by return e-mail if you have received =3D this =
message=20
> by mistake, then delete the e-mail message. Thank you.
> --
> http://www.freelists.org/webpage/oracle-l
>
Important Notice!!
If you are not the intended recipient of this e-mail message, any use, =
distribution or copying of the message is prohibited.
Please let me know immediately by return e-mail if you have received =
this message by mistake, then delete the e-mail message.
Thank you.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 14 2004 - 08:43:39 CDT