Re: Why my query plan changed ?

Hi,
> I am seeing lot of query plans are changing in database.
> I am not
> doing any changes in database(No DDL) and periodically taking snapshot
> of sql(v$sql) queries and their plans(v$sql_plan) from memory. I am
> comparing with sql_id if any plan changed and I often get plan changed
> messages.

You didn't mention your policy of gathering object statistics. Change in statistics can lead to switch of execution plan as well.

regrads,

Jaromir

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