Aplikasi OSS

TOraSQL PDF Cetak
Kamis, 10 Pebruari 2011 22:35

TOra adalah GUI untuk mengelola sejumlah format basis data (Database) yang umum seperti Oracle, MySQL, atau PostgreSQL. Tersedia untuk dijalankan baik di Linux, Windows, maupun Mac dan menawarkan fitur database queries standar dan browsing. TOra juga mnyertakan tabel SQL worksheet berikut syntax highlighting, sebuah PL/SQL debugger, dan full set untuk DBA tools. TOra tidak didsain untuk pengguna office awam, namun sangat bermanfaat bagi yang membutuhkan perkakas untuk mengelola basis data.

Features

  • Handles multiple connections.
  • Asynchronus database communication. UI mostly responsive when accessing database.
  • Requires no installation on the database side to be fully functional.
  • Advanced SQL worksheet.
    • Code completion.
    • Explain execution plan.
    • Execution statistics.
    • SQL syntax highlighting.
    • Quick menu for often used custom SQL.
    • Parse error location indication.
    • Chart visualization of result.
    • PL/SQL block parsing.
    • Schema browser.
    • Table & view editing.
    • References & dependencies.
    • Tab & tree based browsing.
    • Object & data filtering.
    • PL/SQL editor & debugger.
    • Breakpoints.
    • Variable watches.
    • Line by line stepping.
    • Debugger SQL output viewing.
    • Syntax structure tree parsing.
  • Server tuning.
    • Server overview.
    • Tuning charts.
    • I/O by tablespace & file.
    • Performance indicators.
    • Raw server statistics.
  • Parameter editor (P-file editor).
  • Security manager.
  • Storage manager with object & extent viewer.
  • Session manager.
  • Rollback manager with snapshot too old detection.
  • SGA & long operations trace.
  • Current session information.
  • Statistics manager with parallel analysis.
  • DBMS alert tool.
  • Invalid object browser.
  • SQL output viewer.
  • Database & schema comparison and server.
  • Extract schema objects to SQL scripts.
  • Easily extendible.
  • Ability to add support for new or older Oracle versions without programming.
  • Well documented plugin API (Only Linux version).
  • SQL template help with PL/SQL functions and optimizer hints.
  • Full UNICODE support.
  • Printing of any list, text or chart.
  • Cross platform support. Known to work on Linux, Windows and Solaris.

Website: http://torasql.com/


2010-09-19: TOra 2.1.3

This release brings some new features:

  • Terradata support
  • AWR performance report tool
  • XML formatting for memo editor/display
  • Improved support for displaying routines in MySQL. From now on it will display full routine creation script including arguments, return type etc.
  • Close buttons in tabs implemented
  • Connection dialogue: test connection button
  • F4 describe under cursor in PL/SQL editor
  • RFE #2949032 tab with directories into the schema browser
  • RFE #2916092 - column “percentage free” in the storage manager
  • A lot of bugs have been fixed as well