Download Database.com

MyOra

MyOra SQL 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.

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

- Download MyOra -