Setting Oracle SP File

Q: I am running SAP Netweaver 7 with Oracle 10g. I would like to add new Oracle parameter and delete some parameter base on SAP Notes recommendation. How should I do that?

Answer:

1. You can edit using BRSPACE, by running command from OS: > brspace -f dbparam

2. OR, you can add/edit or delete the parameter from SQL Plus:

ADD / EDIT:

SQL> alter system set “”= scope=spfile;

example: SQL> alter system set “OPTIMIZER_INDEX_COST_ADJ”=10 scope=spfile;

DELETE:

SQL> alter system reset “” scope = spfile sid = ‘*’;

exampler: SQL> alter system reset “_push_join_predicate” scope = spfile sid = ‘*’;

All parameter will be active after you restart the database.