SQL with multiple plan hash value
700284May 8 2009 — edited May 8 2009Why would a SQL has various plan hash value , if it is executed from the same user id .
The columns referenced in the where clause are indexed .
One of the column in the select list is of varchar2(4000).
Select distinct plan_hash_value , dhsp.object_owner
from DBA_HIST_SQL_PLAN dhsp where sql_id = '53q29yzqngxsg'
and object_owner = 'OWNER_NEW'
PLAN_HASH_VALUE OBJECT_OWNER
--------------- ------------------------------
4051319526 OWNER_NEW
3769542639 OWNER_NEW
3153237866 OWNER_NEW
596110799 OWNER_NEW
1386469711 OWNER_NEW
707819092 OWNER_NEW
Note :
The cursor_sharing is force in this instance