This page will be used to offer quick links to the latest SLOB kit contents.

NOTE: If you are interesting in testing Amazon RDS for Oracle with SLOB, please visit the following webpage for a step-by-step deployment guide: click here.

Where To Get The Latest SLOB Kit

SLOB 2.4.2: Click here (md5sum of this gzipped tar archive is 9291057c28bb653b236e72bc0320c328 ).

SLOB 2.4.2 Documentation: Click here.

2.4.0 Release Notes: Click Here.

Prior Release

Prior releases are no longer offered. Everyone should be using the current SLOB release.

A Word About Release Nomenclature

SLOB releases follow a major.minor.maintenance model. Maintenance level changes will happen at any time but will never include changes that affect on-disk data (e.g., schema changes) or run time. Maintenance releases fall in the category of cosmetic or small documentation changes.

Minor releases will include new features but such features will never require reloading data–with the exception of an optional new feature. An example of an optional new feature that does require reloading data was the Short Table Scan feature introduced in SLOB 2.4. On-disk data was sacred between SLOB 2.3 and SLOB 2.4 but in order to test Short Table Scans after downloading SLOB 2.4, reloading data was required.

Major releases are very rare but are just what the name suggests, major! 🙂

Helpful Information

One can simply google “Oracle SLOB” to find a wealth of SLOB community information. Additionally, I’ll continue to update the following list of helpful SLOB links on this blog:

  1. SLOB Deployment – A Picture Tutorial.  Click the following link: SLOB Tutorial.
  2. SLOB Data Loading Case Studies – Part I. A Simple Concurrent + Parallel Example. Click the following link: Data Loading Part I.
  3. SLOB Physical I/O Randomness.  Click the following link: About I/O Randomness.
  4. SLOB Failing To Generate AWR Reports? Red Hat Bug 919793! Click this link.
  5. Graham Thornton posted this fantastic step-by-step for testing All-Flash storage with SLOB: Testing EMC Unity All-Flash with SLOB (A highly recommended SLOB user post 3/2017)

SLOB Recipes

These posts include SLOB performance examples to include slob.conf and init.ora parameters:

SLOB Recipe: Loading 8TB Scale SLOB on EMC XtremIO with a Single 2-Socket Linux Host

62 Responses to “SLOB Resources”


  1. 1 Stanley Raj May 29, 2014 at 8:12 am

    Is ORA-01653 expected when you setup SLOB with 100 users on a bigfile TS?
    Bigfile TS max size=db block size * total # of blocks.

    Each of the 10K row CF1 table is using 10K blocks.
    For 100 users total blocks is 1 million (10,000*100 = 1,000,000).

    My db block size is 8k.

    So bigfile max size is: 8192 * 1 mil blocks = 8 GB.

    Setup eventually fails with ORA-01653 even though TS has 20 GB free.

    • 2 kevinclosson May 30, 2014 at 9:37 am

      are you sure the ORA-01653 is happening because of the tablespace given to setup.sh for SLOB schemas and not, perhaps, UNDO? You might try setting autoextend on the bigfile TS and see how big it wants to be… but, in the end, your math is right. It should fit.

  2. 3 dmitryremizov August 31, 2015 at 10:05 pm

    Hi Kevin,

    I have a problem with setup.sh script on my Solaris 11 system:
    “Option 2 must be an integer”.

    The problem is located here:
    function is_int() {
    local s=”$1″

    if ( ! echo $s | grep -q “^-\?[0-9]*$” )
    then
    return 1
    else
    return 0
    fi
    }

    It seems because of Solaris grep limitation:

    probably it would be better to check “is_positive”?, like :

    if ( ! echo $s | grep -q “^[0-9]*$” )
    then
    return 1
    else
    return 0
    fi

    It is closer to initial intention of checking correctness of schemas numbers and works on Solaris as well 🙂

  3. 7 lnvce December 3, 2015 at 1:34 pm

    Hello. I was unsuccessful to install 2.3 release in an AIX environment. Can you provide a setup script that is more compatible?

  4. 9 Ujang Jaenudin November 9, 2016 at 4:25 pm

    Hi kevin,

    I tried change the data type of c2 or c20 to CLOB or increase varchar2 width to 3999, the slob simply couldn’t work.

    the goal is test LOB behavior and grab IO characteristic.

    any thought?

      • 11 Ujang Jaenudin November 10, 2016 at 4:08 pm

        Ah, sorry now just completed LOB IO testing with modified script.
        The modified files are setup.sh, slob,sql.

        setup.sh:
        – On CREATE TABLE cf1
        – PROCEDURE slobupdat.

        slob.sql:
        On select count(dbms_lob.substr(c2,1,524288)) INTO v_rowcnt

        I tested 512KB for every LOB and used dbms_random.string(‘A’,524288) to fillup the LOB.

        Do you have any suggestion?

  5. 12 sachinperfdba May 26, 2017 at 2:30 pm

    hi Kevin,
    I dont have privileges to create user1 in the DB where i want to run the tests. How can i run by creating the objects under the schema which i have and without the need of user1 or any other user. i can create & drop objects , gather stats etc.

    Regds

    • 13 kevinclosson May 30, 2017 at 9:01 am

      You have to be able to create users for SLOB. There is no way around it.

      • 14 sachinperfdba May 30, 2017 at 9:58 am

        Ohk, thats sad. Because in our organisation we dont have those privileges . i was very keen to use this nice tool in different application DBs PROD and Performance LAB DBs.
        Thank you!

        • 15 fastequalstrue May 31, 2017 at 11:06 am

          Hi there, just thought I’d pitch in here. If you don’t have privs to create a user, you probably don’t have the authority to run huge amounts of IO through whichever database you were hoping to test on. What specifically were you hoping to achieve with SLOB on your production database?

          Chris

          • 16 fastequalstrue May 31, 2017 at 11:07 am

            My comment sounded quite snarky, and I didn’t intend that, it’s just that SLOB is a great tool, but if you’re not careful you could cause yourself a lot of trouble 🙂

          • 18 sachinperfdba May 31, 2017 at 1:09 pm

            No. i do have the privilege to create objects under my user and run any queries , even in production. But i am supposed to tune other people queries so i wont run a bad one in production 😉 . Basically i am trying to use it as a benchmarking tool. Actually i heard (on twitter) lot about people using it , so wanted to learn myself as well.

            • 19 fastequalstrue June 1, 2017 at 2:57 am

              OK. So SLOB is not a database bench marking tool. It is a tool for generating IO via a database to test the IO performance. At the core you can use it to test physical I/O performance, or you can use it to test logical I/O performance. If you just want to learn how SLOB works, set up a test database and load a small amount of data into it, and then play with the settings to see how it works.

  6. 20 suowwisq July 27, 2017 at 9:44 am

    Error with 2.4.2 on 11.2 — setup.sh errors using :
    1. f_check_mto: Logic error 1. — there’s no CDB to query
    (setup.sh continues)
    2. f_gather_stats: Failed to gather stats on user1 schema — ORA-20000

    (not sure where to leave a possible bug comment…)
    – brad


  1. 1 SLOB 2 — A Significant Update. Links Are Here. | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on May 15, 2014 at 12:03 pm
  2. 2 Oracle Meetup | Oracle Scratchpad Trackback on July 3, 2014 at 1:23 am
  3. 3 Interesting SLOB Use Cases – Part I. Studying ZFS Fragmentation. Introducing Bart Sjerps. | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on July 17, 2014 at 9:35 am
  4. 4 When Storage is REALLY Fast Even Zero-Second Wait Events are Top 5. Disk File Operations I/O: The Mystery Wait Event. | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on July 18, 2014 at 8:37 am
  5. 5 New section: Oracle SLOB Testing | flashdba Trackback on July 18, 2014 at 9:13 am
  6. 6 Oracle Database 12c Release 12.1.0.2 – My First Observations. Licensed Features Usage Concerns – Part I. | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on July 24, 2014 at 1:12 am
  7. 7 Oracle Database 12c Release 12.1.0.2 – My First Observations. Licensed Features Usage Concerns – Part II. | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on July 25, 2014 at 2:02 pm
  8. 8 Oracle ASM vs ZFS on XtremIO | Dirty Cache Trackback on August 11, 2014 at 12:37 am
  9. 9 How Do I Know I Have The Latest SLOB Kit? | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on December 11, 2014 at 4:26 pm
  10. 10 Announcing SLOB 2.2 : Think Time and Limited-Scope User-Data Modification | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on December 11, 2014 at 4:41 pm
  11. 11 SLOB Data Loading Case Studies – Part II. SLOB 2.2 For High-Bandwidth Data Loading. | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on December 15, 2014 at 11:44 pm
  12. 12 SLOB 2.2 Not Generating AWR reports? Testing Large User Counts With Think Time? Think Processes and SLOB_DEBUG. | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on December 16, 2014 at 4:30 pm
  13. 13 Measure the impact of remote versus local NUMA node access thanks to processor_group_name | bdt's oracle blog Trackback on January 7, 2015 at 6:51 am
  14. 14 cpu binding (processor_group_name) vs Instance caging comparison during LIO pressure | bdt's oracle blog Trackback on January 15, 2015 at 1:47 pm
  15. 15 Modify on the fly the cgroup properties linked to the processor_group_name parameter | bdt's oracle blog Trackback on January 19, 2015 at 9:11 am
  16. 16 SLOB Patch. AWR Post-Processing Script (awr_info.sh) Fix. | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on January 20, 2015 at 5:58 pm
  17. 17 Introducing SLOB – The Silly Little Oracle Benchmark | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on January 31, 2015 at 8:39 am
  18. 18 Scrutinizing Exadata X5 Datasheet IOPS Claims…and Correcting Mistakes | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on February 2, 2015 at 6:37 pm
  19. 19 SLOB LIO against Oracle on AIX different page sizes | Luís Marques Trackback on April 3, 2015 at 12:51 am
  20. 20 The Great Hypervisor Bake-off: VMware ESX vs Oracle VM | flashdba Trackback on May 7, 2015 at 9:23 am
  21. 21 Announcing SLOB 2.3. Tarry Not, Get It While It’s Hot! | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on July 12, 2015 at 10:48 am
  22. 22 Oracle 12 and latches | Frits Hoogland Weblog Trackback on July 17, 2015 at 5:39 am
  23. 23 Announcing “SLOB Recipes” | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on July 17, 2015 at 9:28 am
  24. 24 Hyper-threading: measure its impact during SLOB runs thanks to numactl and turbostat | bdt's oracle blog Trackback on September 24, 2015 at 9:29 am
  25. 25 Plotting SLOB results in high resolution – Oracle Diagnostician Trackback on February 22, 2016 at 11:38 am
  26. 26 Performance Data Visualization for SLOB. The SLOB Expert Community is Vibrant! | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on February 22, 2016 at 12:58 pm
  27. 27 ORION - SLOB implementation comparison Trackback on April 1, 2016 at 3:17 am
  28. 28 Yes, You Must Use CALIBRATE_IO. No, You Mustn’t Use It To Test Storage Performance. | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on June 2, 2016 at 10:09 pm
  29. 29 You Scratch Your Head And Ponder Why It Is You Go With Maximum Core Count Xeons. I Can’t Explain That, But This Might Help. | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on June 13, 2016 at 10:36 pm
  30. 30 How to Perform Backend Testing Trackback on July 4, 2016 at 3:01 am
  31. 31 How to Perform database(Backend) Testing – Learn Yourself Trackback on September 12, 2016 at 2:03 am
  32. 32 Oracle 12c OLTP & DSS workloads on Virtual SAN 6.2 All Flash - Virtualize Business Critical Applications - VMware Blogs Trackback on September 22, 2016 at 4:03 pm
  33. 33 SLOB Use Cases By Industry Vendors. Learn SLOB, Speak The Experts’ Language. | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on February 10, 2017 at 2:46 pm
  34. 34 Kevin Closson discusses SLOB Server CPU I/O Database Performance benchmarks - StorageIOblog Trackback on March 3, 2017 at 4:21 pm
  35. 35 EMC Unity Storage Performance testing with Oracle ASM and SLOB | the gruffdba Trackback on March 6, 2017 at 4:39 pm
  36. 36 Podcast with Kevin Closson discussing SLOB (Silly Little Oracle Benchmark), Database and CPU Server I/O topics - The Data Center Journal Trackback on April 13, 2017 at 6:07 am
  37. 37 Announcing SLOB 2.4! Integrated Short Scans and Cloud (DBaaS) Support, and More. | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on May 9, 2017 at 11:59 pm
  38. 38 Oracle DBA Career Advice for the Bewildered | Smart Database Replication Trackback on May 14, 2017 at 5:17 pm
  39. 39 Oracle 12.2 full database encryption (TDE) | Spot on Oracle Trackback on May 17, 2017 at 6:04 am
  40. 40 Installing & Testing SLOB – imaginaryit Trackback on June 11, 2017 at 9:48 am
  41. 41 Little Things Doth Crabby Make. Part XX – Man Pages Matter! Um, Still. | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on July 12, 2017 at 5:30 pm
  42. 42 Step-By-Step SLOB Installation and Quick Test Guide for Amazon RDS for Oracle. | Kevin Closson's Blog: Platforms, Databases and Storage Trackback on July 25, 2017 at 4:21 pm

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




DISCLAIMER

I work for Amazon Web Services. The opinions I share in this blog are my own. I'm *not* communicating as a spokesperson for Amazon. In other words, I work at Amazon, but this is my own opinion.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,988 other followers

Oracle ACE Program Status

Click It

website metrics

Fond Memories

Copyright

All content is © Kevin Closson and "Kevin Closson's Blog: Platforms, Databases, and Storage", 2006-2015. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Kevin Closson and Kevin Closson's Blog: Platforms, Databases, and Storage with appropriate and specific direction to the original content.

%d bloggers like this: