MyOra

MyOra is developed using Java in order to provide a cross platform tool compatibility. Runs on Windows, Linux and MAC OS X. (MyOra version 2.0.0 only runs on Windows). MyOra connects to Oracle database using Oracle JDBC driver. * Requires no Oracle client. * Requires no installation on client (local computer) or sever (database). * Handles multiple connections to database. * Built on Multi Document Interface (MDI) framework, which can handle multiple sub-windows opened at the same time. Key features: * Multiple SQL Editors with auto complete feature for Table names and Column names * Real Time Performance Monitoring using graphs, Bar Charts & pie charts. * View DB Activity in real time using Six interactive graphs. * Multiple Performance Monitoring Windows for same or different databases. * Ability to show System Waits using pie charts. * View Top 5 SQLs and its Details using interactive 3-D bar charts. * View Top 5 Resource Using Sessions and its details using interactive 3-D bar charts. * View Resource usage at Session level and System wide. * View Tablespace Tree, pie chart for Tablespace used / free and storage by Segment Type. * Monitor Sessions and display details(Statistics, Connection Information, Database Objects). * Able to see Physical i/o, Logical i/o and CPU Time and Elapse Time of all SQLs. * Show Session Wait Events, Blocking Sessions, Locked Object, Open Cursors and Current Statements. * View Profiles, Users, Roles and Privileges. * View information about SQL statements using SGA Display. * Display Oracle parameters and buffers using pie chart. * Show details about Server Statistics(System Waits, Shared Pool, Library Cache, Analyzed Stats). * Executes SQL statements, SQL scripts and PL/SQL blocks. * 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.