How to identify any parameter as static or dynamic using v$aparameter || ISSYS_MODIFIABLE

Hi Friends,

Welcome you back on exiting topic, Today’s session is on

How to identify any parameter as static or dynamic?
Answer: Check for v$parameter we can find one column ie. ISSYS_MODIFIABLE

Parameters basics: key-value pair
db_block_siz(key)=8K(value)
db_name(key)=DEVDB(value)

SQL] select ISSYS_MODIFIABLE from v$parameter where name like '%utl_file_dir%';
ISSYS_MOD
---------
FALSE=======================================static
alter system set processes=200 scope=spfile;
alter system set sessions=500 scope=spfile;

SQL] select ISSYS_MODIFIABLE from v$parameter where name like '%log_archive_dest_2';
ISSYS_MOD
---------
IMMEDIATE==================================dynamic
alter system set open_cursors=500 scope=both;
alter system set awr_snapshot_time_offset=2 scope=both;

Please do follow me and support me on,

Blog: https://mallik034.blogspot.com/
LinkedIn:   / mallikarjun-ramadurg-397a751a  
twitter:   / mallik034  
instagram:   / mallik034  

Regards,
Mallikarjun Ramadurg
Mobile: +966 543796525
WhatsApp: +91 9880616848
Blog: https://mallik034.blogspot.com/
LinkedIn:   / mallikarjun-ramadurg-397a751a  
twitter:  / mallik034  
instagram:  / mallik034