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
