Tuning parameters recommended for Oracle

About this task

Some Oracle parameters must be changed from their default values for Build Forge to run correctly.
Note: If you change these parameters after Build Forge is installed and running, stop Build Forge before making the changes. Restart Build Forge after you restart the database server.

Procedure

  1. Set the tuning parameters. Run the following commands:
    ALTER SYSTEM SET open_cursors=1000 SCOPE=BOTH
    ALTER SYSTEM SET processes=500 SCOPE=BOTH
    Note: If you get the message "SQL Error: ORA-02095: specified initialization parameter cannot be modified" when you run ALTER SYSTEM SET processes=500 SCOPE=BOTH, use ALTER SYSTEM SET processes=500 SCOPE=SPFile instead.

    See Oracle documentation for more information on the effects of these settings.

  2. Restart the database server. This step is required to put the parameters into effect. Be sure there are no sessions running on the database first.

Feedback