SQLDetective

Software Screenshot:
SQLDetective
Software Details:
Version: 4.3
Upload Date: 4 May 15
Developer: Conquest
Distribution Type: Shareware
Price: 136.00 $
Downloads: 13
Size: 23030 Kb

Rating: nan/5 (Total Votes: 0)

SQLDetective 4 is a powerful and easy-to-use graphical user interface to Oracle databases. It provides an integrated environment for developing database objects, writing and debugging stored programs, executing and testing SQL and PL/SQL commands, as well as searching and modifying data. Visual object editors allow users to quickly create and modify database objects such as: table, view, trigger, index, job, cluster, synonym, operator, etc depending on the features of the Oracle database versions. Syntax highlighting and code folding Code Editors, Code Helper, Code Insight and Integrated Oracle Documentation Browser allow the user to write stored programs in a high quality and error free way. Object Navigator facilitates easy navigation of database structures by displaying database schema objects and their relationships in an intuitive hierarchical interface. SQLDetective 4 is a range of handy utilities to run SQL and PL/SQL statements, write and execute stored programs, debug stored objects step-by-step. SQL Editor executes SQL and PL/SQL statements supporting bind and substitute variables. The Stored Program Editor offers an easy-to-use interface for writing and executing stored programs. The integrated PL/SQL Debugger offers all features that a user could wish for: step over, step into, step out, run until exception, etc. Format and improve the quality of PL/SQL code using the Code Analyzer Kit - a code review and quality control tool for Oracle PL/SQL development. SQLDetective 4 empowers DBAs with the powerful and easy to use administrative and monitoring tools and utilities such as: Database Examiner provides easy access to database information such as: database system; instance options; initialization and NLS parameters; system events and statistics and more; Database Monitor monitors real-time database performance and displays: Logical, Physical and Disk I/O, Event Waits, Host CPU usage, Instance performance time, Sort Ratio, SGA, 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 and Event Waits parameters such as: CPU, Logical I/O, Physical I/O, Parsers, Concurrency, User I/O, System I/O, etc.; Storage Manager manages tablespaces, datafiles, segments and quotes in the database instance; Session Navigator manages sessions and displays information on different sessions.

Requirements:

Oracle client: 32-bit Oracle SQL*Net, Net8, Net9, Net10 or Net11, Instant client Oracle database: Oracle versions 7.3 and higher

Limitations:

30-day trial

Supported Operation Systems

Similar Software

Other Software of Developer Conquest

ClearDB Free
ClearDB Free

4 May 15

ClearSQL
ClearSQL

4 May 15

Comments to SQLDetective

Comments not found
Add Comment
Turn on images!