Skip to Main Content
  • Questions

  • How to performance Oracle DB load testing

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Srikanth.

Asked: January 19, 2016 - 6:12 am UTC

Last updated: January 20, 2016 - 2:03 am UTC

Version: 12

Viewed 10K+ times! This question is

You Asked

Could you please help me to perform Oracle Database load testing to evaluate performance on a new environment.

Version : 12c on Standard / EE



and Connor said...

If you are licensed for Real Application Testing, you can capture your actual application load and replay into 12c.

If you dont have a load "ready to go", then look at:

Swingbench
http://dominicgiles.com/swingbench.html

which is various java-based applications you can use to measure and observe your environment

SLOB
http://kevinclosson.net/2012/02/06/introducing-slob-the-silly-little-oracle-benchmark/

which is more of a hardware hammering tool. It will tell you what your hardware is capable of from an Oracle perspective.



Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Oracle 12c replay feature

Thiru, January 19, 2016 - 9:12 am UTC

If you would like to test the database alone without involving other tiers, you can use Database Replay.

You can use Database Replay to capture a workload on the production system and replay it on a test system with the exact timing, concurrency, and transaction characteristics of the original workload. This enables you to test the effects of a system change without affecting the production system.

Database Replay supports workload capture on a system running Oracle Database 10g Release 2 and newer releases. In order to capture a workload on a system running Oracle Database 10g Release 2, the database version must be 10.2.0.4 or higher. Workload replay is only supported on systems running Oracle Database 11g Release 1 and newer releases.

More information on the same can be found in:

https://docs.oracle.com/database/121/RATUG/GUID-C5CAF3E6-0F1C-4BD6-BC03-F71744AD600E.htm
Connor McDonald
January 20, 2016 - 2:03 am UTC

Agreed, but to use it you must be licensed for Real Application Testing (RAT)

And if you are licensed for RAT, you may as well use the entire facility, not just the Replay part.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.