Read
my notes on Oracle
stress testing. There are many ways to do load
testing in Oracle:
-
Replay SQL workloads: You can capture
real-world workloads and replay them in your load testing
database. See
real_applications_testing for details on load testing
with RAT.
- Manually submit SQL:
You can use the Linux/UNIX "nohup" command to submit 100 SQL
statements for simultaneous execution.
- Use a load testing
benchmarking software package: There are many
tools for Oracle load testing. See my tips on
benchmark_testing. The load testing packages
include the benchmark factory,
hammerdb
and RAT, Oracle real application testing.