List All Database Parameters
-- -- 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 /