Question: what is difference between static parameter and dynamic parameter in oracle?
Answer: static are the parameters those won't take effect immediately the value is set. Application Server restart is required for them take effect. dynamic are the parameters those will take effect immediately value set in the run time. Application server restart not required for them take effect.