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 -
Refresh : Will refresh all tabs in the instance manager from the database
Edit Server Parameter: Edit the value of the currently selected parameter
Backup Controlfile: Backup the Oracle Controlfile
Find: Find tool to search the grid of the current tab
Find Next: Find the next instance of the previous find
|
General Tab -
Provides a summary of the Oracle instance
DB Name: Name of the database
Instance Name: Name of the instance
Host Name: Hostname of the server
Version: Version of the Oracle instance
Startup Time: Date and time of when the server was last started
Uptime: The duration the server has been running
Restricted Mode: Specifies whether instance is in restricted mode
Archive Log Mode: Specifies whether archive log is enabled
Banner: Instance banner information from v$version
|
 Oracle DBA Tools - Instance Manger - General Tab |
Controlfile Tab -
Provides Oracle controlfile information
|
 Oracle DBA Tools - Instance Manger - ControlFile Tab |
Oracle Parameters Tab -
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
|
 Oracle DBA Tools - Instance Manager - Parameters Tab |
Hidden Parameters Tab -
Oracle instance hidden parameters
Same as Oracle parameters.
|
 Oracle DBA Tools - Instance Manager - Hidden Parameters Tab |
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.
|
Oracle DBA Tools - Instance Manager - NLS Parameters Tab
|
Jobs Tab (ONLY Oracle 10g AND ABOVE) - Allows viewing, creating, altering, dropping, starting and stopping of jobs using DBMS_SCHEDULER package.
|
Oracle DBA Tools - Instance Manager - Jobs Tab
|
