Dynamic/static Parameters

SQL> select name, ISSYS_MODIFIABLE from v$parameter;

Output:

NAME                                                                             ISSYS_MOD
-------------------------------------------------------------------------------- ---------
sga_max_size                                                                     FALSE
shared_pool_size                                                                IMMEDIATE
large_pool_size                                                                   IMMEDIATE
java_pool_size                                                                     IMMEDIATE
streams_pool_size                                                                IMMEDIATE
sga_target                                                                             IMMEDIATE
memory_target                                                                     IMMEDIATE
memory_max_target                                                             FALSE
control_files                                                                          FALSE

false -Static
Immediate -Dynamic