Fetching Environment variables using SQL.

We can get the Oracle Environment variables through the view "V$parameter".

select * from v$parameter where name ='db_cache_size';


The columns
1) ISSES_MODIFIABLE VARCHAR2(5) Indicates whether the parameter can be changed with ALTER SESSION (TRUE) or not (FALSE)


2) ISSYS_MODIFIABLE VARCHAR2(9) Indicates whether the parameter can be changed with ALTER SYSTEM and when the change takes effect