Today I needed to set the optimizer_dynamic_sampling in several sessions to a lower value. It was set to 5, which is way too high for this application. I used what is below. begin for cur in (select sid,serial# from v$session…
Today I needed to set the optimizer_dynamic_sampling in several sessions to a lower value. It was set to 5, which is way too high for this application. I used what is below. begin for cur in (select sid,serial# from v$session…