MyOra - Free Oracle Database Monitoring and SQL Tool

Versions

MyOra 1.0.0 Release Date - November 4, 2009

MyOra 1.0.1 Release Date - December 11, 2009

Initial Release.

MyOra 1.0.4 Release Date - April 9, 2010

New Feature - DB Activity added.
Added Segment Type Bar graph to Space Manager feature.
Added Tablespace Used & Free Bar graph to Space Manager feature.
Added Options window (Menu path Tools -> Options).
Performance Monitor process has an option to Enable / Disable the Refresh Button.
Space Manager has option to choose graphs on first tab.
Several improvements and bug fixes.

MyOra 1.0.2 Release Date - December 21, 2009

Several improvements and bug fixes.

MyOra 2.0.0 Release Date - July 12, 2010

Connects to database using Oracle JDBC Thin Driver (ojdbc14.jar or ojdbc5.jar or ojdbc6.jar files).
Added Search option for Help pages.

MyOra

MyOra 3.5 Release Date - July 12, 2012

Several improvements and bug fixes.

New Feature - Wait Analysis added.
Several improvements and bug fixes.

MyOra 3.0 Release Date - July 12, 2011

SQL syntax highlighting feature added to SQL Editor.
In memory processing is added in Performance Monitoring.
Enhanced Options window.
Changes made on Options window will be saved to Configuration file.
Several improvements and bug fixes.

MyOra 4.0 Release Date - July 12, 2013

Save password is added for login.
SQL statements ending with semicolon will execute without error, means now MyOra executes SQL statement ending with semicolon.

MyOra 4.5 Release Date - July 13, 2014

MyOra Console is added, the main purpose of MyOra Console is to show all active modules at once in a easy accessible manner. MyOra Console shows all active modules in form of icons. Each icon represents one module.

v10.2

MyOra 5.0 Release Date - July 13, 2015

Top Ten SQL screen is added. Shows Top Ten SQLs in nine different categories using interactive 2-D / 3-D pie.

MyOra 5.1 Release Date - January 14, 2016

Session Blockers, Session Waiters, Locks and Long Running Queries.

MyOra 6.0 Release Date - January 13, 2017

Improvements to Database Login popup window.
On the Performance Monitor screen, the Top SQL section shows SQL Id instead of SQL Hash value.
Improvements to Top5 SQL screen.
On the SGA Display screen, SQL Id search filter is added.
Improvements to SQL Editor screen.

MyOra 5.5 Release Date - July 13, 2016

Additions to Instance Details and Server Statistics screens.

MyOra 6.4 Release Date - July 13, 2017

Wait Analysis screen is added with four separate Real-time database activity graphs to show Logical I/O, Physical I/O, Call Rate and Sessions details. Users can toggle between Wait details and activity graphs.

Improvements to SQL Editor screen.

MyOra 7.5 Release Date - July 4, 2018

MyOra Console 2 is added, the purpose of Console 2 is to show active modules in windows explorer style. The all active modules in each database instance are shown in expandable or collapsible manner.

MyOra 7.0 Release Date - January 14, 2018

Session Manager screen is added with search filters for Session IDs, Oracle Users, OS Users, Machine, Active/Inactive sessions and SQL IDs.

Improvements to SQL Editor screen.

MyOra 8.9 Release Date - July 14, 2020

Program Global Area (PGA) memory usage details.

History of Versions

MyOra 8.0 Release Date - January 15, 2019

Top 25 tables with Segment details is added to the Space Manager.

MyOra 8.2 Release Date - July 14, 2019

Oracle Scheduler Job details are added to the Server Statistics screen..

MyOra 8.6 Release Date - January 15, 2020

Top 25 indexes with Segment details is added to the Space Manager.

MyOra 9.0 Release Date - January 14, 2021

Program Global Area (PGA) memory usage and details of PGA.

Several improvements and bug fixes.

MyOra 9.2 Release Date - July 14, 2021

SQLs running more than 1 minute.

MyOra 10.2 Release Date - January 15, 2024

Shows sessions generating lot of Redo

MyOra 9.4 Release Date - January 14, 2022

Shows details of Sort usage of SQLs.

MyOra 9.6 Release Date - July 14, 2022

Shows details of Active Transactions

MyOra 9.8 Release Date - January 14, 2023

Top 10 Temp Space using Sessions

MyOra 10.0 Release Date - July 15, 2023

Shows OS CPU and Memory