select * from v$system_parameter
-- SQL Plus: SQL> SHOW PARAMETER -- Request SELECT NAME,VALUE,ISSES_MODIFIABLE,ISSYS_MODIFIABLE FROM gv$PARAMETER WHERE NAME LIKE '%processes%';