same sql_id with different plan_hash_value
- From: Dba DBA <oracledbaquestions@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 23 Mar 2012 15:49:29 -0400
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
