dynamic parameter

What is difference between static and dynamic parameter in oracle database We need to check v$parameter table and find the coumn name in ISSUE_MODIFIABLE Static parameter The ISSUE_MODIFIABLE column value FALSE means parameters are static parameter Static parameter values change the value in spfile only so we need to restart the database otherwise it will be reflect on next database bounce. Must […]