DBAJ is java Gui written in Java. It focus mainly on the Streams
configuration and monitoring but it is only at his early stages.
Streams Features:
- Create tablespace needed by Streams
-
Create Streams administrator and assign all grants it needs
-
Create a capture for a Schema (and all objects needed in this process)
-
Prepare or revoke Schema or individual tables for replication
-
Create an Apply process for a Schema (and all objects needed by this process)
-
Create Schema to Schema propagation process
-
Start /stop capture, apply , propagation and queues
-
Drop capture/apply/propagation/queues
-
Output graphic evolution for capture (granularity from a second to a week)
-
Output graphic evolution for redo logs activity (granularity from a second to a week)
-
Output graphic evolution for apply (granularity from a second to a week)
-
Monitor Apply Errors
- Migrate Streams Queue intra
instances (RAC only)
- Open expection queues to view what rows ended there and the reason
-
Open individual LCR of type ANYDATA and display columns mutations (only in exceptions queues)
-
View and shrink object associated with queues (including lob segments).
-
Alter parameters specific to Streams Capture or Apply
-
Alter parameters required at instance level
-
view/modify supplemental logging at instance level
Others features:
- View redo log
- view archive log and related information
-
view Sessions and their query
- view
explain plan for a given query
- view tablespace info
-
view tables, index, view , sequences, dblinks
Gallery:
Configuration : General panel

Queue tables :

Open exception queues:

Monitoring and an SQL execution tree :
