Re: same sql_id with different plan_hash_value

From: GovindanK <gkatteri_at_gmail.com>
Date: Fri, 23 Mar 2012 16:38:11 -0700
Message-ID: <CAPb52X75eR1GDBu7is6YdC=1voJrWZWpjx0-6-33+s5X4Ufz7w_at_mail.gmail.com>

A child number will be generated if AUTH_CHECK_MISMATCH occurs too for the same sql_id / query.
HTH
GovindanK

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.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 23 2012 - 18:38:11 CDT