Database Administration (MOSC)

MOSC Banner

Can an execution plan have different hash values at different timeof execution ?

edited Dec 7, 2009 8:47AM in Database Administration (MOSC) 2 commentsAnswered
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center