To open the Oracle Parameters page
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
|
Change the value of a parameter. Notes:
|
Parameters Grid
The Oracle Parameters grid displays global variables that can alter the way Oracle works.
Column | Description |
---|---|
Name |
The name of the parameter. |
Value |
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. |
Scope |
Define the scope of the change.
|
Update |
Make the change. The value of the parameter is updated immediately. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center