Can an execution plan have different hash values at different timeof execution ?
Hi,
I am just checking the explain plan for a query fired by a user in oracle database. The user gave me a plan which he generated by tracing his own session. When I generate the plan for the same sql by logging into that user, it gives me same plan but with different hash value. I am generating the plan using synta as 'explan plan for >sql_statement>; Can someone explain this?
Thanks,
Amit
I am just checking the explain plan for a query fired by a user in oracle database. The user gave me a plan which he generated by tracing his own session. When I generate the plan for the same sql by logging into that user, it gives me same plan but with different hash value. I am generating the plan using synta as 'explan plan for >sql_statement>; Can someone explain this?
Thanks,
Amit
0