| |
| |
| |
| |
| |
| Optional Kits extend the power of SQLDetective to combine building, debugging, administration, allowing
team development support using the integrated version control system to deliver higher quality applications and save valuable time. |
|
| What's new in SQLDetective 4.0? |
| Take a screenshot tour |
| |
|
Release History
|
|
SQLDetective comes with two optional kits and one add-on that extend and customize its functionality on the basis of individual user requirements: |
| |
| |
Developer Kit:
| |
|
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. |
| |
|
PL/SQL Debugger – debugs procedures, functions, packages, object types and triggers, step by step. The feature provides all the facilities required to quickly and accurately debug the program code on a database server. |
| |
|
Data Dependency Analyzer – analyzes and modifies the dependencies between data, based on integrity constraints. It accelerates the localization of the problem of data dependency throughout the process of supporting databases. |
| |
|
Repository and Version Control System – provides instant access to
frequently-used database objects, user-defined Smart Datasets, SQL statements, PL/SQL and JAVA code templates and any other text information. The powerful built-in and third-party version control systems such as Microsoft Visual Source Safe, Merant PVCS and others that support Microsoft SCC API, allow for save and control of object versions. |
| |
|
Oracle E-Business Suite object description – quickly access the OEBS object description in the development environment.
This unique feature is specifically developed for Oracle*E-Business Suite IS implementation and support staff. |
| |
|
|
|
| |
DBA Kit: |
| |
|
|
Session Navigator - manages sessions in the database instance and is used to view a different session's information such as: open cursors, locks, event waits, long operations, transactions, input and output, statistics etc. It provides a wealth of settings and allows the user to kill and disconnect sessions, and to enable and disable SQL tracing for the selected session(s). |
| |
|
Storage Manager - manages tablespaces, datafiles, segments and quotes in the database instance. It provides an easy to use interface to create, modify, change status, coalesce and drop tablespaces; to create and change the status of datafiles; to relocate and move objects; to create, modify and delete quotes; to show different tablespace information such as: used, free and max size; free space; objects etc. |
|
|
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. |
| |
|
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. |
| |
|
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. |
|
| |
|
| |
ClearSQL for SQLDetective: |
| |
| |
|
ClearSQL for SQLDetective is a code review and quality control tool for Oracle PL/SQL development,
built around a code analyzing technology and an advanced code editor. It improves the quality of PL/SQL code while increasing the productivity of the software team; instantly formats the PL/SQL code to a set of code conventions that improve the readability of the software, allowing engineers to understand the new code more quickly and thoroughly; analyses PL/SQL code for its structure and architecture and generates a series of industry standard quality control metrics that identify possible error prone procedures based on complexity, size, modularity and keeps the code reliable, testable and manageable. |
|
| |
|
|
Not using kits yet? Buy now ...
|
