Oracle Information InDepth



Stay Connected

Oracle on Facebook Oracle on Twitter Oracle on Youtube Oracle on LinkedIn Oracle Blog

April 2014

Subscribe Subscribe Forward Forward

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 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.

Back to Top

Please send questions or comments to

This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor is it subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.

Copyright © 2014, Oracle and/or its affiliates. All rights reserved.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

  Hardware and Software, Engineered to Work Together Contact Us | Legal Notices and Terms of Use | Privacy
Oracle Corporation


Oracle Corporation - Worldwide Headquarters, 500 Oracle Parkway, OPL - E-mail Services, Redwood Shores, CA 94065, United States

Your privacy is important to us. You can login to your account to update your e-mail subscriptions or you can opt-out of all Oracle Marketing e-mails at any time.

Please note that opting-out of Marketing communications does not affect your receipt of important business communications related to your current relationship with Oracle such as Security Updates, Event Registration notices, Account Management and Support/Service communications.