MyOra is a free SQL Tool for Oracle database developers and DBAs. This tool is simple, fast and easy to use, requires no installation, no Oracle client and no internet connection. Just download, unzip and start using with a click of the mouse, run SQL queries and Monitor database performance in Real Time. MyOra's MDI (Multi Document Interface) framework handles multiple sub-windows opened at same time. Allows multiple connections to the same database or different database. Users can open any number of Performance Monitors, SQL Editors, Schema Explorers, Session Managers etc and view them vertically or horizontally. Real Time Performance Monitoring using graphs, bar charts and pie charts. Top 5 SQLs (SQL details and Explain Plan) using interactive 3-D bar charts. Top 5 Resources (Sessions Statistics) using interactive 3-D bar charts. Tablespace used/free pie charts. Session Manager to monitor sessions. Multiple SQL Editors with auto complete feature for Table names and Column names and many more features.

Features :

* Multiple SQL Editors with auto complete feature for Table names and Column names
* Real Time Performance Monitoring using graphs, bar charts & pie charts.
* Multiple Performance Monitoring Windows for same or different databases.
* Ability to show System Waits using pie charts.
* View Top 5 SQLs and its details using interactive 3-D bar charts.
* View Top 5 Resource Using Sessions and its details using interactive 3-D bar charts.
* View Resource usage at Session level and System wide.
* View Tablespace Tree, pie chart for Tablespace used / free and storage by Segment Type.
* Monitor Sessions and display details(Statistics, Connection Information, Database objects).
* Able to see Physical i/o, Logical i/o and CPU Time and Elapse Time of all SQLs.
* Show Session Wait Events, Blocking Sessions, Locked Object, Open Cursors and Current Statements.
* View Profiles, Users, Roles and Privileges.
* View information about SQL statements using SGA Display.
* Display Oracle parameters and buffers using pie chart.
* Show details about Server Statistics(System Waits, Shared Pool, Library Cache, Analyzed Stats).
* Executes SQL statements, SQL scripts and PL/SQL blocks.
* View History of SQL statements.
* View result data in vertical format (Single Record view).
* Export result data grid to a Text file or CSV file.
* Run multiple SQL statements as script.
* Recalls previously run SQL Statements.
* Explains execution plan of SQL statement.
* Shows statistics of the SQL execution.
* Invoke multiple Table Describe popup windows.
* Invoke Tables & Views Tree popup window.
* Sorts the result data grid by column.
* Schema Explorer to see Tables, Views, Indexes, Synonyms, Sequences...
* View details about each database object and total objects in each object type.

Platform: Windows 2000, Windows XP

System Requirements: There is no specific requirements

Language: English