37 - [Oracle 19C] To alter system example(both)

 

 

 

SQL> alter system set max_idle_time=20 scope=both;
System altered.


SQL> select value from v$parameter where name='max_idle_time';
VALUE
--------------------------------------------------------------------------------
20

 

 

 

 

 

SQL> alter system reset max_idle_time scope=both;
System altered.


SQL> select value from v$parameter where name='max_idle_time';
VALUE
--------------------------------------------------------------------------------
0

 

 

 

• The option is removed