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.
* 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.
Key features:
* Multiple SQL Editors with auto complete feature for Table names and Column names
* Real Time Performance Monitoring using graphs, Bar Charts & 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.