V$PARAMETER definition in Oracle Database 11.2
V$PARAMETER
select
NUM, -- NUM NUMBER
NAME, -- NAME VARCHAR2(80)
TYPE, -- TYPE NUMBER
VALUE, -- VALUE VARCHAR2(4000)
DISPLAY_VALUE, -- DISPLAY_VALUE VARCHAR2(4000)
ISDEFAULT, -- ISDEFAULT VARCHAR2(9)
ISSES_MODIFIABLE, -- ISSES_MODIFIABLE VARCHAR2(5)
ISSYS_MODIFIABLE, -- ISSYS_MODIFIABLE VARCHAR2(9)
ISINSTANCE_MODIFIABLE, -- ISINSTANCE_MODIFIABLE VARCHAR2(5)
ISMODIFIED, -- ISMODIFIED VARCHAR2(10)
ISADJUSTED, -- ISADJUSTED VARCHAR2(5)
ISDEPRECATED, -- ISDEPRECATED VARCHAR2(5)
ISBASIC, -- ISBASIC VARCHAR2(5)
DESCRIPTION, -- DESCRIPTION VARCHAR2(255)
UPDATE_COMMENT, -- UPDATE_COMMENT VARCHAR2(255)
HASH -- HASH NUMBER
from
GV$PARAMETER
where
inst_id = USERENV('Instance')