HI All,
I would like to know which parameter is static and dynamic, what based we are deciding the parameter as static and dynamic.
Please correct me if go wrong
Static : If it is static we need to change in PFILE and restart the Database.
Dynamic : If it is dynamic, either we can change in PFILE or use command like ALTER SYSTEM set parameter<>.....scope=.... and please let me know what is the difference between ALTER SYSTEM and ALTER SESSION commands.
Please clarify the above details and thanks in advance...
Regards
Narender B