Топ-100
 
CerebroSQL

Key features

  • Free for any use

  • Oracle Database Monitoring

  • Viewing information about tablespaces and managing their parameters

  • Setting up and managing rollback segments

  • Management of sessions of databases Oracle , PostgreSQL

  • Definition  SQL  operators making the maximum contribution to the load on the database

  • Performance monitoring and analysis of wait events

  • Control of operating parameters and current load of an unlimited number of databases [ Existence ]

  • Monitoring of work (with preservation of history) DBMS Oracle Standart edition

  • Managing database parameters (with the ability to log the operation of changing the parameter value)

  • View DB syslog (Alert.log)

  • Managing and configuring database logs ( REDO )

  • Formation and viewing of AWR reports

  • Moving database objects from one tablespace to another

  • Statistics management (databases, tables, indexes)

  • Index management

  • Compiling invalid database objects

  • View and Analyze Query Execution Plans

  • Quick access to servers using  Putty

  • Structured storage of documents, instructions, scripts

  • Server Card | Databases

  • SQL query editor (multisession, with support for working with different DBMS at the same time)

    • Common functionality for all databases

      • Uniform syntax for all bases

      • Hint support - a mechanism for generating reports

      • Transferring data between different databases through a procedure  openlist

      • Query aliases - assigning an alias to a query, for its subsequent execution by name

    • Oracle DBMS (Oracle: 8.0.3 and older)

      • Viewing Query Plans

      • Executing large scripts from a file on disk

      • Viewing, creating and managing objects in the database (tables, views, procedures, ...)

      • Viewing and managing sessions in the database

      • Viewing the TOP of queries in the database

      • Viewing system information (information about table spaces, REDO logs, ASM disk groups, users, profiles, roles, tasks in the database, links between databases)

      • Analysis of the quality of queries and generation of proposals for their optimization (DBMS_SQLTUNE)

    • PostgreSQL DBMS (7.4 and older)

    • SQLite databases (3.0 and older)

      • Repair of damaged databases.

      • Executing large scripts from a file on disk

      • Viewing query execution plans

      • Database management SQLite3: create database parameters, view / change.

      • Online backup of databases.

      • Check integrity, index all tables, support transactions.

      • Table management: creating, deleting, renaming, rebuilding indexes.

      • View management: create, delete, rename.

      • Support for temporary tables and views.

      • Copy / Paste records between tables

      • Copying tables between databases

      • Supports password protected databases

    • MySQL DBMS (3.21 and older)

    • MS SQL DBMS - functionality under active development