Obtain the Oracle implicit parameter information.

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.