When your database expands or when usage patterns change, you can adjust database configuration settings to improve performance, provide more storage, and so on.

You are logged in to your organization as a DBA or application developer with appropriate privileges on the database.

The database is running.


In the organization's Manage & Monitor pane, select the database group.


Right-click the database name, and select Properties.


Click the DB Configuration tab and view the current settings, using the scroll bar as necessary.


Click Edit.

The top section of the dialog box shows the database configuration templates. Some settings have drop-down menus from which you select new values, while others allow you to enter new values in text fields. A restart icon marks the settings that require restarting the database to take effect.

To change resource settings, click the Resource Settings tab, and select the check box in the Override column.

To change database settings, click the Database Settings tab, and select the check box in the Override column.

You can use the Database Calculator to calculate new settings based on the current database usage and requirements.


When you finish, click OK to close the DB Configuration dialog box.


Click OK to accept your changes.


If you changed settings that require a database restart, right-click the database name, and select Power > Restart.