▶ Upcoming Webinar Aqua Data Studio Enterprise Ultimate Register Now →

Free Trial

Request Demo

Screenshot of Aqua Data Studio version 15.0.0 showing a SQL script editor connected to an Oracle 12c database (ORCL). The editor contains a SQL script to create a table SYS.ACCESS$ with several columns and storage configurations. The left panel displays the database schema, listing tables, columns, constraints, dependencies, and other objects. A right-click context menu is open for the table SYS.ACCESS$, with options for creating, altering, dropping, and editing the table, as well as generating scripts (Script Object to Window As). The interface provides tools for database management and scripting.

Oracle

Aqua Data Studio provides an Oracle client and management tool for the Oracle relational database with administration and development capabilities and a database query tool. Aqua Data Studio provides customers the ability to register, connect, query and analyze relational databases stored in Oracle, including Amazon RDS connections.

Start For Free

Aqua Data Studio for Oracle

The Oracle client visual administration features provide users the ability to browse and modify Oracle database structures, including schema objects and database storage, as well as maintain database security. A query tool integrated in the Oracle client allows you to quickly create, edit and execute Oracle SQL queries and scripts. Aqua Data Studio further provides import and export tools to move data easily both in and from different data formats, as well as in and out of the Oracle database. Integrated within these tools is also the Oracle SQL Debugger.

Oracle Database Toolkit

Visual Analytics

Query & Analysis Tool

Grid and Pivot Charts

Integrated Secure Shell (SSH)

Import & Export Tools

Entity Relationship Modeler

Visual Query Builder

Version Control Clients

Subversion (SVN), Git CVS Perforce

Table Data Editor

Compare Tools

Schema Compare, File Compare

Open API Scription Environment

Aqua Data Studio Oracle Administration Tools Include:

Oracle¹ 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

^ Oracle Database Wikipedia article.
Oracle Corporation Wikipedia article.

Purchasing

Customer

Company

Join our mailing list

Copyright © 2001 – 2026 Aqua Data Studio, Inc. All rights reserved.