Question on stored outline and same SQL with different CHILD

Hi

We have a few questions on a particular case where a particular SQL was narrowed down to be worked on from performance perspective

One of the DBAs in the group provided us with the following information about that SQL

select SQL_ID,child_number,plan_hash_value,elapsed_time,is_obsolete,last_active_time,parsing_schema_name,sql_profile

from v$sql where sql_id='02hu3cyq8u9ww'

SQL_ID        CHILD_NUMBER PLAN_HASH_VALUE ELAPSED_TIME   IS

                                                               OBSOLETE LAST_ACTI PARSING_SCHEMA_NAME               SQL_PROFILE

------------- ------------ --------------- ------------ - --------- -----------------------------------------------------------

02hu3cyq8u9ww     0          311643817       2223703425 N 11-MAR-16 SUR