SQLDetective – Highlights
SQLDetective comprises 50 modules and 31 database object wizards supporting in total
59 object types – up to Oracle 12c. It’s a state-of-the-art development solution accelerating
the development, the maintenance, and the administration of Oracle Databases.
SQLDetective administers and monitors sessions, tablespaces, data files, rollback segments, users & roles, and access grants for objects using Storage Manager, Session Navigator, Database Monitor, Top Session Locator and Database Examiner.
Administer Your Database Efficiently
SQLDetective administers and monitors sessions, tablespaces, data files, rollback segments, users & roles, and access grants for objects using Storage Manager, Session Navigator, Database Monitor, Tablespace Wizard, Top Session Locator, Database Examiner and Oracle RAC.
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, 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, 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. The application also provides the ability to work with Oracle Real Application Clusters (RAC) databases
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
TABLESPACE WIZARD a powerful Oracle database version-dependent graphical interface that offers easy-to-use controls for viewing, creating and modifying tablespaces
Oracle RAC – support for managing Oracle Real Application Clusters (RAC) databases. This feature is available in the following modules: Object Navigator, Session Navigator, Database Examiner, Database Monitor, Top Session Locator