ADG_REDIRECT_DML in Oracle Active Data Guard 19c

on
0

View hidden parameters in Oracle database

on 
set linesize 200
col "Parameter" for a30
col "Session Value" for a10
col "Instance Value" for a10
col "Default value" for a5
col SESSMOD for a7
col SYSMOD for a9
col "Description" for a45
 
SELECT 
   a.ksppinm  "Parameter", 
   b.ksppstvl "Session Value", 
   c.ksppstvl "Instance Value" ,
   b.ksppstdf "Default value" ,
   decode(bitand(a.ksppiflg/256,3),1, 'True', 'False') SESSMOD,
   decode(bitand(a.ksppiflg/65536,3),1,'IMMEDIATE',2,'DEFERRED',3,'IMMEDIATE','FALSE') SYSMOD,
   a.ksppdesc "Description" 
FROM
   sys.x$ksppi a, 
   sys.x$ksppcv b , 
   sys.x$ksppsv c 
WHERE 
   a.indx = b.indx 
   and a.indx = c.indx 
   and substr(ksppinm,1,1)=’_'  
ORDER BY 
   a.ksppinm;

SYSMODE system modifiable IMMEDIATE ALTER SYSTEM without restarting the instance
DEFERRED ALTER SYSTEM regardless of the type of parameter file used in the instance startup.
FALSE parameter cannot be changed with ALTER SYSTEM unless the database runs on a spfile
SESSMOD session modifiable

Comments

Post a Comment