Recommended tool for Oracle Upgrades and Performance Monitoring
Use Cases and Deployment Scope
[Oracle Application Testing Suite] is used for large scale Oracle databases supporting the main functions of the organization. It is used in multiple capacities, both as an upgrade testing and validation tool and as an ongoing performance analysis tool for daily monitoring of baseline response times. Independent departments also use the tool when building and testing department specific data warehouses.
Pros
- Load testing with useful graphical interface tools to watch real time performance
- Flexible configuration for monitoring utilities
- Historical tracking for baseline performance before and after upgrades
Cons
- Security rights can be complicated if multiple types of users are required at enterprise level
- Depending on the size and upgrade requirements, additional custom scripting may be needed
- For daily monitoring a custom database may need to be built for reporting needs
Likelihood to Recommend
The Oracle Application [Testing Suite] is used heavily in our organization for independent regions to perform Oracle upgrades. Baseline performance can be monitored before the upgrade and compared to a production query load, we are able to easily monitor server performance and make an accurate prediction of upgrade performance. DBA's are able to use the testing suite for ongoing validation of database performance during peak times.