same sql_id with different plan_hash_value
From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Fri, 23 Mar 2012 15:49:29 -0400
Message-ID: <CAE-dsOJ6MywZLG2SfsQtyU5UTw5FQQaaFh+poMZ0d2xwLVuvWQ_at_mail.gmail.com>
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
Date: Fri, 23 Mar 2012 15:49:29 -0400
Message-ID: <CAE-dsOJ6MywZLG2SfsQtyU5UTw5FQQaaFh+poMZ0d2xwLVuvWQ_at_mail.gmail.com>
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-lReceived on Fri Mar 23 2012 - 14:49:29 CDT