Instance Parameter Configuration (ORCL)

Go Up to Data, Schema, and Miscellaneous Utilities

DBArtisan lets you configure and tune your Oracle databases. DBArtisan offers a utility that lets you view and edit the settings for each Oracle instance. DBArtisan derives its information from the system catalog. To reconfigure your Oracle instance, you must edit the parameter settings in the applicable configuration file (for example, INITORCL.ORA).

Note: After changing the settings, shut down and restart the database server for the changes to take effect.

Changing an Instance Parameter

1. On the Datasources menu, select Configure.

   DBArtisan opens the Instance Parameters dialog.

2. To modify an instance parameter, double-click the target instance parameter or click the Edit button to open the Edit Configuration dialog.

Note: To modify an instance parameter, the parameter must have a Yes in the Session Modifiable or System Modifiable column of the Instance Parameter grid.

The table below describes the options and functionality on the Edit Configuration dialog:

Option	Description
New Value	Lets you type the value for the parameter.

Extracting Instance Configuration Parameters

DBArtisan lets you extract the statements for setting and displaying your instance configuration parameters.

1. On the Explorer, select the Configuration node.

   DBArtisan displays the parameters in the right pane of the Datasource Explorer.

2. In the right pane of the Explorer, click the target parameter(s).
3. On the Explorer toolbar, click Extract.

   OR

   In the right-pane of the Explorer, right-click the parameters, and then click Extract.

   DBArtisan extracts the definition to a text window.

Generating a Report on Configuration Parameters

DBArtisan lets you generate a detailed report containing information about your instance configuration parameters. The reports derive their contents from the information displayed in the right hand side of the Datasource Explorer. To facilitate the online publication of these reports, DBArtisan generates the report in Hypertext Mark-Up Language (HTML). You can view the report directly in DBArtisan's built-in HTML-browser.

Note: For more information on generating reports, see Schema Publication.

1. On the Explorer, select the Configuration node.

   DBArtisan displays the parameters in the right pane of the Datasource Explorer.

2. In the right pane of the Explorer, click the target parameter(s).
3. On the Explorer toolbar, click Report.

   OR

   In the right-pane of the Explorer, right-click the parameters, and then click Report.

   DBArtisan opens the Report dialog.

The table below describes the options and functionality on the Report dialog:

Option	Functionality
Report Home Page File Name	To change the report home page file name, in the box, type the location and name of the file or find the file by clicking the Browse icon.
Report Title	To change the report title, in the box, type the location and name of the file or click the Browse button to find the file.