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: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a
twitter: https://twitter.com/mallik034
instagram: https://www.instagram.com/mallik034/

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