AquaFold, Inc.

Oracle DBA Database Administration Tools

Aqua Data Studio offers a suit of Oracle Database Administration Tools for the monitoring, maintaining and tuning of the Oracle server. It includes an Instance Manager, Storage Manager, Rollback Manager, Log Manager, Security Manager, Session Manager, SGA Manager and Server Statistics tool. These managers allow the monitoring and maintenance of Tablespaces, Rollbacks, Database Objects, Sessions, Users and Permissions via GUI.


Aqua Data Studio Oracle Administration Tools Include:

Oracle1 Instance Manager

Provides GUI view Search and Modify access for:

- General Instance Parameters (DB Name, Host Name, Instance Name, Version, Uptime, Startup Time etc. )
- Control Files, Control File statistics
- Oracle Parameters (257 database parameters)
- Hidden Parameters (1124 parameters)
- NLS Parameters
- Oracle Jobs Information

Oracle Rollback Manager

Provides GUI view Search and Modify access for:

- View Rollback Segment Properties
- Create Rollback Segment
- Alter Rollback Segment
- Drop Rollback Segment

Oracle Security Manager

Provides GUI view Search and Modify access for:

- Tree View for Users, Roles, Profiles
- View Properties of User, Role, Profile
- Create User, Role, Profile
- Alter User, Role, Profile
- Drop User, Role, Profile

Oracle Session Manager

Provides GUI view Search and Modify access for:

- View list of sessions, session details, statistics, locks, current statements, open cursors, session long operations
- Disconnect Session
- Kill Session
- Trace Session

Auto refresh data in specified intervals

Views of dynamically changed data such as Server Statistics, Session Manager, SGA manager can be set for automatic refresh with intervals from 1 second and up.

Oracle Storage Manager

Provides GUI view Search and Modify access for:

- Tree table
- Tablespaces
- Datafiles
- Objects
- Fragmentation
- File IO Statistics
- Objects IO Statistics

Oracle Log Manager

Provides GUI view Search and Modify access for:

- View Redo Log Group Properties
- Create Redo Log Group
- Alter Redo Log Group
- Drop Redo Log Group
- Switch Log File
- Take Checkpoint
- View Archive Logs Properties

Oracle SGA Manager

Provides GUI view and Search for:

- SQL Area
- Lib Cash Parameters
- Lib Cash Statistics
- SGA Statistics
- Chart Representation of SGA and Shared Pool statistics

Oracle Server Statistics

Provides GUI view and Search for:

- Instance Statistics
- Waits details
- Latches details

References

  1. ^ Oracle Database Wikipedia article.
    Oracle Corporation Wikipedia article.

Home • Aqua Data Studio • Aqua Data Server • AquaClusters • Support • Store • Company • Privacy

Copyright © 2001–2012 AquaFold, Inc. All Rights Reserved.