Compare Databases & Schemas & Objects compares and displays the differences graphically and generates a synchronization script for: two different databases; one or more schemas in the same or different databases; or one or more objects in the same or different databases with the definition of schema and non-schema types and name filters. Compare Databases compares a Source session with a Target session comparing schema and non-schema objects such as: tables, views, stored objects, triggers, indexes, clusters, roles, users, profiles, directories, tablespaces, rollback segments, resource plans and others. Compare Schemas compares schema objects such as: tables, views, stored objects, triggers, indexes, clusters, etc. in one or more schemas at the same time. Compare Objects compares one or more selected objects. The comparison occurs in the background, without blocking the application, and writes detailed log entries during execution. Set of options, for example, Include Script Comment, Include Object Owner, Include PROMPT and SPOOL allow the configuration of the synchronization script based on user requests. All user-defined customizations and settings can be saved to a settings file and loaded next session. The comparison result is displayed in a Result Tree indicating the comparison status for each object. Clicking on an object in the Result Tree displays detailed information such as: DDL Differences between objects, Migration SQL, and full Synchronization Script. Copy the synchronization script to the SQL Editor and run it on the Target Session to synchronize the compared databases, schemas or objects.

Database Monitor monitors real-time database performance and displays information such as: Logical, Physical and Disk I/O, Event Waits, Host CPU usage, Instance performance time, Sort Ratio, SGA, Java and Shared Pool, Hit Rates, Recursive Calls, and many others in charts grouped by categories. The tool supports multi-window and multi-session processing and allows easy monitoring of different oracle sessions at the same time. Easy navigation through the chart categories and properties is available by using the multi-level Page Navigator that is divided from the main monitoring pane by the advanced vertical splitter. The Overview page contains the most important charts from different categories. The list of its charts can be easily changed by using the popup menu and re-ordered using drag&drop. By default, all data collected from the charts is saved to the history file, in the background, to play it back later in the History page for a selected period of time . The chart alarms control the critical minimum and maximum values of the monitoring parameters and notify the user in a variety of ways such as: alert message box, beep and email. Clicking on the chart displays the detailed tool-tip about the data point. Customize the look and feel and the Record History property of any chart via the popup menu or the Page Navigator. Double click on the chart to maximize it and use the Full-screen mode for closer monitoring. Period of data collection, chart timeframe, scrollbar synchronization, chart grid, the history file size as well as the position of the legend can be customized on the toolbar and in Preferences.

Top Session Locator locates the most resource consuming sessions in the database using different activity parameters such as: CPU, Logical I/O, Physical I/O, Parsers, etc.; and Event Waits parameters such as: Concurrency, User I/O, System I/O, etc. The tool supports multi-window and multi-session processing and allows easy control of resource consumption in different oracle sessions at the same time. Easy navigation through the activity and event wait parameters is available by using the multi-level Page Navigator that is divided from the session list by the advanced vertical splitter. The sessions displayed in the data-grid are sorted by Delta and Cumulative calculated values, so the most resource consuming sessions are displayed at the top of the grid. Sessions using more than <N>% of total value, 20% by default, are highlighted in the data-grid with a different colour that can be customized in Preferences. Use the predefined and user-defined filters to filter the list of displayed sessions. Advanced Dataset Manager customizes visibility and position of data-grid columns. All user-defined customizations can be saved to a settings file and can be loaded automatically on the next open. Top <N> Sessions, Modules and Users are displayed in pie charts on the Charts tab. Clicking on a segment of the chart locates the session in the data-grid. Displayed information can be refreshed automatically in every defined period or can be refreshed manually.

Database Examiner provides easy access to database information such as: database system; instance options; initialization and NLS parameters; system events and statistics; SGA memory allocation; list of sessions; tablespaces, datafiles, rollback segments, users, profiles, roles, contexts, directories, database and schema triggers; and resource limits. The tool supports multi-session processing and allows quick switching between different oracle sessions. Easy navigation through the database properties is available by using the multi-level Page Navigator that is divided from the information pane by the advanced vertical splitter. Instance options, initialization and NLS parameters, Resource Limits, System events and statistics and the list of users, profiles, roles, contexts, etc. are displayed in powerful data-grids that allow sorting (local, server), filtering, exporting to different formats, and customizing column width, position and visibility. These powerful data grids are provided by the advanced Dataset Manager. The advanced Dataset Manager is divided from Information pane by the vertical splitter. Displayed information can be refreshed automatically in every defined period or can be refreshed manually.