Obtain the Oracle implicit parameter information.
The Oracle Database initialization parameters mainly come from two internal Oracle Data Dictionary tables: X $ KSPPCV and X $ KSPPI usually the V $ Parameter view we query or the show parameter command is derived from these two system tables, but the implicit parameters cannot be queried through these two methods.
X $ KSPPCV is used to record the current set value and whether the default value is used. X $ KSPPI is a basic table used to record simple information such as parameter names and descriptions. Note that the INST_ID field is used to determine the instance to which the parameter belongs in the Rac environment.
You can use the following script to query the implicit parameters of the current instance:
select x.ksppinm name, y.ksppstvl value, y.ksppstdf isdefault, decode(bitand(y.ksppstvf,7),1,'MODIFIED',4,'SYSTEM_MOD','FALSE') ismod, decode(bitand(y.ksppstvf,2),2,'TRUE','FALSE') isadjfrom sys.x$ksppi x, sys.x$ksppcv ywhere x.inst_id = userenv('Instance') and y.inst_id = userenv('Instance') and x.indx = y.indx and x.ksppinm like '%_&par%'order by translate(x.ksppinm, ' _', ' ')/
How to query implicit parameters of Oracle
SELECT x. ksppinm NAME, y. ksppstvl VALUE, x. ksppdesc describ
FROM x $ ksppi x, x $ ksppcv y
WHERE x. inst_id = USERENV ('instance ')
AND y. inst_id = USERENV ('instance ')
AND x. indx = y. indx
AND x. ksppinm LIKE '% _ skgxp_udp_timed_wait_seconds %'
Does the show parameter of ORACLE11 store the parameter file? Where are some implicit parameters stored?
Not all. spfile is only used to start oracle. Many other parameters, including implicit parameters, are stored in the oracle System View.