Types of "init.ora" parameters

There are 2 types of init.ora parameters.

1.Implicit parameters

2.Explicit parameters

 

Implicit parameters by default assumes value as per oracle.

 

Explicit parameters are those parameters we define explicitly in the init.ora.

Explicit parametes are furthur divided into

1.Static Parameters

2.Dynamic Parameters

 

Parameters whos value we cannot change while instance is up and running are called as "static

parameters".

e.g : sga_max_size

                sessions

Parameters whos value we can change while instance is up and running are called as "dynamic

parameters".

e.g : db_cache_size

                shared_pool_size