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 surgical monitoring, numerical or graphical performance analysis, or embedded
into a performance management system enabling real-time monitoring catching 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 to monitor before the event occurs."
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.