Oracle DBA Tools (Revision #2)

The Oracle Database Administration (DBA) Tools provide users with the tools to administer, manage and monitor all aspects of an Oracle database. The tools may be accessed from the application DBA Tools menu or from the schema browsers context sensitive popup menu.

Following, is a list of tools provided with a description of each tools functionality.

• 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.
  => Documentation
   
• Storage Manager: Provides manageability of the Oracle tablespaces and datafiles. Allowing a user to visualize and maintained storage. Including object and file IO statistics.
  => Documentation
   
• Rollback Manager: Provides the monitoring and maintenance or rollback segments, including current statements, transactions and execution plans.
  => Documentation
   
• Log Manager: Provides manageability of Redo Logs and Archive Logs. Allows users to create and manage redo logs including monitoring archive logs.
  => Documentation
   
• Security Manager: Provides manageability of users, roles and profiles. Allowing the user to manage permissions, roles and security of the Oracle database.
  => Documentation
   
• Session Manager: Provides manageability of database sessions, including user and system locks. Allowing the user to kill/disconnect sessions, start traces and monitor open cursors and user queries with execution plans.
  => Documentation
   
• SGA Manager: Provides manageability of the Oracle SGA area, including SQL Area, Lib Cache, Lib Cache Stats and a summary of the SGA. Allowing users to also pin and unpin code.
  => Documentation
   
• Server Statistics: Provides a summary of statistics for the Oracle instance, waits and latches.
  => Documentation