DBA Data[Home] [Help]

VIEW: SYS.GV_$SYSTEM_PARAMETER

Source

View Text - Preformatted

select "INST_ID","NUM","NAME","TYPE","VALUE","DISPLAY_VALUE","DEFAULT_VALUE","ISDEFAULT","ISSES_MODIFIABLE","ISSYS_MODIFIABLE","ISPDB_MODIFIABLE","ISINSTANCE_MODIFIABLE","ISMODIFIED","ISADJUSTED","ISDEPRECATED","ISBASIC","DESCRIPTION","UPDATE_COMMENT","HASH","CON_ID" from gv$system_parameter
View Text - HTML Formatted

SELECT "INST_ID"
, "NUM"
, "NAME"
, "TYPE"
, "VALUE"
, "DISPLAY_VALUE"
, "DEFAULT_VALUE"
, "ISDEFAULT"
, "ISSES_MODIFIABLE"
, "ISSYS_MODIFIABLE"
, "ISPDB_MODIFIABLE"
, "ISINSTANCE_MODIFIABLE"
, "ISMODIFIED"
, "ISADJUSTED"
, "ISDEPRECATED"
, "ISBASIC"
, "DESCRIPTION"
, "UPDATE_COMMENT"
, "HASH"
, "CON_ID"
FROM GV$SYSTEM_PARAMETER