Oracle Initialization Parameters Source
Author: eygle
Source: http://blog.eygle.com
Date: January 08, 2005
«A small gathering - tepub friends | blog Home | Oracle Data Dictionary Description»
Many people are fascinated by the source of the initialization parameters through V $ Parameter. There are two aspects, one is that Oracle is very hidden; one is that we are not deeply in-depth.
We should track as follows: 1. V $ Parameter
Select * from V $ fixed_view_definition a where a.view_name = 'v $ parameter'
V $ PARAMETER select NUM, NAME, TYPE, VALUE, ISDEFAULT, ISSES_MODIFIABLE, ISSYS_MODIFIABLE, ISMODIFIED, ISADJUSTED, DESCRIPTION, UPDATE_COMMENT from GV $ PARAMETER where inst_id = USERENV ( 'Instance')
2.GV $ Parameter
Select * from V $ fixed_view_definition a where a.view_name = 'gv $ parameter';
GV $ Parameter Select X.inst_ID, X.indx 1, KSPPINM, KSPPITY, KSPPSTVL, KSPPSTDF, DECODE (Bitand (Ksppiff / 256, 1), 1, 'True', 'False'), DECODE (Bitand (KSPPIFLG / 65536, 3), 1, 'Immediate', 2, 'DeferRed', 3, 'Immediate', 'False'), Decode (Bitand (Ksppstvf, 7), 1, 'Modified', 4, 'System_MOD', ' False '), Decode (Bitand (Ksppstvf, 2), 2,' True ',' False '), Ksppdesc, KsppstCmnt from x $ ksppi x, x $ ksppcv y where (x.indx = y.indx) and (( Translate (ksppinm, '_', '#') Not Like '#%') or (ksppstdf = 'false')))
X $ KSPPI, X $ KSPPCV basically contains all database adjustable parameters, V $ Parameter is displayed not containing the parameters of the beginning of the _ beginning. We are often referred to as an implicit parameters in the beginning of the _tead, which is generally not recommended, but many is widely known because of the powerful use of power.
Take a summary of a full-scale thing out, describe the Oracle's view structure and organization.
