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.
Copyright © Jayam Systems, LLC
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.
Blockers Waiters shows Session Blockers, Session Waiters, Locks and Long Running Queries. Also shows all Resource Usage details of each Session.
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.