35 - [Oracle 19C] To alter system example(memory)

 

 

 

SQL> show parameter max_idle_time

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
max_idle_time			     integer	 0


SQL> alter system set max_idle_time=30 scope=memory;
System altered.


SQL> show parameter max_idle_time

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
max_idle_time			     integer	 30
SQL>

 

 

 

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

VALUE
--------------------------------------------------------------------------------
30


SQL> select value from v$system_parameter where name='max_idle_time';

VALUE
--------------------------------------------------------------------------------
30

 

 

 

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.


SQL> startup;
ORACLE instance started.

Total System Global Area 1526723608 bytes
Fixed Size		    9135128 bytes
Variable Size		  939524096 bytes
Database Buffers	  570425344 bytes
Redo Buffers		    7639040 bytes
Database mounted.
Database opened.


SQL> select value from v$system_parameter where name='max_idle_time';

VALUE
--------------------------------------------------------------------------------
0

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

VALUE
--------------------------------------------------------------------------------
0