data base parameter

[Former Member]

Dear all,

I have conducted RSRV test tor the InfoCube( In BW). All test results are OK except data base parameters. The following message is displayed.

ORACLE: Parameter HASH_JOIN_ENABLED is set to value FALSE (recommended value is TRUE)

where can I rectify the above problem ?

[Former Member · Accepted solution]

Hi,

Please follow SAP Note :

180605 - Oracle database parameter settings for BW

Regards,

Wojtek

[Former Member · Accepted solution]

Thanks for your help. I found the correct parameter. But where can I set these parameters ?

[Former Member · Accepted solution]

log on to windows as <SID>adm ,start command prompt,type brtools and press ENTER

It will start BRTOOLS (sap oracle management tools)

See brtools SAP help on : http://help.sap.com/saphelp_nw04/helpdata/en/0c/cd271365debc42bef96ac7fd907787/frameset.htm