Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Add a new Db Parameter

Hi All,

The System is Netweaver 04. It is a BW System.

Database is Oracle 9.2.0.6.0 on Win Server 2003 server.

OSS Note 632556 recommends me to set the following parameters in my BW system.

The following parameters which start with an underscore viz. do not exist in my Database profile parameters(Transaction Code DB26),

BTREE_BITMAP_PLANS

ELIMINATECOMMON_SUBEXPR

OPTIMIZERJOIN_SEL_SANITY_CHECK

OPTIMIZEROR_EXPANSION

OPTIMPEEK_USER_BINDS

PGAMAX_SIZE

SORTELIMINATION_COST_RATIO

Can you please tell me how to create these new database parameters in my system? Can we create new database parameters & is it recommended or allowed to create new parameters in the system? I know how these parameters effect the system performance.

Thank you all,

Regards,

Bob.

Former Member
Not what you were looking for? View more on this topic or Ask a question