Oracle Database Discussions

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!

dynamic sampling

don123Jan 28 2019 — edited Jan 29 2019

I have set the parameter optimizer_dynamic_sampling=10. I have read some articles that we can observe dynamic sampling in the explain plan.

Is there any way to see that dynamic sampling is used in run time ?

Will it reflect the status in ALL_TAB_STATISTICS ?

Do i need to unlock the stats using exec DBMS_STATS.UNLOCK_SCHEMA_STATS to enable dynamic sampling ?

Thanks.

This post has been answered by AndrewSayer on Jan 28 2019

Jump to Answer

Added on Jan 28 2019

#general-database-discussions

9 comments

304 views