Re: Why my query plan changed ?
- From: "jaromir nemec" <jaromir@xxxxxxxxxxxx>
- To: <ajayoraclel@xxxxxxxxx>
- Date: Tue, 16 Sep 2008 10:38:49 +0200 (CEST)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
