Unexpected performance events are disastrous because they catch you by surprise. If you knew what to watch out for, obviously you would have monitored the situation. By knowing exactly what Oracle internal activity stresses your database servers' CPU, IO, and network subsystems you can be sure that anytime an application, Oracle, or a user change occurs you'll be able to know if it will impact your system. That's powerful because performance threats are effectively dealt with before they are allowed to become disastrous. That's why the Stress Identifier product is more—a threat identifier.
A little more detail...
The OraPub Stress Identifier is an automated software product which allows Oracle
DBAs to determine what specific Oracle internal database activity is stressing their database server.
The results can be used for numerical or graphical performance analysis, or embedded
into a performance management system enabling close monitoring to catch any
harmful change or trend. As any DBA will tell you, "If something impacts my
system, it impacts me. So I've got to know what is stressing my system."
Stress metrics for CPU, IO, and network subsystem are determined along with a very
flexible date selection range. For example, this product may discover that on
Friday's between 0900 and 1500 Oracle data block buffer changes are what is
really pushing the CPU utilization. Therefore, the DBA will want to closely
monitor and trend block changes as well as any instance and SQL tuning that
impacts block changes. As you can see, this product reduces the risk of performance
problem surprises and unexpected downtime resulting in smoother and optimal operations.
The product pulls from Statspack data, runs in SQL*Plus, is non-graphical, works on RAC systems, and runs on Oracle 10g and beyond. It is licensed per Oracle instance at only $49 for three years and there is no annual support fee.
