DB Tools for Oracle Version 6.1

DB Tools for Oracle is an integrated set of "must have" tools for monitoring, tuning, diagnosing, coding, reverse-engineering, creating, editing, debugging, and reporting for Oracle databases. It helps Oracle DBAs to maximize the availability, performance and security of their databases. It helps Oracle developers to fine-tune their applications both in development and production phases.

Last version:       Try it free  Download trial version
Release date: November 20, 2009; Download file size: 17.9 MB

DB Tools schreen shot

DB Tools for Oracle 6.1 contains the following components:

DB Tools Components
icon DB Monitor Expert - this is the most comprehensive solution for graphical Oracle database monitoring and diagnostic. It helps Oracle DBAs and developers effectively monitor, diagnose, and plan within the Oracle database environment making total database administration and development easier. DB Monitor Expert all the tools required for powerful performance diagnostics and troubleshooting as well as it includes tons of other tools needed in everyday database administration and development, including numerous Database and SQL navigators, Top Sessions, SQL Editors, PL/SQL Debugger, SQL reverse-engineering and much more...
icon DB Difference Expert - this tool allows DBAs to compare, synchronize, and archive all possible Oracle database objects and parameters including various schema objects and entire schemas, user information, security attributes, database configuration and more... DB Difference Expert can create historical "point-in-time" object, schema or database snapshots; anticipate schema change impact and dependencies. No DBA should propagate and analyze database changes across the Enterprise without DB Difference Expert.
icon DB Tuning Expert - this tool is a great aid for those who are responsible for the operation, maintenance, and performance of an Oracle Server. If you are one of them then DB Tuning Expert can help you identify quickly many database performance problems. With a few mouse clicks can run robust database performance and organization diagnostic tests and get a comprehensive report on the existing performance problems along with the expert recommendations for solving all found problems and avoiding them in the future. DB Tuning Expert can analyze databases in the following areas: It is a "must have" for every Oracle DBA and consultant.
icon DB Index Expert - the only tool that provides advanced analysis for Oracle database indexes. DB Index Expert is a must-have tool for every Oracle DBA and developer. It can generate and analyze tons of index and table statistics, highlight problematic areas and automatically provide tuning recommendations for both existing and missing database indexes.
icon DB Space Expert - this tool can be used to reorganize, optimize, partition and consolidate objects within Oracle databases while the database applications remain up and running and fully available to users. DB Space Expert can be used to quickly identify objects that would benefit most from space reorganization and then reorganize them either in a real-time or schedule reorganization jobs for those objects or even entire tablespaces. By optimizing object storages, defragging tablespaces and files, and reclaiming wasted disk space, DB Space Expert reduces the need for additional storage requirements and helps to avoid expensive storage upgrades.
icon DB Consumer Expert - this is a one-stop solution for managing Oracle database users, database resource quotas and resource usage and priority plans. Database resources such as CPU time, space, memory and so on can be managed and distributed differently to different users and user groups as well as they can be adjusted differently during different resource demand periods. In addition, it provides a large set of analytical reports for exploring database usage patterns and trends by users and applications. Using these reports you can easily pinpoint who is consuming most of your database resources and which applications are used. You can then use the available DB Consumer Expert's resource management functions to adjust database resource quotas and priories thus ensuring that most critical business applications get what they need while other applications continue to operate with acceptable response time levels.
icon DB Security Expert - this tool brings new dimensions into Oracle security management, transforming myriads of multi-level security settings and assignments to an easy-to-understand effective security reports. It also provides all the other tools needed to manage database users, roles, groups, profiles, and permissions. Using this tool, you can: analyze effective access rights for any given user, table or an entire schema; find out how users gained rights to a particular database table or objects within a particular database schema, whether they can access them directly or indirectly via assigned roles, group membership, even via database views; analyze effective access rights granted to the PUBLIC role; analyze who has access rights to standard database procedures that can be used for accessing Operation System files outside of the database.
icon DB Copy Expert - this is a must-have tool for every DBA and developer who works with multiple Oracle databases. DB Copy Expert can be used to copy schema objects and entire schemas between databases; copy tables with and without data; copy data samples - best for copying samples of production data to development or QA environment. copy entire schemas between databases. DB Copy Expert intelligently resolves schema object dependencies and referential constrains and ensures that schema objects are copied in the proper order. It can be also used to copy objects between different database versions. Copied objects are automatically downgraded or upgraded depending on the version of the target database.  Best of all DB Copy Expert features intuitive graphical interface allowing to copy objects between databases using convenient drag-and-drop methods that make copying schema objects and data between databases as simple as copying files between folders using Windows Explorer.
icon Performance Library - "open source" collection of 50+ prebuilt customizable performance monitors, graphs, and reports. You can easily add your own monitors, graphs, and reports that match you unique requirements.
icon DB Log Expert - this tool can help DBAs and developers in monitoring existing databases and balancing database loads. In addition, it provides graphical views of the current redo-log configuration, including statuses and usage information for all redo-log members and redo-log files. It also provides full graphical Oracle redo log monitoring and historical database change tracking. DB Log Expert also provides unique easy-to-understand graphical views of redo log configuration as well as various statistical and trend graphs.
icon DB Benchmark Expert - this handy tool enables you to setup a benchmark test that you can use to measure performance of your database doing on-line transaction processing work. This database benchmark test simulates a real workload by allowing you to establish large number of concurrent connections performing user-defined transactions simultaneously. This way you can simulate real database users running various database transactions at a high rate performance. The benchmark rules do not necessary reflect your database real-world operations, however the benchmark takes into account real transactions made by other users while the test is being performed. DB Benchmark Expert provides you with an option to customize transaction involved in the test. Even if you use default settings, you can still use benchmark results for the performance bottlenecks analysis and other feature-performance considerations..
icon DB Audit Expert - this is an advanced multi-functional database auditing tool. DB Audit Expert supports both system/user activity auditing using Oracle native auditing features and also trigger-based data change auditing. DB Audit Expert automatically generates table triggers and mirror tables for full data change auditing... It makes database auditing really simple and fun.
icon DB Patch Expert - this utility provides graphical interface to the SoftTree Patch Monitoring and Management service, helping you to find and manage database patches and upgrades for your database systems; prioritize, schedule, and track patch deployment. It can automatically notify you when new patches and upgrades are released for your systems, providing direct download links; aggregated patch summary information, including prerequisites and dependencies.
icon DB Trends Expert - this sophisticated package is used for automated database trend collection and analysis. Data captured by DB Trends can be used for proactive database monitoring and capacity planning. DB Trends is tightly integrated with DB Monitor Expert and DB Tuning Expert. Other components like DB Space Expert also use the collected data for predicting various database problems before they occur.
icon DB Alert Expert - this utility serves as a database-to-email bridge that enables sending email and network messages directly from your Oracle database. It also comes with several pre-configured packages for monitoring tablespace related problems; monitoring error messages recorded in Oracle alert files; monitoring database processing errors on the global and user levels. DB Alert automatically logs all messages passed from your databases and sends email or network alerts to the supporting personnel. It can also serve as a valuable troubleshooting tool for developing, setting up and testing new applications, which is especially helpful in developing and testing back-end applications, that have no user interface.
icon DB Zip/Unzip Expert - this utility provides a quick and easy way to migrate and backup data in your Oracle databases, archive historical data snapshots and create samples of production data for QA and development environments. Using DB Zip/Unzip Expert, you will be able to copy, migrate, and backup tables, schemas or even entire Oracle databases with just a few mouse clicks. DB Zip/Unzip can also backup and copy data samples making it very easy to recreate sample versions of production tables and data in QA and development environments.
icon Java Editor - this is a multi-functional multi-document Java development environment with a built-in file explorer. You can use this tool to edit regular Java and JSP files and also to install Java classes in Oracle databases supporting Java objects such as Oracle 8i and later. The editor features Java syntax highlighting and numerous productivity enhancements. It also provides integrated interface for Java class compilation and direct loading of compiled classes and resources into Oracle databases.
icon SQL Editor and Debugger - this powerful SQL Editor allows editing files virtually of any size. The editor features SQL and PL/SQL syntax highlighting, advanced SQL and PL/SQL Intellisense, database object reverse-engineering including tables, views, procedures, functions, packages, types and triggers, and many other object types. It also comes with graphical PL/SQL Debugger, graphical Explain Plan with automatic Oracle hints generation and comparison, data export/import features, code assistants, file and code comparison tools, and much more...
icon SQL Profiler - DB Tools PL/SQL Profiler provides graphical interface to the Oracle's Probe Profiler API, which is available in Oracle8i and later. PL/SQL Profiler provides a way to profile existing PL/SQL applications and to identify performance bottlenecks. You can use the collected profiler (performance) data for performance improvement or for determining code coverage for PL/SQL applications. Application developers can use code coverage data to focus their incremental testing efforts. SQL Profiler supports profiling projects that enable comparison and analysis of different code versions and execution scenarios.
icon DB Job Expert - supports all tools you need to schedule, monitor, run and troubleshot your database side jobs. It contains graphical explorer-style job navigation and scheduling console, server side Job Monitor and Profiler package, and a number of reports for job forecasting, analysis, load balancing, and troubleshooting.
icon DB Application Expert - this revolutionary tool can be used to monitor databases from the application point of view. It allows finding all applications that ever access the database, client-side processes and users running these applications, locks created by applications and their impact on other processes, objects accessible by these applications as well as SQL code generated and executed by them. DB Application Expert consists of graphical explorer-style Application Monitor console, server side Application Monitor and Profiler package, and a number of comprehensive reports for application analysis, monitoring, load balancing, and troubleshooting.
icon File Loader - this graphical tool allows fast loading of Excel, text tab-separated and comma-separated files into existing and new database tables. Simple yet very easy. While DB Tools SQL Editor's file import facilities can be used to import file data into existing tables only the File Loader utility supports both - loading files into new and existing tables. New tables can be created dynamically during file load process based on the analisys of the file data and user input.
icon LOB Viewer and Loader - this tool can be used for browsing and viewing various documents saved in database LOB (Large Object) columns as well as for loading new documents into the database. LOB Viewer is especially helpful to database developers because it enables them to view data stored in LOB columns that cannot be done using regular database development tools such as SQL*Plus and most other. With LOB Viewer and Loader you can now view, delete, update and insert almost any document or file directly without launching the document's native application originally used to save the data in the database LOB!
icon Test Data Generator - this is a perfect tool for creating large volumes of meaningful data for performance testing, quality assurance testing, usability analysis, and many other purposes. Test Data Generator is able to automatically detect primary and foreign keys and without user intervention generate test data that match all referential integrity constraints rules. It can generate test data for all standard Oracle data types. You can customize the default data generation rules on per-table-column basis to fit your specific business requirements. Test Data Generator comes with a large set of pre-built data libraries of the most commonly used data values including meaningful addresses, names, phone numbers, company names, industries, financial terms, healthcare data, drugs, auto-parts and more. It also gives you the flexibility to create and modify your own data libraries, create custom data generation rules, and specify existing database tables with real business information as "lookup" data values for the newly generated data.

  Try it free 

Download trial version Just click on the download link and fill out the brief one-time registration form. Download full-featured trial version (15.4 Mbytes) now.


Related Products:

SQL Assistant SoftTree SQL Assistant for Oracle, SQL Server, MySQL, DB2, Sybase ASE and MS Access
DB Audit DB Audit for Oracle, SQL Server, MySQL, Sybase ASE, ASA, and DB2
DB Mail DB Mail for Oracle, SQL Server, Sybase ASE, ASA, and DB2

DB Tools Reviews

Read what db-review.com has said about DB Tools "The [DB Tools] package allows performing anything that is necessary for both a database administrator and developers, exceeding the abilities of Oracle Enterprise Manager." For complete review click here.

  Pricing and Upgrade Options

  Support Forum  - DB Tools on-line technical support forum. Browse or search to find answers for your questions and join the discussion!

Other Information

Technical specifications:
   Disk space: 42 MB **
    Front-end: Windows 2000/XP/2003/2008/Vista/7
    Back-end: Oracle 7.3, Oracle 8/8i, Oracle 9i, Oracle 10g, Oracle 11g on any platform
    Connection via Oracle OCI/SQL*Net or Net8/Net9 or ODBC

** Full installation takes less than 1 minute (no server side changes required, server side objects are optional).