Oracle SQL Client Tools
DBHawk is a web-based Oracle SQL client and database management software
It allows Oracle SQL developers, DBAs and SQL BI Users to manage, develop Oracle databases through a web browser. Users do not required to install any Oracle client on their machine. Using DBHawk development managers can give quick access to their developers and business users without relying on DBAs. Also Managers can audit users SQL activities. DBHawk gives total power to product managers with quick and easy access to Oracle databases.
Oracle SQL developers can use visual SQL query builder to drag and drop database tables, build SQL queries, build oracle database ad hoc reports, parameterized reports, online data dashboards, schedule reports-all with point and click simplicity and database security. SQL users can build D3 based charts. It’s a better alternative for Oracle Application Express (APEX) users. Like APEX, it does not require you to build a PL SQL based solution.
Online Oracle Data Browser
DBHawk supports full online Oracle database browsing capabilities. Users can view database table data, filter data, count total number of rows in a table.
Oracle Data Editor
DBHawk online data editor allows to create, insert, update, and delete data. Users can also update clob, blob data.
Oracle Export/Import Data
DBHawk online export data feature allows to export table data into csv, html, insert and pdf formats.
Users can also import csv data directly to the tables. DBHawk parse input csv data columns and display column mappings between table columns and uploaded CSV file data columns. After successful import, users can save import as a job and schedule it to run at regular interval.
Online Oracle Column Manager
Using DBHawk, users can view oracle table column details, alter table columns, and add new columns.
Oracle Index Client Tool
Table indexes provides efficient table data search. Using DBHawk, users can view index details including index uniqueness, index type, index columns, index tablespace name, index statistics. Users can also add new with a new index screen and preview SQL prior to creating an index. Users can drop index.
Users can add Non-unique, Unique and Bitmap indexes using DBHawk index creator.
Web-Based Oracle Constraints Manager
Constraints are the rules enforced on data columns on table. Using DBHawk, users can view table constraints details. It displays Constraint name, Type, Constraint status, Constraint columns. By clicking on the constraint name, users can view constraint detailed information such as Last changed, Delete rule, reference owner, reference table, reference columns. User can also add new Primary Key, Foreign key, Unique key and Check constraints for the table. Users can enable/disable constraints, drop constraint with a simple click.
Oracle Database Trigger Manager
Oracle triggers are stored procedures that are implicitly executed when an INSERT, UPDATE, or DELETE statement is issued against the database table. Using DBHawk trigger manager, users can view existing table trigger details, View trigger object dependencies, Enable/Disable trigger, drop a trigger. Users can also add new BEFORE or AFTER events triggers for INSERT, UPDATE and DELETE statements.
Oracle Object Grants Manager
With granted privilege, user can execute a particular SQL statement with another user’s object. DBHawk provides intuitive Object grants manager. Using DBHawk grant manager for the object, users can select various privileges such as SELECT, INSERT, UPDATE, REFERENCE etc and assign those privileges to other users. DBHawk display current Object’s granted privileges and allow user to revoke those privileges with a simple click.
Online dependencies & referential viewer
DBHawk displays table references details. Using referential screen, users can find out parent and child tables. DBHawk object dependencies display dependency between objects. Users can quickly figure out dependent objects and depends on objects.
Oracle Table DDL Generator
DBHawk display table DDL with a simple click. DBHawk runs DBMS_METADATA.GET_DDL(‘TABLE’,’
‘) to get table DDL.
Oracle Web-based View Manager
Using DBHawk, users can create new Oracle view, rename a view, drop a view, count total rows in a view, modify view, filter view data, view column details.
Oracle Sequence Manager
The sequence generator generates sequential numbers, which can help to generate unique primary keys. DBHawk Sequence Manager display all sequence details. Users can Drop sequence, create a new sequence, assign grants, view dependent object details and get ddl for the sequence.
Web-based Oracle Database Link Manager
A database link is a connection between two physical database servers that allows a client to access them as one logical database. DBHawk provides DBLinks management. Users can view DB Link details, test database link, create new database link, drop a link, generate SQL for the existing database link
Oracle Synonym Manager Online
An Oracle synonym is a pointer to a database object. Synonyms provide data and location independence. With DBHawk, users can manage synonyms. Users can view synonym details, reference object and object type details, view data for table or view synonyms, view SQL details and create new synonyms.
Oracle Stored Program Manager
Using DBHawk, users can manage database functions, procedures, triggers, packages, package body, types, type body. User can add new stored programs, modify existing Oracle stored programs.
Oracle Materialized View Manager
Oracle materialized view is a snapshot of data at single point in time. DBHawk displays materialized view details including SQL query, last refresh time, last refresh type, refresh method, refresh mode etc. Users can browse materialized view data, columns. It also allows to create new materialized view, get DDL.
Oracle Database Objects Creator
DBHawk makes Oracle database object creation very easy for developers. With DBHawk intuitive UI, Oracle developers can create various database objects such as Database tables, Views, Synonyms, DB Links, Functions, Procedure, Package, Types, Triggers, Sequence and Materialized View.
Analyzing Oracle Tables, and Indexes with DBHawk
Current statistics for tables and indexes are stored the data dictionary. These statistics can be used by the optimizer to choose the most efficient execution plan for SQL statements accessing analyzed objects. DBHawk provides Analyze table and index utility. It uses DBMS_STATS package and generate statement to analyze database tables and index.
Oracle Tablespace Manager
Oracle tablespaces are the logical database structures that hold data for an Oracle Database. DBHawk provides Oracle Tablespace monitoring and management. DBA can monitor tablespace usage with graph which shows free and used space. It displays Tablespace status, Content type, Size, Used size, Percent used size and maximum size. DBAs can view and alter tablespace. It shows tablespace detailed information such as datafiles, Object names, Blocks, Object size and maximum extent size. Using DBHawk, admin can add new data file to the tablespace, increase existing size.
Oracle Datafile Manager
Each tablespace has data files where the data is stored. DBHawk provides Data files monitoring and management. DBA can monitor Data file usage with graph which shows free and used space. It displays Data file location, Auto extensible information, Size, Used size, Percent used size and maximum size. DBAs can view and alter Data files. Using DBHawk, admin can add new data files or alter existing data file.
Oracle Session Manager and Database Monitoring Tool
DBHawk provides advanced Oracle session management. DBHawk provides session details with feature to kill database session, start and stop trace. Session detail includes IO details, Wait, session statistics, current session SQL, session database locks, objects in use for the session. DBAs can automatically refresh session data at regular interval. Also, DBAs can filter session data to view only active session, background sessions etc.
Web-based UI makes Oracle session management very easy and productive for Oracle DBAs to troubleshoot session related issues.
DBHawk also provides Blocking Locks, SGA, Top SQL, Session Wait, Processes, Long Operations, Database Locks, Database Parameters, Active Oracle Jobs, Running Oracle Jobs and V$Views monitoring.
Oracle User Manager Client
DBHawk provides Oracle database user management. With DBHawk user manager, DBAs can view database user details, view status, Lock/Unlock user, view default tablespace details, view profile and creation and expiration dates. DBHawk provides create new user, alter user. Also, DBHawk provides clone user feature, which makes creating similar user creation very easy.
DBHawk also provides database roles and profile management.
Oracle Database Utility Web Client
DBHawk provides various database utilities to help developers complete various tasks. DBHawk provides Enable triggers, Disable Triggers, Enable constraints, Disable Constraints, Run large database scripts utilities.
Oracle SQL Report Builder
DBHawk provides ad-hoc SQL report building capabilities. User can create PDF, Excel, CSV reports.
Oracle SQL Job Scheduler
DBHawk provides SQL Job Scheduling feature. Using DBHawk Job Scheduler, users can schedule reports to receive results by email or save on the disk
Oracle Database Query Tool
DBHawk provides advanced database query tool for Oracle.
Oracle Schema Compare Tool
DBHawk provides advanced database schema compare tool. It displays schema changes side by side. Users can select various database objects such as Tables, Views, Users etc to compare schema objects with another schema objects. It is helpful for schema comparison between dev, test and production environments
Oracle Charts and Dashboards
Using DBHawk, users can create various charts, create dashboards and share created charts/dashboards with other users.