Re: same sql_id with different plan_hash_value
Date: Fri, 23 Mar 2012 16:38:11 -0700
A child number will be generated if AUTH_CHECK_MISMATCH occurs too for the same sql_id / query.
On Fri, Mar 23, 2012 at 12:49 PM, Dba DBA <oracledbaquestions_at_gmail.com>wrote:
> 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.