Oracle DBA Tools - Instance Manager Provides manageability of the Oracle instance allowing the user to view and modify server parameters. Including the monitoring and backup of the Oracle controlfile. | |
Toolbar Operations - Depending on the Tab selected, there are different Toolbar Operations available. Available Operations for General Tab Available Operations for Controlfile tab Available Operations for Oracle Parameters, Hidden Parameters, and NLS Parameters tabs Available Operations for Jobs tab | |
General Tab - Provides a summary of the Oracle instance DB Name: Name of the database | |
Controlfile Tab - Provides Oracle controlfile information Control Files: Shows the control files available | |
Oracle Parameters Tab - Displays Oracle instance parameters Option: Name of the parameter Setting: Value of the parameter Default: Indicates whether the parameter is set to the default value or the parameter value was specified in the parameter file. Description: Description of the parameter Session Modifiable: Indicates whether the parameter can be changed with ALTER SESSION System Modifiable: Indicates whether the parameter can be changed with the ALTER SYSTEM and the change takes effect immediately Deferred: Indicates whether the parameter can be changed with the ALTER SYSTEM and the change effect is deferred | |
Hidden Parameters Tab - Displays Oracle instance hidden parameters Same as Oracle parameters. | |
NLS Parameters Tab - Provides Globalization (National Language) Support parameters. Scope: Specifies the scope of the parameter with values of DATABASE, INSTANCE or SESSION. Parameter: The name of the NLS parameter. Value: The value of the NLS parameter. | |
Jobs Tab (ONLY Oracle 10g AND ABOVE) - Allows viewing, creating, altering, dropping, starting and stopping of jobs using DBMS_SCHEDULER package. Job Name: Name of the job |