Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

Oracle Parameters Page

To open the Oracle Parameters page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. Click Configuration & Memory | Oracle Parameters.

Actions on the Parameters Grid

Action Description
Select Show hidden parameters

Display all Oracle parameters.

Note: Not applicable to Oracle 11g Release 2 and above. For Oracle 11g Release 2 and above the hidden parameters not shown have retained their default value.

Double click on a parameter

  • or right click and select Modify parameter
  • or highlight a parameter and click Modify parameter

Change the value of a parameter.


  • You must have administrator privileges.
  • You can alter only parameters that are displayed in black
  • This opens the Edit Oracle Parameter dialog.

Parameters Grid

The Oracle Parameters grid displays global variables that can alter the way Oracle works.

Column Description


The name of the parameter.


The value of the parameter.

Is default?

Whether the current value is the default value.

Sys modifiable? Whether the parameter can be changed via ALTER SYSTEM.
Description A short description of the parameter.
Adjusted? Whether the RDBMS has adjusted the user's input value to a more suitable value.
Modified If the parameter is changed via ALTER SESSION, the value is MODIFIED. If the parameter is changed via ALTER SYSTEM, the value is SYS_MODIFIED. Otherwise, the value is NO.

Session modifiable

Whether the parameter can be changed via ALTER SESSION.

Type The parameter type: Boolean, String, or Integer.

Edit Oracle Parameter dialog

Open this dialog from the Parameters grid.

Option Description

Parameter value

Enter a new value for the Oracle parameter.


Define the scope of the change.

  • Memory - The change is applied in memory only.
  • SPFile - The change is applied in the server parameter file only. For all parameters, the change is effective at the next startup and is persistent.
  • Both - The change is applied in both the server parameter file and memory.

Make the change. The value of the parameter is updated immediately.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating