DBHawk Features
|
Browse Tables, Views, Sequences, DB Links, Synonyms, Packages, Package Bodies, Procedures, Functions, Types, Type Bodies, Triggers, Materialized Views, Libraries, Directories. |
|
View Constraints detail information. Add new Primary Key, Foreign Key, Unique Key and Check Key constraints. Enable/Disable, Drop Constraints. |
|
View index detail information. View index statistics. Add new index. Drop index. |
|
View Object privileges. Assign/remove privileges. |
|
Browse table/view data with filter. Insert/Delete/Update row. |
|
View, Create, Modify, Compile, Drop triggers, functions, procedures, packages and types. View dependencies and error details of stored programs. |
|
Create new Table, View, Synonym, DB Link, Materialized View, Tablespace, Datafile, Rollback
Segment, User, Role, Redo Log . |
|
Find columns. Find text in a stored programs |
|
Analyze Tables, Indexes Enable/Disable constraints, Triggers View, Compile all invalid objects View detailed information about current(logged-in) user. |
|
Generate ddl for all objects for a particular schema. |
|
Browse users, roles, profiles. Alter users and roles. |
|
Browse Control files, Datafiles, Rollback Segments, Redo Logs, Archived Logs. Alter Datafiles, Rollback Segments, Redo Logs. View Tablespaces and Datafiles detail graph. |
|
Manage database Jobs. |
|
Monitor SGA, Session, Locks, Blocking Locks, Open Cursors, Processes, Top SQL, Long Operations Transactions/Rbs, Session Wait. |
|
Advanced session manager with auto refresh and filter option. Kill, Trace session. View Session detail, session IO, Session Wait, Session Current SQL, Statistics, Open cursors, Locks and Objects in use. |
|
View/Modify Database Parameters. |
|
Execute SQL, Save SQL, Open SQL script. Export query result into .HTML, .CSV or .PDF format. |