This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,899 Users
  • 2,269,649 Discussions


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


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.