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.

2 comments:

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.

Shruti Ramalingam said...

Thanks for the great information ,was looking for this information from long.Great blog SAP Basis Training in Chennai