Page History

Oracle Database Administration Tools

Aqua Data Studio provides database administration tools for the Oracle database. To access the Oracle DBA Tools, you may use the Application menu under DBA Tools->Oracle->[Tool]. You may also access the Oracle DBA Tool by selecting the context popup menu on the schema browser and select DBA Tools->[Name].

The tools consist of 8 tools to manage every aspect of an Oracle database. The tools include:

• 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.
  
   

• Storage Manager: Provides manageability of the Oracle tablespaces and datafiles. Allowing a user to visualize and maintained storage. Including object and file IO statistics.
  

• Rollback Manager: Provides the monitoring and maintenance or rollback segments, including current statements, transactions and execution plans.
  

• Log Manager: Provides manageability of Redo Logs and Archive Logs. Allows users to create and manage redo logs including monitoring archive logs.
  

• Security Manager: Provides manageability of users, roles and profiles. Allowing the user to manage permissions, roles and security of the Oracle database.
  

• 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.
  

• 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.
  

• Server Statistics: Provides a summary of statistics for the Oracle instance, waits and latches.