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!

Optimizer Dynamic Sampling in SQL execution plan - Slow execution of SQL

SivaRam AvvaruApr 14 2025

Hi,

When i checked execution plan of one SQL which is running out of SLA, i saw dynamic sampling = 8 in execution plan.

How to disable it ? is it good or bad ? i need to disable it. Seems like its affecting performance.

Comments
Post Details
Added on Apr 14 2025
3 comments
146 views