Skip to Content
avatar image
Former Member

DB03 & SPFILE<SID>.ORA

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 24, 2009 at 08:30 AM

    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

    Add comment
    10|10000 characters needed characters exceeded