Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Sasa PetkovicOct 4 2021

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.

Comments
Post Details
Added on Oct 4 2021
1 comment
3,934 views