Getting all parameters in the database? Easy to do.

Easy to do:

select      p.name, p.value value,

            decode(p.isDefault, 'TRUE', 'YES', 'FALSE', 'NO') "DEFAULT",

            p.description,

            decode(p.isses_modifiable, 'IMMEDIATE', 'YES', 'FALSE', 'NO', 'DEFERRED', 'NO', 'YES') ses_modifiable,

            decode(p.issys_modifiable, 'IMMEDIATE', 'YES', 'FALSE', 'NO', 'DEFERRED', 'YES', 'YES') sys_modifiable,

            decode(p.issys_modifiable, 'DEFERRED', 'TRUE', 'FALSE') issys_modifiable,

            p.update_comment

from        v$parameter p

where       p.name not like 'nls%'

Results:

Output example There are a lot of more parameters, not included here because the size in the blog:

NAME	O7_DICTIONARY_ACCESSIBILITY
VALUE	FALSE
DEFAULT	YES
DESCRIPTION	Version 7 Dictionary Accessibility Support
SES_MODIFIABLE	NO
SYS_MODIFIABLE	NO
ISSYS_MODIFIABLE	FALSE
UPDATE_COMMENT