SQL> alter system set max_idle_time=50 scope=spfile;
System altered.
SQL> show parameter max_idle_time
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_idle_time integer 0
SQL>
SQL>
SQL> select value from v$system_parameter where name='max_idle_time';
VALUE
--------------------------------------------------------------------------------
0
SQL>
SQL> select value from v$parameter where name='max_idle_time';
VALUE
--------------------------------------------------------------------------------
0
SQL>
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
--------------------------------------------------------------------------------
50
SQL> select value from v$parameter where name='max_idle_time';
VALUE
--------------------------------------------------------------------------------
50
