분류 전체보기 (658) 썸네일형 리스트형 39 - [Oracle 19C] CONTAINER clause in alter system ISSES_MODIFIABLE is false that means you cannot change it in the session, but you can change it. ISSYS_MODIFIABLE(system modifiable) is immediate. This means that I can change the value in the memory level. FALSE: You can only change the value with a static parameter using scope=spfile. In other words, the change will take effect from the next restart of the database. IMMEDIATE: If you change th.. 38 - [Oracle 19C] Default scope in alter system Alter system set parameter=value - If a server parameter file was used to start up the database, then BOTH is the default. Alter system set parameter=value same as Alter system set parameter=value scope=both - If a parameter file was used to start up the database, then MEMORY is the default, as well as the only scope you can specify. Alter system set parameter=value same as Alter system set para.. 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 -------------------------------------------.. 36 - [Oracle 19C] To alter system example(spfile) 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> S.. 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 val.. 34 - [Oracle 19C] To create pfile and starting with spfile/init_.ora SQL> create pfile='test.ora' from spfile; File created. [oracle@test dbs]$ ls -ltr 합계 28 -rw-r--r-- 1 oracle oinstall 3079 5월 14 2015 init.ora -rw-r----- 1 oracle oinstall 24 11월 11 01:00 lkORCL -rw-r----- 1 oracle oinstall 2048 11월 14 16:58 orapworcl -rw-r--r-- 1 oracle oinstall 1035 11월 22 11:37 initorcl.ora -rw-r----- 1 oracle oinstall 3584 11월 22 12:19 spfileorcl.ora -rw-rw---- 1 oracle oins.. 33 - [Oracle 19C] To create pfile and starting with spfile/init_.ora To create pfile from spfile [oracle@test dbs]$ pwd /u01/app/oracle/product/19/db_1/dbs [oracle@test dbs]$ ls -ltr 합계 20 -rw-r--r-- 1 oracle oinstall 3079 5월 14 2015 init.ora -rw-r----- 1 oracle oinstall 24 11월 11 01:00 lkORCL -rw-r----- 1 oracle oinstall 2048 11월 14 16:58 orapworcl -rw-rw---- 1 oracle oinstall 1544 11월 21 14:21 hc_orcl.dat -rw-r----- 1 oracle oinstall 3584 11월 21 14:21 spfileorc.. 32 - [Oracle 19C] V$SYSTEM_PARAMETER vs V$SYSTEM_PARAMETER2 V$SYSTEM_PARAMETER is the view which shows instance level parameters (and these are what all new sessions inherit) ISDEFAULT Indicates (TRUE) - whether the parameter is set to the default value from the instance or (FALSE)- the parameter value was specified in the parameter file (spfile or pfile) col name for a50 col value for a50 col isses_modifiable for a20 col issys_modifiable for a20 col isp.. 이전 1 ··· 23 24 25 26 27 28 29 ··· 83 다음
