Skip to content

Latest commit

 

History

History
34 lines (27 loc) · 1.62 KB

OLTPQUICKSTART.md

File metadata and controls

34 lines (27 loc) · 1.62 KB

Quick start of the oltp workload

  • Install the RWP*Load Simulator and set environment variables properly.
  • Make sure you have gnuplot and a http server installed and running.
  • If at all possible, create a repository that is not in your database under test.
  • Create a database for your testing.
  • Decide upon a short project name (could be the same as your database) and copy the two files oltp.env and oltp.rwl using your project name to your working directory.
  • Edit these two files according to the comments in them. Note that the latter file with rwl suffix often is referred to as your projects parameter file.
  • Create the awr directory and results directory.
  • Prepare your http server such that the awr directory is visible from a browser.
  • Run oltpverify -ds to verify directories and dba access to your database.
  • Run oltpcreate to create schemas.
  • Run oltpverify -a for a complete verification of database schemas.
  • Run oltpcore as your first run
  • Verify you can browse results from this run

You will now be ready to do real runs that may include:

  • Running oltprun for individual runs
  • Modifying parameters in your projects parameter file
  • Doing scaling runs using oltpscale
  • Running continuous runs using oltpforever

Note that most scripts take a -H option to provide a brief help.

All reference guides is available as rwlman pages, start with rwlman oltp

Navigation

  • index.md Table of contents
  • OLTP.md Previous topic: Setup and use of the oltp workload
  • CLOB.md Next topic: Using CLOB data