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