Database (237) 썸네일형 리스트형 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.. 31 - [Oracle 19C] v$parameter VS v$parameter2 SQL> show con_name CON_NAME ------------------------------ CDB$ROOT col name for a20 col open_mode for a20 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE -------------------- -------------------- PDB$SEED READ ONLY ORCLPDB READ WRITE V$PARAMETER show info about the PARAMETERs that are currently in effect for the session --note: when the issys_modifiable=FALSE, this mean it is static par.. 30 - [Oracle 19C] Alter session example, save state Save the PDB state: SQL> select con_name, state from dba_pdb_saved_states;CON_NAME STATE-------------------- --------------ORCLPDB OPENSQL> alter pluggable database pdb10 save state;Pluggable database altered.SQL> select con_name, state from dba_pdb_saved_states;CON_NAME STATE-------------------- --------------ORCLPDB OPENPDB10 OPEN SQL> show pdbs CON_ID CON_NAME.. 이전 1 ··· 23 24 25 26 27 28 29 30 다음
