RE: histograms, buckets, and bind variables

This is actually something I've never quite understood.

...so with 9i bind variables don't completely prevent parsing correct? ...they just make a softer hard/soft parse?=20

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Gogala, Mladen Sent: Wednesday, November 17, 2004 11:31 AM To: 'ryan_gaffuri_at_comcast.net'; oracle-l_at_freelists.org Subject: RE: histograms, buckets, and bind variables

Ryan, the problem you are talking about is an 8i problem. Version 9, especially 9.2 developed so called peeping Tom feature which makes optimizer peek into the bind variables for the SQL the first time SQL is executed. Values of those bind variables are then used to compute a plan.

--
Mladen Gogala
A & E TV Network
Ext. 1216




> -----Original Message-----

> From: ryan_gaffuri_at_comcast.net [mailto:ryan_gaffuri_at_comcast.net]

> Sent: Wednesday, November 17, 2004 11:07 AM

> To: oracle-l_at_freelists.org

> Subject: histograms, buckets, and bind variables

>=20
>=20


> I could have swarn I read that if you use bind variables oracle=20

> ignores histograms. We are noticing different query plans based on the




> number of buckets our histograms have while our queries are using bind




> variables.

> One of the guys did a 10053 trace and added up the cost oracle is=20

> calculating and it is changing based on number of buckets even when=20

> bind variables are used.

>=20


> anyone else notice this?=20

>=20


> --

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

>=20
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l