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!

Optimizer Dynamic Sampling Not turning Off

user125779Nov 29 2010 — edited Nov 29 2010

Hi

We have Oracle 11.1.0.7 on Windows , we are using Spatial Module .

I had gathered statistics some time which gave us better Performance. Users were complaining of poor performance , when i checked the execution plan , i notices that Oracle is executing the query by using plan generated by Dynamic Sampling .

I changed the parameter optimizer_dynamic_sampling to 0. However its not turning the dynamic sampling off , i checked the execution plan its still showing 'Dynamic Sampling Used for this Statement'.

Please advise.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 27 2010

Added on Nov 29 2010

#general-database-discussions

4 comments

225 views