Setting Oracle SP File

14Feb08

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 “<oracle parameter>”=<value> scope=spfile;

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

DELETE:

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

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

All parameter will be active after you restart the database.

Advertisements


3 Responses to “Setting Oracle SP File”

  1. I do believe all the concepts you’ve presented on your post. They’re very convincing and can definitely work.

    Still, the posts are very short for novices. May just you please prolong them a bit from next time?
    Thanks for the post.

  2. Hello there, You have done a fantastic job.
    I’ll certainly digg it and personally suggest to my friends.

    I am confident they’ll be benefited from this site.

  3. Have you ever thought about including a little bit more than just
    your articles? I mean, what you say is valuable and all.
    But think of if you added some great pictures or videos to give
    your posts more, “pop”! Your content is excellent but with images
    and clips, this site could definitely be one of the best in its niche.
    Awesome blog!


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


%d bloggers like this: