Even typing db_f doesn’t help, still empty list. Is that intended?
Also, when I log in as SYS and select the “Include undocumented parameters” option, I get
Error: ORA-01790: expression must have same datatype as corresponding expression
Here’s the query Toad generates:
select i.instance_name instance, 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,
‘NO’ as plug_modifiable,
p.update_comment
from gv$parameter p, gv$instance i
where p.name not like ‘nls%’
and i.inst_id = 1
and i.inst_id = p.inst_id
union all
select nam.inst_id instance,
nam.ksppinm name,
val.ksppstvl value,
val.ksppstdf “DEFAULT”,
nam.ksppdesc description,
decode(bitand(nam.ksppiflg/256,1), 1,‘YES’, ‘NO’) ses_modifiable,
decode(bitand(nam.ksppiflg/65536,3), 1,‘YES’, 2,‘YES’ , 3,‘YES’, ‘NO’) sys_modifiable,
decode(bitand(nam.ksppiflg/65536,3), 2,‘TRUE’, ‘FALSE’) issys_modifiable,
‘NO’ as plug_modifiable,
val.ksppstcmnt update_comment
from x$ksppi nam, x$ksppsv val
where nam.indx = val.indx
and nam.inst_id = 1
and not exists (select null from v$parameter p where p.num-1 = nam.indx)
order by 2, 1