Oracle OCP题库解析（10）
Which statement regarding the contents of the V$PARAMETER view is true?A) displays only the list of default valuesB) displays only the list of all basic parametersC) displays the currently in effect parameter valuesD) displays only the list of all advanced parametersE) displays the list of all the parameter files of a databaseF) displays the current contents of the server parameter fileAnswer: C通过查询v$FIXED_VIEW_DEFINITION ,可以发现v$parameter源自GV$PARAMETERSQL> select view_definition from v$fixed_view_definition a where a.VIEW_NAME='V$PARAMETER';VIEW_DEFINITION------------------------------------------------------------------------------------------------------------------------selectNUM , NAME , TYPE , VALUE , DISPLAY_VALUE, ISDEFAULT , ISSES_MODIFIABLE , ISSYS_MODIFIABLE , ISINSTANCE_MODIFIABLE, ISMODIFIED , ISADJUSTED , ISDEPRECATED, DESCRIPTION, UPDATE_COMMENT, HASHfrom GV$PARAMETER where inst_id = USERENV('Instance') 而GV$PARAMETER源自x$ksppi,x$ksppcv两个X$表。x$ksppi,x$ksppcv 基本上包含所有数据库可调整参数，v$parameter展现的是不包含"_"开头的隐含参数。{:6_263:}
页:
[1]