--

-- List all database parameters.

--

SET PAUSE ON

SET PAUSE 'Press Return to Continue'

SET PAGESIZE 60

SET LINESIZE 300

COLUMN name  FORMAT A30

COLUMN value FORMAT A70

COLUMN ses_mod FORMAT a10

COLUMN sys_mod FORMAT a10

COLUMN ins_mod FORMAT a10

SELECT p.name,

       p.type,

       p.value,

       p.isses_modifiable as SES_MOD,

       p.issys_modifiable as SYS_MOD,

       p.isinstance_modifiable as INS_MOD

FROM   v$parameter p

ORDER BY p.name

/