1 of 30 – Oracle Instance Manager – General
2 of 30 – Oracle Instance Manager – Controlfile
3 of 30 – Oracle Instance Manager – Oracle Parameters
4 of 30 – Oracle Instance Manager – Hidden Parameters
5 of 30 – Oracle Instance Manager – NLS Parameters
6 of 30 – Oracle Instance Manager – Jobs
7 of 30 – Oracle Rollback Manager
8 of 30 – Oracle Security Manager – Tree
9 of 30 – Oracle Security Manager – Users
10 of 30 – Oracle Security Manager – Roles
11 of 30 – Oracle Security Manager – Profiles
12 of 30 – Oracle Session Manager – Sessions
13 of 30 – Oracle Session Manager – Session Stats
14 of 30 – Oracle Session Manager – Locks
15 of 30 – Oracle Session Manager – Long Ops
16 of 30 – Oracle Storage Manager – Tree
17 of 30 – Oracle Storage Manager – Tablespaces
18 of 30 – Oracle Storage Manager – Datafiles
19 of 30 – Oracle Storage Manager – Objects
20 of 30 – Oracle Storage Manager – Fragmentation
21 of 30 – Oracle Storage Manager – File IO Stats
22 of 30 – Oracle Storage Manager – Object IO Stats-
23 of 30 – Oracle Log Manager
-
24 of 30 – Oracle SGA Manager – SQL Area
-
25 of 30 – Oracle SGA Manager – Lib Cache
-
26 of 30 – Oracle SGA Manager – Lib Cache Stats
-
27 of 30 – Oracle SGA Manager – SGA Stats
-
28 of 30 – Oracle Server Statistics – Instance Stats
-
29 of 30 – Oracle Server Statistics – Waits
-
30 of 30 – Oracle Server Statistics – Latches
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