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
'Database > Oracle' 카테고리의 다른 글
| 39 - [Oracle 19C] CONTAINER clause in alter system (0) | 2023.11.23 |
|---|---|
| 38 - [Oracle 19C] Default scope in alter system (0) | 2023.11.23 |
| 36 - [Oracle 19C] To alter system example(spfile) (0) | 2023.11.23 |
| 35 - [Oracle 19C] To alter system example(memory) (1) | 2023.11.23 |
| 34 - [Oracle 19C] To create pfile and starting with spfile/init_.ora (1) | 2023.11.22 |
