Back to the main page
Dramatically Speed Routine Tasks with Oracle Real Application Testing’s SQL Performance Analyzer Quick Check Feature
With a single click of a button, database administrators (DBAs) can now test the impact of routine administrative operations directly on the production database itself, thanks to the new feature of Oracle Real Application Testing called SQL Performance Analyzer (SPA) Quick Check.
Because the SPA Quick Check feature supports scoped and change-aware intelligent workflows, DBAs can verify routine database administration tasks such as optimizer statistics gathering and init.ora parameter changes with unprecedented speed and accuracy.
The new feature is available starting in Oracle Enterprise Manager 12c’s database plug-in release 220.127.116.11 and supports Oracle Database 11.2 and later.
Test vs. Production
As every DBA knows, it is safer to run tests on a test system, but that requires separate hardware—and provides less-reliable results. On the other hand, testing on production databases tends to be resource-intensive and risks affecting performance.
Now, the SPA Quick Check feature in Oracle Real Application Testing changes the equation.
"This new feature removes the costs and risks associated with production testing, so DBAs can conduct more-accurate tests more quickly and at dramatically lower risk," says Oracle Principal Product Manager Kurt Engeleiter.
How SPA Quick Check Works
In order not to affect production environment performance, SPA Quick Check
- Uses minimal system resources by first identifying SQL statements with plan changes and then test-executing only those statements. The result: you consume only a fraction of system resources.
- Limits resource usage by placing runtime limits for each SQL statement, preventing runaway SQL queries.
- Enforces a limit on the total amount of system resources utilized to ensure production performance is not impacted.
"When you empower DBAs to quickly and accurately test routine tasks, you not only increase productivity but also enhance the quality of service of your mission-critical databases," concludes Engeleiter.
Watch a webcast devoted to Oracle Real Application Testing’s SPA Quick Check feature.
Learn more about Oracle Real Application Testing.