same sql_id with different plan_hash_value

From: Dba DBA <>
Date: Fri, 23 Mar 2012 15:49:29 -0400
Message-ID: <>

When I query v$sql_plan, I see some SQL_IDs with different plan_hash_value. I thought if the plan changed while the query was cached, it would generate a child_number.
When would a query generate a new child number, vs. a new plan_hash_value? I have one query with

2 plan_hash_value

first plan_hash_value has 3 child_numbers second one has 2.

Received on Fri Mar 23 2012 - 14:49:29 CDT

Original text of this message