|
|
SQLDetective 4.0.1 introduces 5 new tools, 5 significant enhancements and numerous performance and usability improvements. |
|
New tools and utilities:
- Database Monitor - monitors real-time database performance and displays information in charts grouped by categories; saves gathered information in the background and plays it back for a selected period; and defines alerts and notifies the user in a variety of ways.
- 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.
- Top Session Locator – locates the most resource consuming sessions in the database using different activity parameters: CPU, Logical I/O, Physical I/O, Parsers, etc.; and Event Waits parameters: Concurrency, User I/O, System I/O, etc.
- Compare Databases & Schemas & Objects – compares, displays the differences 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 object filters.
- TKPROF Shell – a utility that greatly simplifies the usage of the Oracle command line utility TKPROF by providing the user with a graphical interface to all of its parameters and options from within the application.
Other significant enhancements and improvements:
- Code Folding - selectively collapses (hides) and expands (shows) sections of SQL and Pl/SQL code to make it easier to navigate and read. It helps manage large regions of potentially complicated code within one editor, while viewing only the desired subsections of code during a particular editing session.
- Schema Compiler - added ability to auto refresh within a certain time period; recompile invalid objects; and send an email alert if invalid objects exist after auto-recompilation.
- SQL Editor - displays editor pages as tabs; renames tabs and synchronizes editor and data output tab navigation; and provides a new user interface for Editor Page List.
- Connection Window - remembers the selected Oracle Home and Auto Login settings for a History Connection item.
- Object Navigator – improved ContentSelector: Objects, Columns, Data, DDL dataset performance; automatically refreshes object information in ObjectSelector (Object Navigator Tree) when an object is changed in Object Wizard.
|