System Waits - Shows Session level and System wide waits in the database using pie charts.
Top 5 SQL - View Top 5 SQLs in four categories using interactive 3-D bar charts.
Server Tuning - Shows Physical i/o, Logical i/o and CPU, Elapse Time of all SQLs.
Top 5 Resource - View Top 5 Resource Usage sessions in four categories using interactive 3-D bar charts.
Resource Usage - Shows Resources used at Session level and System wide.
DB Activity - Shows database activity in real time using Six interactive graphs.
Wait Analysis - Shows Wait Classes, CPU Usage, Events, Objects, Sessions and SQL statements.
Top Ten SQL - Shows Top Ten SQLs in nine different categories using interactive 2-D / 3-D pie charts.
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….
Pie chart for storage by Segment Type (User objects).
Pie chart for free and used Tablespace.
Tablespace File details.
Objects in each Tablespace.
Space Manager - Segment Type Pie chart
SQL Type (Select, Update, Insert. etc)
SQL Text string
For each SQL Statement the following information is displayed
SQL Execution details
SGA Configuration Pie chart for Buffer Cache, Fixed SGA, Log Buffer, Java Pool, Large Pool, Shared Pool.
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: