Child cursors for same sql id not using base line on Exadata

Sasa Petkovic

Hi,

I have some sql_id and for the same sql id exist two different cursors .

One cursor is using base line with good execution plan but another cursor not.

Is there any trick i could force that all cursors are using same execution plan?

I have to mention that there are no any bind variables used for the query, except that one query (child cursor) is running under context of db job.

Luís Gustavo Lira

Hi,

we would need to analyze your specific case, but you have the option of fixing the plan with DBMS_SPM.alter_sql_plan_baseline.

attribute_name => 'fixed'

attribute_value => 'YES'