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
Refresh: Refreshes all tabs in the instance manager from the database
Reconnect: Reconnects to the database server
Copy All w/ Headers and Row count: Copies every data from the tab selected to paste the information anywhere else needed
Find: Find tool to search the grid of the current tab
Find Next: Finds the next instance of the previous find

Available Operations for Controlfile tab
Refresh: Refreshes all tabs in the instance manager from the database
Reconnect: Reconnects to the database server
Copy All w/ Headers and Row count: Copies every data from the tab selected to paste the information anywhere else needed
Find: Find tool to search the grid of the current tab
Find Next: Finds the next instance of the previous find
Backup Controlfile: Backup the Oracle Controlfile

Available Operations for Oracle Parameters, Hidden Parameters, and NLS Parameters tabs
Refresh: Refreshes all tabs in the instance manager from the database
Reconnect: Reconnects to the database server
Copy All w/ Headers and Row count: Copies every data from the tab selected to paste the information anywhere else needed
Find: Find tool to search the grid of the current tab
Find Next: Finds the next instance of the previous find
Edit Server Parameter: Edits the value of the currently selected parameter

Available Operations for Jobs tab
Refresh: Refreshes all tabs in the instance manager from the database
Reconnect: Reconnects to the database server
Copy All w/ Headers and Row count: Copies every data from the tab selected to paste the information anywhere else needed
Find: Find tool to search the grid of the current tab
Find Next: Finds the next instance of the previous find
Create Job: Creates a Job
Alter Job: Edits the selected job
Drop Job: Drops the selected Job
Job Properties: Shows the properties of the selected job
Start Job: Starts selected job
Stop Job: Stops selected job
Enable Job: Enables selected job
Disable Job: Disables selected job

General Tab - Provides a summary of the Oracle instance

Property: Shows the name of the property
Value: Shows the value of the property

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

Control Files: Shows the control files available
Control File Information: Shows detailed information about the Control File
Control File Statistics: Shows different statistics from the Control Files


Oracle DBA Tools - Instance Manger - ControlFile Tab


 
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

Oracle DBA Tools - Instance Manager - Parameters Tab


 
Hidden Parameters Tab - Displays 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.

Job Name: Name of the job
Job Owner: Shows the owner of the job
Job Type: Indicates the type of the job
Job Class: Indicates the class of the job
Enabled: Indicates whether the job is enabled or not
State: Indicates the state of the job (Scheduled, Disabled, etc)
Schedule Type: Indicates the type of schedule the job uses
Start Date: Shows the date and time the job starts
End Date: Shows the date and time the job ends


Oracle DBA Tools - Instance Manager - Jobs Tab



  • No labels