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

Where To Get The Latest SLOB Kit

SLOB 2.3: Click Here.  (md5sum of the gzipped tar archive is 740fe4a531a04b1416ccb426e2049754).

SLOB 2.3 Documentation: Click Here.

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 Randomess.  Click the following link: About I/O Randomness.
  4. SLOB Failing To Generate AWR Reports? Red Hat Bug 919793! Click this link.

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

38 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?


  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

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




EMC Employee Disclaimer

The opinions and interests expressed on EMC employee blogs are the employees' own and do not necessarily represent EMC's positions, strategies or views. EMC makes no representation or warranties about employee blogs or the accuracy or reliability of such blogs. When you access employee blogs, even though they may contain the EMC logo and content regarding EMC products and services, employee blogs are independent of EMC and EMC does not control their content or operation. In addition, a link to a blog does not mean that EMC endorses that blog or has responsibility for its content or use.

This disclaimer was put into place on March 23, 2011.

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

Join 2,733 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.

Follow

Get every new post delivered to your Inbox.

Join 2,733 other followers

%d bloggers like this: