hello guys i really need some help here
i need to unset a parameter in oracle
in my case, optimizer_dynamic_sampling
if i execute show parameter optimizer_dynamic_sampling i get the value 6, but trying to remove it, i get the error that the parameter is not defined in spfile
which seems to be trye
as i've create the pfile from spfile and can't find the parameter there
so my question is, if the parameter is not set by the spfile, what is setting the parameter then?