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.
|
 Oracle DBA Tools
 Oracle DBA Tools - Context Menu |
