Cost Based Optimizer

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.

Regards,
Terry

=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=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

This email and any files transmitted
with it are confidential and intended
solely for the use of the individual
or entity to whom they are addressed.

If you have received this email in=20
error please notify Landmark=20
Information Group on +44(0) 1392=20
441700.

For more information about the=20
Landmark Information Group visit
http://www.landmark-information.co.uk

This email and any attachments have
been scanned for viruses and to the
best of our knowledge are clean.
=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=3D=3D=3D=3D=3D=3D=3D=3D=3D

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