Obtain Oracle implicit parameter information

Obtain 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. However, 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') isadj
From
Sys. x $ ksppi x,
Sys. x $ ksppcv y
Where
X. inst_id = userenv ('instance') and
Y. inst_id = userenv ('instance') and
X. indx = y. indx and
X. ksppinm like '% _ & par %'
Order
Translate (x. ksppinm ,'_','')
/

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian