- 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.
Space Manager - Segment Type Pie chart
- SQL Type (Select, Update, Insert. etc)
- User Name
For each SQL Statement the following information is displayed
- SQL Text
- SQL Execution details
- Explain Plan
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
- System Waits
- Call Rate
- Top Sessions (by Resource Usage)
Copyright © Jayam Systems, LLC
Space Manager - Tablespace Used & Free Bar Graph
Space Manager - Segment Type Bar Graph