Database Administration (MOSC)

MOSC Banner

Hidden Parameters default value

edited Jul 14, 2017 5:00AM in Database Administration (MOSC) 2 commentsAnswered

Hi,

I have run the below query to find the default value for the hidden parameters, but not understanding the meaning for  the   (b.ksppstdf  Default_T_F).   What it is indicating especially for the parameter :_smm_auto_min_io_size.  Basically I am wondering why that parameter default value showing as "TRUE" when current  and default values are different.

Could you please shed the light on it?.  Your help is very much appreciated. 

SELECT
ksppinm   name,
ksppstvl  Current_Value,
b.ksppstdfl Default_Value,
b.ksppstdf  Default_T_F
FROM
x$ksppi a,
x$ksppsv b
WHERE
a.indx=b.indx

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