MyOra 6.0

MyOra is a free Oracle database monitoring tool that provides real-time performance monitoring with the fastest response time. This software is ideal for Oracle database developers, DBAs, and companies who need a simple and easy-to-use tool for monitoring database performance.

One of the key features of MyOra is its real-time performance monitoring capability, which uses graphs, bar charts, and pie charts to display DB activity. Six interactive graphs allow users to view database activity in real-time, making it easy to identify any issues that may arise. Multiple performance monitoring windows can be opened for the same or different databases, providing a comprehensive overview of database performance.

System waits can be viewed using pie charts, while the top 5 SQLs and their details can be viewed using interactive 3-D bar charts. Similarly, the top 5 resource-using sessions and their details can be viewed using interactive 3-D bar charts, while resource usage can be viewed at both session level and system-wide. The software also provides a view of the tablespace tree, pie chart for tablespace used/free, and storage by segment type.

MyOra's performance monitoring features include the ability to monitor sessions and display details such as statistics, connection information, and database objects. Users can also view physical and logical I/O, CPU time, and elapsed time of all SQLs. Session wait events, blocking sessions, locked objects, open cursors, and current statements can also be viewed.

The software is written in Java and connects to the Oracle database using Oracle JDBC driver. It is currently available only for Windows. It requires no installation on the client or server and can handle multiple connections to the database. Built on a multithreading, multiple document interface (MDI) framework, it allows users to open many sub-windows at the same time. This MDI framework provides a user-friendly interface for working with multiple sub-windows, which can be arranged and viewed vertically or horizontally. Any sub-window can be minimized, maximized, or closed at the click of a button.

Users can open multiple schema explorers, session managers, and more, and view them vertically or horizontally. MyOra is simple to use, requiring only a download to the local drive or flash drive. It can be unzipped and double-clicked to start the application, making it easy to use anywhere. Its smaller byte code and single-file executable make it lightweight and portable.

In summary, MyOra is an excellent choice for anyone who needs a free, easy-to-use Oracle database monitoring tool. Its real-time performance monitoring capabilities, multiple sub-window interface, and ability to handle multiple connections to the same or different databases make it a powerful tool for Oracle database developers and DBAs alike.