Database Administration (MOSC)

MOSC Banner

parameter.issys_modifiable for some hidden parameters

edited Nov 16, 2021 9:49AM in Database Administration (MOSC) 2 comments

Hello!


Can You please kindly explain,

how to determine the possibility of dynamic updates of some hidden parameters ?

why the view v$parameter.issys_modifiable don't reflect this information?


 select

 a.ksppinm "Parameter",

 decode(p.isses_modifiable,'FALSE',NULL,NULL,NULL,b.ksppstvl) "Session",

 c.ksppstvl "Instance",

 decode(p.isses_modifiable,'FALSE','F','TRUE','T') "S",

 p.issys_modifiable,

 decode(p.isdefault,'FALSE','F','TRUE','T') "D",

 a.ksppdesc "Description"

from x$ksppi a, x$ksppcv b, x$ksppsv c, v$parameter p

where a.indx = b.indx and a.indx = c.indx

 and p.name(+) = a.ksppinm

 and a.ksppinm in (

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center