본문 바로가기

Database/Oracle

44 - [Oracle 19C] V$SPPARAMETER

 

 

# shutdown immediate;

[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--r-- 1 oracle oinstall 1054 11월 22 13:14 test.ora
-rw-r----- 1 oracle oinstall 3584 11월 24 11:21 spfileorcl.ora
-rw-rw---- 1 oracle oinstall 1544 11월 24 12:01 hc_orcl.dat
[oracle@test dbs]$

# startup;

[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--r-- 1 oracle oinstall 1054 11월 22 13:14 test.ora
-rw-rw---- 1 oracle oinstall 1544 11월 24 12:03 hc_orcl.dat
-rw-r----- 1 oracle oinstall 3584 11월 24 12:03 spfileorcl.ora
[oracle@test dbs]$ echo 'after start'
after start

 

 

 

  • V$SPPARAMETER displays information about the contents of the server parameter file. 

If a server parameter file was not used to start the instance, 
then each row of the view will contain FALSE in the ISSPECIFIED column

 

SQL> show con_name;
CON_NAME
------------------------------
CDB$ROOT


SQL> select name,value,isses_modifiable , issys_modifiable , ispdb_modifiable ,ISDEFAULT,con_id
from V$system_PARAMETER where name='open_cursors';

NAME		VALUE		ISSES_MODIFIABLE     ISSYS_MODIFIABLE	  ISPDB_MODIFIABLE     ISDEFAULT     CON_ID
--------------- --------------- -------------------- -------------------- -------------------- --------- ----------
open_cursors	410		FALSE		     IMMEDIATE		  TRUE		       FALSE		  0
open_cursors	500		FALSE		     IMMEDIATE		  TRUE		       FALSE		  3


SQL> alter system set open_cursors=310 container=all scope=memory;
System altered.


SQL> select name,value,isses_modifiable , issys_modifiable , ispdb_modifiable ,ISDEFAULT,con_id
from V$system_PARAMETER where name='open_cursors';

NAME		VALUE		ISSES_MODIFIABLE     ISSYS_MODIFIABLE	  ISPDB_MODIFIABLE     ISDEFAULT     CON_ID
--------------- --------------- -------------------- -------------------- -------------------- --------- ----------
open_cursors	310		FALSE		     IMMEDIATE		  TRUE		       FALSE		  0


col family for a10
col sid for a10
col name for a20
col type for a10
col value for a10
col display_value for a20
col isspecified for a15
col ordinal clear
col update_comment for a20
col con_id for clear

SQL> select * from V$SPPARAMETER where name='open_cursors';

FAMILY	   SID	      NAME		   TYPE       VALUE	 DISPLAY_VALUE	      ISSPECIFIED	 ORDINAL UPDATE_COMMENT 	  CON_ID
---------- ---------- -------------------- ---------- ---------- -------------------- --------------- ---------- -------------------- ----------
	   *	      open_cursors	   integer    410	 410		      TRUE		       1			       1