• • • • • • • • • • • • • • • • • • • • • • • • • • • DB Tools for Oracle Version 6.1 (free for commercial and personal use) DB Tools for Oracle is an integrated set of 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: 6.1.0.2 Release date: November 20, 2009; Download file size: 17.9 MB DB Tools Components DB Monitor Expert - A 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.

Does anyone know of an open source/free tool for converting pl/sql code to a. Reverse engineer pl/sql to flowchart or any other diagram. Electrical Engineering. Reverse Engineering Tools For Pl Sql Examples. Import Database Schema. Forward and Reverse Engineering Models and Working with.

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. 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. 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. 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.

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. 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. 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. 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. 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. 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. Redline Anime Legendado E.

DB Log Expert also provides unique easy-to-understand graphical views of redo log configuration as well as various statistical and trend graphs. 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. 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. 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. 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. 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. 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. 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. 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.

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. 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.

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. 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. 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! 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.

Technical specifications: Disk space: 42 MB ** Front-end: Windows 2000/XP/2003/2008/Vista/7/8/10 Back-end: Oracle 7.3, Oracle 8/8i, Oracle 9i, Oracle 10g, Oracle 11g, Oracle 12c on any platform Connection via Oracle OCI/SQL*Net or ODBC IMPORTANT: Oracle 32-bit client software must be installed.

Up until a few years ago I used Microsoft Visio to reverse engineer an existing database to a diagram. This feature for a while now, and I'm rather stuck in finding an alternative. Requirements The FAQ for this new SE site instructs me to be precise in the requirements, so I'll give my best. Most of these requirements were in Visio, though not all of them. I guess finding one piece of software that has them all is not feasible, but I'd like to get close.

Important: • SQL Server 2012 databases; • Reverse engineer tables with all columns and Primary/Foreign Key indications; • Reverse engineer foreign keys as connectors between tables; • Manual layouting of boxes and connectors (I want to group stuff visually); • Basic theming: choose background colors for tables; • Able to handle complex models, e.g. 100+ tables; • Able to choose which items to show or not (e.g.

Leave out certain tables, etc); • At least a free trial available; • Exporting to various formats for distributing and printing purposes, most preferred is PDF, PNG would also do I guess; • WYSIWYG; Main bonus points: • Runs on Windows 8 (though I'd install a Linux VM for software fulfilling all important requirements) • Automatic layouting and connector routing to minimize overlap; • Able to do SQL Server 2008 and 2008R2; • Able to reverse engineer views; • Free (or a free version); • Incremental update, e.g. Reverse engineer again and have tables added/removed, etc., whilst keeping theme, existing layout, etc. • Pretty diagrams (modern look and feel, anti-aliasing, choice of fonts, colors, gradients, drop shadows, theming, etc); • Friendly learning curve (I can handle many complex features as long as it's easy to get the basics done quickly); MUST HAVE: • Installer doesn't secretly install toolbars in my browser or change my home page!;-) My Research Of course this question has been asked before, even on sister sites (with some success even though they're off topic there). Here's a few: • (MySQL, 91 upvotes) • (MySQL, 6 upvotes) • (all DBMses, 10 upvotes) And slightly similar, from DBA.SE: • (sql-server, 103 upvotes) Furthermore, Wikipedia has a table comparing several software packages for 'reverse engineering' feature: • Tried These are the things I've tried in passing: • Visio 2003 (this is what I used to use).

Not free, outdated, but otherwise it fit the bill for most points. Not an option anymore though. • Visio 2010 and 2013 (this is what I have currently). Reverse engineering is no longer supported.

I've considered writing a plugin or using VBA to hack things together though. Not sure how tough that would be. It's not free (except I guess that I personally have it already), but fits the bill on a lot of other points. Tried this quite some time ago, from what I remember it had a bit steep learning curve and I wasn't quite able to manually determine final layout. • SSMS diagrams. This works for small cases, but can be cumbersome for larger cases. • Visual Studio 2012 ADO.NET Entity Data Model.

Manual layouting of connectors is limited, theming does not exist at all, it is really meant for a goal other than documentation and it shows (e.g. Default you get 'Navigation Properties', etc), and it doesn't work well for 100+ tables. This may be useful for smaller scenario's but doesn't fit the bill for me.

And I think I may have tried a few suggestions from the SO threads, though I can't really remember specifics. So: what would you recommend? Here's a recommendation I ended up using (after a lot more research and trying many different options): Use plain Visio for this. Explanation of this approach: There is no tool that conveniently satisfies all mentioned requirements, not even one that fulfills the main requirements only. Visual Studio 2012 comes close, but lacks theming support and didn't work very well for a large number of tables. The following process worked for me: • Create a blank Visio Flowchart 1 template.

Choose a design you like. Set the page and print sizes to something you want (I chose landscape A3 format and the 'Linear' theme). • Open a query 2 in SSMS on the side to get the details you'll need later: tables, column names, and IS NULL info.

• Start adding the tables one by one. Choose manually which tables and columns you which to include.

This is an example of what the end result looks like: Or a zoomed out screenshot of the entire model (because it was manual labor I chose to include significantly less than all 100+ tables): The procedure I used to make the 'tables' look as they do: • Headers are bold and a larger font size. • Separators aren't lines but just a series of bold — dashes after eachother. • Four 'sections': TableName, Primary Key, Foreign Keys, plain columns. • Bold for NOT NULL columns. • White for TableName and separators, black for column names.

In addition, I chose for foreign keys to: • Never allow crossing connectors, and instead creating small 'reference' blocks that refer to a table that's somewhere on the other side of the model. • Not include all tables (i.e.

There are more foreign keys than connectors). Hopefully the above will be of use to others too. Requirements from the question: As a bottom line, I do recommend this approach, mainly because you end up with a visually appealing model and a high degree of control. This approach doesn't fit the entire bill though.

Here's how it holds up to the requirements: Data connectivity: • SQL Server 2012 databases • Reverse engineer tables with all columns and Primary/Foreign Key indications • Reverse engineer foreign keys as connectors between tables ± This is all possible but not automated. So 'more or less'. Control and visuals: • Manual layouting, basic theming, able to choose which items to show • Able to handle complex models, e.g. 100+ tables ✓ Yes, this all works very well with plain Visio. Moneys: • At least a free trial available ✓ AFAIK there's a free Office trial available. I haven't looked into this though as I have Visio. Other: • Exporting to various formats • WYSIWYG; ✓ Yes, this is available in Visio.

Bonus Points: It has about half of the bonus points: • runs on Windows 8 • SQL 2008 also supported • pretty • friendly learning curve 1. I've also tried the UML template and shapes but this has. Not recommended! This was my query: SELECT t.name TableName, c.name ColumnName, CASE WHEN c.is_nullable = 1 THEN ' ELSE 'BOLD' END AS IsNotNullable FROM sys.tables AS t JOIN sys.columns AS c ON t.object_id = c.object_id WHERE c.name NOT IN ('Excluded1', 'Excluded2') ORDER BY t.name, CASE WHEN c.name = t.name + 'Id' THEN 0 WHEN c.name LIKE '%Id' THEN 1 ELSE 2 END, c.column_id.

@webworm Yes, my desire for a lot of control and a visually appealing result did drive me to resort to manual labor, I must (somewhat shamefully) admit. The full version (from the thumbnail picture) took me about 3 hours of work, total. Keeping it up to date is about 10 mins per 4-week sprint. Biggest downside is not the labor, but the chance for human error (read: copy/paste mistakes). Until someone comes up with a good alternative (highly welcome!) I'll likely stick with this 'solution'.

– May 22 '14 at 18:11 1. Is a free, open-source database discovery tool that can reverse engineer your existing database. Your list of requirements is fully covered.

Well, it's not free, but it has a free trial. With Lucidchart you run a query that they specify, then import the query results. This creates a collection of tables that you can drop onto a diagram like stencil shapes. Lucidchart draws the connections between the keys of the tables you've chosen.

You can rearrange the tables and connections, remove fields, change colors and fonts, etc. As far as I can tell, you'd save 90% of the time required for hand drawing in newer versions of Visio, and you get most of the flexibility in formatting. And no worries about typos. The downside is that this isn't a live connection to your database, so to refresh you'll need to do some manual work.

You can export to various graphic formats (PNG, PDF, JPG) and to Visio (VDX).