Changes between MyOra 10.2 and MyOra 10.0
- Shows sessions generating lot of Redo
History (Previous versions):
Changes between MyOra 10.0 and MyOra 9.8
Changes between MyOra 9.8 and MyOra 9.6
- Shows Top 10 Temp Space usage sessions.
Changes between MyOra 9.6 and MyOra 9.4
- Shows details of Active Transactions.
Changes between MyOra 9.4 and MyOra 9.2
- Shows details of Sort usage of SQLs.
Changes between MyOra 9.2 and MyOra 9.0
- SQLs running more than 1 minute.
Changes between MyOra 9.0 and MyOra 8.9
- Program Global Area (PGA) memory usage and details of PGA.
- Several improvements and bug fixes.
Changes between MyOra 8.9 and MyOra 8.6
- Program Global Area (PGA) memory usage details.
Changes between MyOra 8.6 and MyOra 8.2
- Top 25 indexes with Segment details is added to the Space Manager.
Changes between MyOra 8.2 and MyOra 8.0
- Oracle Scheduler Job details are added to the Server Statistics screen.
Changes between MyOra 8.0 and MyOra 7.5
- Top 25 tables with Segment details is added to the Space Manager.
Changes between MyOra 7.5 and MyOra 7.0
- MyOra Console 2 is added to show active modules in windows explorer style. All active modules in each database instance are shown in expandable or collapsible manner.
Changes between MyOra 7.0 and MyOra 6.4
- 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.
Changes between MyOra 6.4 and MyOra 6.0
- 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.
Changes between MyOra 6.0 and MyOra 5.5
- 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.
Changes between MyOra 5.5 and MyOra 5.1
- Additions to Instance Details and Server Statistics screens.
Changes between MyOra 5.1 and MyOra 5.0
- Session Blockers, Session Waiters, Locks and Long Running Queries.
Changes between MyOra 5.0 and MyOra 4.5
- Top Ten SQL screen is added. Shows Top Ten SQLs in nine different categories using interactive 2-D / 3-D pie.
Changes between MyOra 4.5 and MyOra 4.0
- 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.
Changes between MyOra 4.0 and MyOra 3.5
- Save password is added for login.
- SQL statements ending with semicolon will execute without error, means now MyOra executes SQL statement ending with semicolon.
Changes between MyOra 3.5 and MyOra 3.0
- A new module Wait Analysis added.
- Several improvements and fixes.
Changes between MyOra 3.0 and MyOra 2.0.0
- 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 a Configuration file.
- Several improvements and bug fixes.
Changes between MyOra 2.0.0 and MyOra 1.0.4
New MyOra 2.0.0 works with Oracle JDBC Thin driver. The earlier versions of MyOra were packaged with JDBC driver and does not allow to change the JDBC driver.
MyOra 2.0.0 is not packed with any JDBC driver and allows you to use Oracle JDBC Thin driver. You can download Oracle JDBC Thin driver from Oracle website for free of charge.
MyOra 2.0.0 works with Oracle JDBC Thin drivers ojdbc14.jar or ojdbc5.jar or ojdbc6.jar.
Changes between MyOra 2.0.0 and MyOra 1.0.4 using JDBC String
Database login:
The JDBC URL connection string format has changed in MyOra 2.0.0
MyOra 2.0.0 uses the JDBC URL connection string format below:
jdbc:thin:oracle:@localhost:1521:MYDEV
Previously MyOra 1.0.4 used the JDBC URL connection string format below:
jdbc:jayam:oracle://localhost:1521;SID=MYDEV
jdbc:jayam:oracle://localhost:1521;ServiceName=MYDEV