Tuesday, July 26, 2011

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.

1 comment:

sap upgrade testing said...

Indeed, wonderful tutorial on "Setting Oracle SP File". The best thing is you explained everything step by step which simplified all the things.