DB03 & SPFILE<SID>.ORA

[Former Member]

Hi All,

I've little confusion. I've configured total 51 parameters in my spfile<sid>.ora (some parameters are carried from the time of installation and some are set through brtools) & those all parameters are also reflecting in init<sid>.ora. I've verified the spfile & init.ora both at OS level & found that there is only 51 parameters are included.

But when I'm trying to view output of "Active Parameters" from T-code DB03, it gives me a list of around 250 parameters.

I'm confused about this inconsistency in the result of DB03 & actual spfile parameters. Need your help to understand the difference of output.

Regards,

Neehir Bhatt

[sunny_pahuja2 · Accepted solution]

Hi,

Some of oracle parameters are active with their default value. Check below link:

http://help.sap.com/saphelp_nw04/helpdata/en/df/455eb1747111d6b25100508b6b8a93/content.htm

Thanks

Sunny