MyOra has 17 different modules (screens), 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 and at the middle of each icon module code is shown. (Please refer MyOra user guide for list module codes and module names). If you click on an icon, the module corresponding to the module code will be activated.
If there is more than one active connection for a given module, then the total number of active connections will be shown at the top right corner of the icon. If you click on an icon with multiple active connections, means an icon with a number on top right corner, then the icon will explode into individual connections and each icon will represent one connection.
Note: On MyOra Console the maximum active connection display limit is 16 for any module. In general, MyOra can have up to 100 active connections (for a single module or combination of modules), but on Console only the first 16 connections of a module will be shown.
The bottom row of the Console has four anchor icons which corresponds to four modules, these modules are SQL Editor, Schema Explorer, Session Manager and Performance Monitor. The anchor icons are always shown at the same location on Console. If there is no active module corresponding to anchor icons, then that icon will not be shown.
Shows Top Ten SQLs in nine different categories using interactive 2-D / 3-D pie charts. These categories are disk reads, buffer gets, cpu time, elapsed time, direct writes, sharable mem, executions, fetches, rows processed. Top Ten SQLs are retrieved from the database system tables for every 5 seconds (can be changed to any value between 5 seconds and 10 minutes).
Each 2-D/3-D interactive pie chart is responsive to cursor. The SQL id and percentage values for each SQL is listed left of pie chart. If you place the cursor on SQL Id, then the first 60 character of SQL text is shown.
Tt - Top Ten SQL
Top Ten SQL (v5.1)
Blockers Waiters shows Session Blockers, Session Waiters, Locks and Long Running Queries. Also shows all Resource Usage details of each Session.
Bw - Blockers Waiters
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.
Additions to Instance Details and Server Statistics screens.
Resource Limits and License tabs are added to Instance Details screen.
Database Growth, Data Rows and DB Links are added to Server Statistics screen.
Version 6.4 (new)
Wait Analysis screen is added with four separate Real-time graphs to show Logical I/O, Physical I/O, Call Rate and Sessions details. Users can toggle between Wait details and graphs.