MyOra

MyOra Screenshot
MyOra Download
Free Download MyOra 3.0

MyOra is a free SQL Tool for Oracle database developers and DBAs. This software is simple, fast and easy-to-use, requires no installation, no Oracle client and no internet connection. Download MyOra to 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 2.0.0 only runs on Windows). MyOra connects to Oracle database using Oracle JDBC driver.
1. Requires no Oracle client.
2. Requires no installation on client (local computer) or sever (database).
3. Handles multiple connections to database.
4. Built on Multi Document Interface (MDI) framework, which can handle multiple sub-windows opened at the same time.

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

Requirements:
* Java

The license of this software is Freeware, you can free download and free use this database management software.

Database Management Software Related Downloads: