Forum Stats

  • 3,824,767 Users
  • 2,260,416 Discussions
  • 7,896,309 Comments

Discussions

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

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.

Answers