1. SQL Editor                   - Executes SQL statements, SQL scripts and PL/SQL blocks.
  2. Schema Explorer        - Explore Database objects like Tables, Views, Indexes, Synonyms, Sequences...
  3. Session Manager       - Displays information about Sessions.
  4. Space Manager          - Displays free and utilized Tablespace using pie charts.
  5. User Manager             - Shows Profiles, Users, Roles and Privileges.
  6. SGA Display               - Shows information about SQL statements.
  7. Instance Details          - View Oracle parameters and buffers using pie chart.
  8. Server Statistics         - System Statistics and system wait time.
  9. Performance Monitor  - Display Oracle performance using graphs, bar charts & pie charts.
  10. System Waits              - Shows Session level and System wide waits in the database using pie charts.
  11. Top 5 SQL                   - View Top 5 SQLs in four categories using interactive 3-D bar charts.
  12. Server Tuning              - Shows Physical i/o, Logical i/o and CPU, Elapse Time of all SQLs.
  13. Top 5 Resource          - View Top 5 Resource Usage sessions in four categories using interactive 3-D bar charts.
  14. Resource Usage        - Shows Resources used at Session level and System wide.
  15. DB Activity                  - Shows database activity in real time using Six interactive graphs.
  16. Wait Analysis             - Shows Wait Classes, CPU Usage, Events, Objects, Sessions and SQL statements.
  17. Top Ten SQL             - Shows Top Ten SQLs in nine different categories using interactive 2-D / 3-D pie charts.
  18. Blockers Waiters       - Session Blockers, Session Waiters, Locks and Long Running Queries.

MyOra is built on Multithreading, Multiple Document Interface (MDI) framework, which can handle multiple sub-windows opened at the same time. MyOra allows multiple connections to the same database or different database. MyOra's MDI framework provides most easy to use and easy to manage user interface when working with multiple sub-windows. Sub-windows can be arranged and viewed vertically or horizontally. Any sub-window can be minimized, maximized or closed at the click of a button.

MyOra's MDI framework allows to monitor performance of multiple databases at the same time. Also, users can run SQL queries while monitoring the database. Up to maximum of 100 sub-windows can be opened at the same time. These sub-windows are of any combination Performance Monitor, Schema Explorer, Session Monitor and SQL Editors, etc….
SQL Editor
Click to enlarge
SQL Editor lets you do the following

SQL Editor also has other features



Schema Explorer
Schema Explorer
 
 
SQL Editor
Session Manager
Session Manager
 



Space Manager - Segment Type Pie chart
Space Manager
 
Listed by

Filtered by

For each SQL Statement the following information is displayed


SGA Display
SGA Display
 


Instance Details
Instance Details
 

Server Statistics
Server Statistics
 
shows the condition (health) of the database instance by reading the system tables every 5 seconds (can be changed 5 to 60 seconds). The information is analyzed and shown in Graphs, Bar charts and Pie charts. Performance Monitor screen is divided into 5 sections. The sections are:

Performance Monitor
Performance Monitor
 
o    Time Waited
o    Delta value
o    % Total Time Waited
o    Number of Times Waited
o    Delta value
o    % Total Waits


System Waits
System Waits
 
Top 5 Resource
Resource Usage
 
Server Tuning
Server Tuning
 


User Manager
User Manager
 
 
Click to enlarge
Click to enlarge
Click to enlarge
Click to enlarge
Click to enlarge
Click to enlarge
Click to enlarge
Click to enlarge
Click to enlarge
Click to enlarge
Resource Usage
Top 5 Resource
 
Click to enlarge
Top 5 SQL
Top 5 SQL
 
Click to enlarge

Click to enlarge
Features
Copyright © Jayam Systems, LLC
DB Activity
 
DB Activity

Click to enlarge




Space Manager - Tablespace Used & Free Bar Graph
Space Manager - Tablespace Used & Free Bar Graph
Click to enlarge
Space Manager - Segment Type Bar Graph
Space Manager - Segment Type Bar Graph
Click to enlarge
®
MyOra
Wait Analysis
 
Wait Analysis
Click to enlarge


v6.0
Top Ten SQL
 
TopTen SQL
Click to enlarge
Blockers Waiters
 
Blockers Waiters
Click to enlarge