Parameters whose value we cannot change while the instance is up and running are called “Static Parameters”.
e.g : sga_max_size and sessions etc.
Parameters whose value we can change while instance is up and running are called “Dynamic Parameters”.
e.g : db_cache_size and shared_pool_size etc.