Brand

Oracle DBA Database Administration Tools

Aqua Data Studio offers a suite 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
  • Rollback Segment View, Create, Alter, Drop

Oracle Security Manager

Provides GUI view Search and Modify access for:

  • Tree View for Users, Roles, Profiles
  • Users View, Create, Alter, Drop
  • Roles View, Create, Alter, Drop
  • Profiles View, Create, Alter, Drop

Oracle Session Manager

Provides GUI view Search and Modify access for:

  • Session Detials, Kill Session
  • Session Statistics
  • Session Locks
  • Session Current Statements
  • Session Open Cursors
  • Session Long Operations
  • Session Disconnect
  • Session Trace
  • Session Grouping (By SID, AUDSID, and more)

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
  • Files IO Statistics
  • Objects IO Statistics

Oracle Log Manager

Provides GUI view Search and Modify access for:

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

Oracle SGA Manager

Provides GUI view and Search for:

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

Oracle Server Statistics

Provides GUI view and Search for:

  • Instance Statistics
  • Waits, Latches Details

References

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