MyOra - Free Oracle Database Monitoring and SQL Tool

SQL Editor - Executes SQL statements, SQL scripts and PL/SQL blocks.
Schema Explorer - Explore Database objects like Tables, Views, Indexes, Synonyms, Sequences...
Session Manager - Displays information about Sessions.
Space Manager - Displays free and utilized Tablespace using pie charts.
User Manager - Shows Profiles, Users, Roles and Privileges.
SGA Display - Shows information about SQL statements.
Instance Details - View Oracle parameters and buffers using pie chart.
Server Statistics - System Statistics and system wait time.
Performance Monitor - Display Oracle performance using graphs, bar charts & pie charts.
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….

SQL Editor lets you do the following

Write and execute SQL statements.
SQL syntax highlighting
Open and execute the script file.
Save SQL Statements to a file.
View History of SQL statements.
View result data in vertical format (Single Record view).
Export result data grid to a Text file or CSV file.
Run PL/SQL blocks and view DBMS.PUT_LINE statements in DBMS output.
Run multiple SQL statements as script.
Recalls previously run SQL Statements.
Explains execution plan of SQL statement.
Shows statistics of the SQL execution.

SQL Editor also has other features

Invoke multiple Table Describe popup windows.
Invoke Tables & Views Tree popup window.
Invoke Table Auto completion popup.
Invoke Column Auto completion popup, if the tables are qualified in SQL statement.
Shows SQL Execution Indicator icons in SQL Editor's left margin.
Scans SQL statements for bound variables and prompts for input values before execution.
Displays the result row count in the status bar of the editor.
Shows statistics of the SQL statement.
Sorts the result data by column.

Explore Tables, Views, Indexes, Synonyms, Sequences, Triggers, Packages, Procedures, Functions, Java Source, Java Classes and DB Links.
View details about each database object.
View total objects in each object type.

Statistics
Connection Information
Accessing (Database objects currently accessing)
Wait Events
Blocking Sessions
Locked Object
Open Cursors
Current Statement (SQL statement currently executing)
Previous Statement (SQL statement previously executed)

Tablespace tree.
Pie chart for storage by Segment Type (User objects).
Pie chart for free and used Tablespace.
Tablespace details.
Tablespace File details.
Objects in each Tablespace.

Space Manager - Segment Type Pie chart

Listed by

SQL Type (Select, Update, Insert. etc)
User Name

Filtered by

SQL Text string

For each SQL Statement the following information is displayed

SQL Text
SQL Execution details
Explain Plan

SGA Configuration Pie chart for Buffer Cache, Fixed SGA, Log Buffer, Java Pool, Large Pool, Shared Pool.
Instance details
Banner
Oracle Parameters
Hidden Parameters
NLS Parameters

Instance Details

Statistics
System Waits
Shared Pool
Library Cache
Analyzed Stats
Rollback Segments
Blocking Sessions
File Activity
Session Activity
Locks
Wait Events
Waiting Sessions
Log History
Latch Details
Running Queries

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:

Top SQL
Ratios
System Waits
Call Rate
Top Sessions (by Resource Usage)

Performance Monitor

System Waits (by Total time waited)

o Time Waited

o Delta value

o % Total Time Waited

System Waits (by Total number of waits)

o Number of Times Waited

o Delta value

o % Total Waits

Profiles
Roles
Privileges
Role Privileges
Users
User Roles
User Privileges

Top 5 SQL shows Physical i/o, Logical i/o, CPU Time and Elapsed Time of 5 top SQL statements in each of these categories since database startup.
Shows 3-D interactive bar graph for Physical i/o, Logical i/o, CPU Time and Elapsed Time.
Shows SQL text, SQL details and SQL execution plan.

Server Tuning shows percentage of Physical i/o, Logical i/o, CPU Time and Elapsed Time of all SQL statements that are executed since database startup.
SQL Analysis for Physical i/o, Logical i/o, CPU Time and Elapsed Time respectively. Data rows in each section are sorted by percent highest value to lowest value.

Top 5 Resource shows Physical i/o, Logical i/o, CPU and Memory of 5 top resource using Sessions (users or processes) in each of these categories since database startup.
shows 3-D interactive bar graph for Physical i/o, Logical i/o, CPU and Memory.
shows Resource Statistics for each session.