dbXpert for Oracle

dbXpert for Oracle is an easy to use database development and administration tool for Oracle database. It helps developers and DBAs get the job done quickly and efficiently. dbXpert for Oracle provides an integrated environment to speed PL/SQL development and testing. It also provides an easy way to access the database objects. With the help of dbXpert's intuitive graphical user interface, developers can focus on coding quality application programs while DBA can be more interactive and productive when troubleshooting and administrating the Oracle database.


Multi-Tabbed SQL Editor

SQL Editor enables users to quickly test queries, view and edit data, and process SQL DML/DDL commands. It replaces the traditional command line query and script execution facility with a graphical user interface.

Multi-View Object Browser

With dbXpert's Objects Browser allows you to quickly view ad manage the data dictionary thought a simple multi-tabbed navigation list. Once you click on an individual objects, dbXpert will display its associated details that eliminates the tedious drill down of data dictionary views. With the Object browser, you can recompile objects, view object dependencies, create objects, drop objects, view the DDL source code of the objects etc. (more ...)

Intelligent Data Browser

The Intelligent Data Browser allows you to easily access your data in the database. You can easily retrieve data, filtering data or editing data with a fancy user interface.

The Query builder provides you the fastest way to build a complex query which involves multiple tables by "drag and drop", to add filtering conditions by clicking the value in the result panel. The query can be saved and you can quickly access the frequently used query using the Recent Queries menu.

The popup menu in the resultset allows user to quickly perform record filtering. It's content sensitive menu displays filtering critera based on the content of the selected cell.

Multi-Tabbed Procedure Builder

With its Syntax Highlighting, pop-up code selectors, error message window, object navigation tree, you can edit and compile your stored procedures, functions, packages in a powerful multi-tabbed window. It saves your valuable time and improves the overall quality of applications. (more ...)

PL/SQL Debugger

The dbXpert PL/SQL debugger offers all features of debugging functions that allow developers to easily debug the PL/SQL program units. With the PL/SQL debugger, you can Step In, Step Over, Step Out, Run To Cursor, Set Breakpoints, View Variables, View Call Stack, and so on.

Debugging is no longer a difficult task, developer can concentrate on the application logic rather then adding code to print out the content of the variables

dbImport - Import Records from other data sources

dbImport allows developer or dba to import data from any ODBC data source into an Oracle table such as CSV, EXCEL, MS Access, SQL Server, DB2, Oracle, etc. You can do data import quickly using the following steps:

Step 1: Select ODBC data source, and source table
Step 2: Select target table
Step 3: Specify columns mapping
Step 4: Specify import options

Instance Performance

dbXpert for Oracle - Instance Performance provides generalized key performance indicators (KPI) for the instance to which you are connected. It provides a look at database resources, instance service time, recent activities, top session, session history, top sql and instance throughput.

Database administrators can easily monitor the health of various components in the monitoring instance. Application developers can also make use of this tool to diagnose and correct Application performance problem.

Session Browser

DBA and Applicaiton Developer can use the Session Window to view the current activities of each user in the database. They can check the resource usage of individual user, statistics information, objects that being locked and even the current running SQL of each individual session.

Built-In HTML Reports

To run reports against your application data or against the Oracle dictionary, you can use dbXpert's built-in Report functions. There are more than 40 standard reports such as user security reports, database summary reports, application performance reports or even database maintenance reports. These reports can be saved in a report file as HTML format, preview, print or publish to your web server for information sharing.

DBA Tools

dbXpert includes several tools to make everyday administration and development easier. You can recompile invalid objects, create database objects, drop database objects, export records of tables or view, monitor session activities, manage users, manage storage and so on.

TOP SQL Window
The TOP SQL Window allows DBA to identify the problematic SQL Statements in the database. The problematic SQL running in you database may impact the performance of your system and slow down end user's response time. The problematic SQL can be sorted by number of executions, number of buffer gets (CPU contention), number of disk reads (I/O contention) etc. It also shows the summary of performance statistics of each individual SQL statement. DBA can also view the execution plan of the SQL statement and the performance statistics of the objects that being accessed by the SQL statement.


Manage User Window
With the Manage User Window, DBA can create, edit, delete, disable or enable any user account in the database. DBA can use this tool to assign roles, system privileges, object privileges, and tablespace quota to user.

Manage User

Manage Storage Window
DBA can use the Manage Storage Window to create, delete or edit the storage objects in the database such as Tablespaces, Datafiles, Redo Logs, Rollback Segments, Archive Logs etc. The Manage Storage Window also shows the storage summary of each type of storage objects such as the size of tablespaces, remaining size of tabelspaces, sizeof datafiles, and status of these objects.

Manage Storage

Object Search Window
DBA or Applicaiton Developer can use the Object Seach Window to search any object in the database such as Indexes, Tables, Synonyms, Types, Views, PL/SQL programs etc. The search result is shown in an Object Tree and may be grouped by either Object Type or User Name. Therefore, user can easily identifiy the specific target. User can search any specific object by its object name. The advanced options allow user to search by: 1. Table, Index, Constraint, View or Cluster Columns 2. Source code of the programs

Object Search

Record Search Window
When developer needs to understand the table relationships in an applicaiton with no assistance of any written document, Record Search can help to show all objects that contain one particular data value by searching the entire database. The search result shows how many records in the tables containing the value that been searched, it also highlights the columns that contain the target value.

Record Search

Intelligent Color Theme

dbXpert comes with pre-configured color themes. It allows user to set different color themes based on the connection alias and login user name. It's very useful for DBA and developer when they need to work on multiple environments.

Intelligent Color Theme


Easy Installation

Neither database object installation, nor any middle-ware required, only SQL*Net is required to pre-installed. The installation can be completed within 30 seconds, by just simple clicks.

Multi-Threaded Environment

You can run multiple windows concurrently. The IDE will not "hang" even if you make any error or your session is being locked.

System Requirements

Client for dbXpert: Oracle database Server