Click here for a demonstration

A sharp eye on performance

Developed by Mark Gurry & Associates, MGA EagleEye™ is a software tool that proactively monitors the performance of Oracle databases and provides real time diagnostic information to allow for immediate rectification of performance problems.

download eagleeye datasheet (PDF, 1262kb)

Features of MGA EagleEye

With an interface that's both attractive and easy to use, MGA EagleEye™ provides:

• Measures performance over time with drill-down capabilities to find the cause of the problem

  Timely information that identifies users' running problem SQL statements along with their explain plans
  
  
• A mechanism to observe the response times as experienced by an end user, and the necessary tuning details to act upon it when they are unacceptable
  
  
• A common interface into data performance issues for Database Administrators and SQL writers
  
  
• Detailed information for technicians to address badly performing SQL statements, and for production support teams responsible for the preparation of SQL business reports
  
  
• NEW Inbuilt Tuning Methodology based on MGA's leading best practices
  
  
• NEW Inbuilt Web Benchmarking provides a Load/Stress Testing capability. Includes Servlet and HTTP replay support
  
  
• Information for management to enable performance against service delivery benchmarks to be measured and monitored
  
  
• Information on: Waits in tables and indexes, shared pool problems, analysis of tables and indexes, sort efficiency, disk I/O bottlenecks and potential causes such as fragmentation and chaining.

EagleEye Focus on PeopleSoft Performance

PeopleSoft systems are designed to be highly scalable and platform independant. PeopleSoft utilizes SQL extensivily throughout the application, and since this SQL is designed to be database platform independent, it does not come tuned out of the box. Performance tuning is a nessesary part of every PeopleSoft implementation, and on-going performance monitoring and maintance must also be a part of your overall approach to keep your system running optimally. A properly tuned PeopleSoft system will save you from poor performance and costly unnessesary hardware upgrades.

EagleEye is a very affordable and cost effective way to optimize your investment in PeopleSoft. You may want to ask, "How is EagleEye able to help me with my PeopleSoft system better then the other tuning products available in the market today?" The answer is simple, Mark Gurry and MGA have been tuning PeopleSoft systems with great success for many years now.

Based upon his extensive PeopleSoft tuning experience combined with 20 plus years of Oracle experience Mark and MGA have developed MGA's PeopleSoft Tuning Methodology. This highly successful tuning methodology is fully integrated into EagleEye, and was designed specifically for PeopleSoft running on Oracle. It will guide you through the entire process of diagnosing and correcting performance problems.

When it comes to PeopleSoft and Oracle there is no better performance tuning tool available in the market today. Contact us for a free internet demonstration, where you can watch as well as talk to our experts right from your desk.

Control Centre - Provides an up-to-date health assessment of the database

Benefits of using MGA EagleEye:

Providing information that would otherwise require the use of several products, MGA EagleEye™ offers many benefits including:

• A cost effective solution against leading alternatives providing a high return on investment
  
  
• Expert advice via practical examples derived from MGA's extensive experience at client sites
  
  
• Significant performance improvements after problems have been experienced with ERP and custom applications
  
  
• Simple installation, user friendly and fully supported by MGA's support team
  
  
• Lightweight on machine resource usage.

MGA EagleEye 4.3 (Expert SQL Tuning for Developers)

This new release has been created to assist Oracle SQL developers to produce highly tuned SQL. MGA tunes many Oracle sites. The performance issues that we observe are often caused by inefficient code. This release of EagleEye assists the developer to avoid this issue by offering Coding Standards, extended tracing, real life usage of hints and much more.

The new functionality includes:

• (i) The ability to "Trace your Session" from the SQL Worksheet. This allows you to run various SQL statements with a variety of bind variables and then obtain a detailed set of diagnostics per SQL statement including runtime per bind, accesses per index / table, wait events and more. The trace appears in EagleEye without having to go out to the operating system to identify and retrieve the trace file.
  
  
• (ii) "SQL Coding Standards" are being added to the Worksheet. The coding standards include how to construct your SQL for highest efficiency (for example, IN versus EXISTS) as well as a list of the 15 biggest causes of untuned SQL and much more.
  
  
• (iii) A comprehensive set of ALL "Oracle Hints" in provided the SQL Worksheet along with syntax, descriptions and real world usage.
  
  
• (iv) "Keywords are colored" in the SQL Worksheet for ease of readability. You can also shrink subqueries and inline views to make it easier to read the SQL. This is useful for speeding the tuning of long and complex SQL statements
  
  
• (v) SQL statements can have "Enhanced Formatting" applied for easy readability
  
  
• (vi) "Bind Variables can be translated" automatically to avoid you having to search in your tables to find suitable bind values to place into the query.
  
  
• (vii) "SQL History" of the last 100 SQL statements is maintained. You can double click on the SQL and place it back into the WorkSheet. The history extends beyond your current session, allowing you to select SQL entered previously.
  
  

4.3 Release Compatability

• Oracle10G (ALL) Compatible
  
  
• Provides the V$SQLPLAN execution plan in addition to the PLAN_TABLE execution plan (required for Oracle9i and 10G to observe correct execution plan)
  
  

4.3 DBA Functional Improvements

• Interfaces into Statspack SQL, to provide the SQL runtime information along with the execution plan at the time the statement was run
  
  
• Advanced diagnostics on a per session basis including > Wait Events > Latch Information > Sort Usage > Undo Usage
  
  
• Advanced monitoring of segment (table/index) waits
  
  
• PeopleSoft diagnostic improvements
  
  
• Diagnoses all SQL performing Full Scans
  
  
• Advanced Oracle Alert Log monitoring
  

Support

To download MGA EagleEye visit the download page or for more information on the full range of MGA products and services, contact us today.

USA +1 425.943.6800
Australia +61 3 9428 8454