|
|
The TOTAL Oracle Performance Monitoring
Solution
MGA
EagleEye is a software tool developed by
Mark Gurry & Associates (MGA) that
proactively monitors the performance of
Oracle databases and provides real time
diagnostic information to allow for
immediate rectification of performance
problems. Mark Gurry and his team of
performance tuning experts utilized their
world-renowned performance tuning
expertise derived from years of experience
at sites around the world to design this
unique product. It has a GUI front end
that logs in to a user created in an
Oracle database that contains a number of
small tables and packages.
Benefits of MGA EagleEye
MGA
EagleEye ensures that the business has
timely and accurate information to
effectively eliminate poor database
performance. It provides:
- Timely information
that identifies users running problem
SQL statements along with their explain
plans
- A mechanism to
observe the same response times that an
end user is experiencing, and when they
are not acceptable, have the necessary
tuning details to act upon it
- Database
Administrators and SQL writers with a
common interface into data performance
issues
- Technicians with
detailed information on badly performing
SQL statements
- Detailed performance
information to assist production support
teams responsible for the preparation of
SQL business reports
- Information to
management to enable performance against
service delivery benchmarks to be
measured and monitored
Why choose MGA EagleEye?
-
A cost effective solution against leading
alternatives that provides a high return
on investment
-
Includes expert advice via practical
examples derived from MGA's extensive
experience at client sites
-
Significant performance improvements
already realized by many MGA clients
previously experiencing performance
problems with ERP and custom applications
-
Simple to install, user friendly and fully
supported by MGA's support team
Features:
The
MGA EagleEye product provides an attractive
and easy to use interface that provides you
with information that typically requires the
use of several products.
-
Runs a set of SQL statements and records
tuning information when expected response
times are exceeded, including details of
logged on users, the applications and
specific actions they are running, and
where the contention is occurring
- Produces graphical
information on expected versus actual
response times providing information that
is typically required to report against
service level agreements
-
Extremely lightweight on machine resource
usage
-
Provides 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
- Quickly identifies
locking problems
- Provides immediate
feedback on the robustness or otherwise of
Oracle database
|