Download MyOra 1.0.4 Freeware Free Software

MyOra is a 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 is developed using Java in order to provide a cross platform tool compatibility. Runs on Windows, Linux and MAC OS X. (MyOra version 1.0.4 only runs on Windows). MyOra connects to Oracle database using JDBC driver.

• Requires no Oracle client.
• Requires no installation on client (local computer) or sever (database).
• Handles multiple connections to database.
• Built on Multi Document Interface (MDI) framework, which can handle multiple sub-windows opened at the same time.
• Multiple SQL Editors with auto complete feature for Table names and Column names
• Real Time Performance Monitoring using graphs, bar charts and pie charts.
• View DB Activity in real time using Six interactive graphs.
• 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 and 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.