apps-infra

    Forum Stats

  • 3,874,057 Users
  • 2,266,667 Discussions
  • 7,911,707 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

apps-infra