Parameters which require DB bounce.
In v$parameter we can find one column ie. ISSYS_MODIFIABLE. This column contains three phases: 1) Immediate 2) Deferred 3) False 1. Immediate : We can change the parameter in fly database ie Dynamic.(only need to change the value no need to bounce) 2. DEFERRED : We can change the parameter in fly database but this … Read more