Re: Cost Based Optimizer
- From: Connor McDonald <mcdonald.connor@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 20 May 2005 08:52:08 +0800
- dynamic sampling
- session parameters (multi-block read, sort size, optimizer_ind_....,
optimizer_mode)
If you run an explain with event 10053 set, the top part of the trace
dumps out a list of parameters that may have had an influencing effect
hth
connor
On 5/20/05, Terry Barnett <tbarne@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>=20
>=20
> I am having issues with execution plans changing even though the
> statistics on tables are kept static. Can anyone give me any information
> on the dynamic factors which are taken into account by the CBO when
> determining an execution plan and how one could detect that a plan may
> be about to change.
>=20
> Regards,
> Terry
>=20
>=20
>=20
--=20
Connor McDonald
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D
email: connor_mcdonald@xxxxxxxxx
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
--
//www.freelists.org/webpage/oracle-l
Other related posts:
