SLOB2 Kick start

SLOB2 add ons from Yury - the SLOB2.zip file provides a set of additional or modified scripts that I used in some of my SLOB tests.

For all the tests I will be talking about in this blog post I kept slob.conf=> UPDATE_PCT=00 to make those read only (This is to simplify the testing; it was challenging enough to interpret results without writes.) Please note that those scripts are just a small portion of the tests that I have been executing. It doesn't represent all the sets of scripts/tests that I would recommend to run (It depends on your setup and testing goals.). In fact, as the father of the SLOB utility, Kevin Closson declares that SLOB is just a framework for your testing. It doesn't provide a set of tests that you run to measure your system performance. The tests' configuration is your responsibility and you are the only person who knows most of the details of your setup. (Hopefully.)

-- " slob_setup_for_PIO_test_01.txt" modifications of the spfile parameters for PIO testing

-- " snap_data.sh" script to collect all the results right after a test run. This script allows us to run a set of scripts in a batch mode without stopping for collecting results. (see the next script)

-- " run_t22.sh" example of a test run script. It runs the tests gradually increasing readers numbers. The idea here is to run the script and collect all results later on after the set of tests is completed.

-- " slob.conf" WARNING! just an example you need to adjust for your testing needs (as any of the scripts I have provided)

-- " run_the_lio_test_01.txt" a command to start the test

note: the set of scripts bellow have been adjusted for a single/shared table read-only LIO testing. The size of the table (slob.conf=> SCALE= XXXX ) should be close to size of the max buffer cache you can afford in your systems.

-- " run_t23.sh" kick off script with instance restart and cache warm-up code

-- " runit.1.sh" - modified runit.sh script to divert all readers to 1 schema/table only

-- " slob_1.sql" - modified slob.sql script for 1 schema/table only

One last warning: for some of you it could be obvious, but I have missed it during the first few runs and lost a bit of testing time because of the issue. Check cr_tab_and_load.out file each time you run ./setup.sh to create new test data. Kevin put a warning in the setup.sh. Do not ignore it!

The ./setup.sh script have the following message:
 
 NOTIFY: ./setup.sh: Loading procedure complete (130 seconds). 
 
 Please check ./cr_tab_and_load.out for any errors