SLOB 2 — A Significant Update. Links Are Here.

BLOG UPDATE: 2014.05.15:  The following link supersedes all other references to SLOB kit and patches. This will always be the up-to-date locale:  https://kevinclosson.wordpress.com/slob/

BLOG UPDATE 2013.12.26:   Quick link to download the kit

BLOG UPDATE 2012.05.05: Updated the tar archive distribution file with some bug fixes.  Simply preserve your slob.conf file and extract this tar archive over your prior SLOB install directory.

BLOG UPDATE 2012.05.04: The PDF README will no longer be bundled in with the tar archive. The README can be found here:  SLOB2 README.

BLOG UPDATE 2012.05.03: First time visitors should see the introductory page for SLOB.

About SLOB 2
I’ve already socialized the SLOB 2 update via twitter and a lot of friends have had early access to the kit. So, this is just a very brief blog entry to point to SLOB 2.

I’ve written a form of a release note that will be sufficient for current SLOB users to move forward rapidly with new SLOB 2 features. The note can be found here: SLOB 2 README or here.

Download The SLOB2 Kit
To download the software you can access the tar archive on EMC Syncplicity. Click SLOB 2 Tar Archive.

After downloading you should verify the md5sum:

$ md5sum 2013.05.05.slob2.tar
e1e67a68bf253a02532ebd556a2ea782  2013.05.05.slob2.tar
$

48 Responses to “SLOB 2 — A Significant Update. Links Are Here.”


  1. 1 Noons May 2, 2013 at 10:51 pm

    hmmm….. shared file not found in that link?

  2. 2 Tim Hall May 3, 2013 at 12:33 am

    Not SLOB12c? Dissapointed…

    Cheers

    Tim… 🙂

  3. 3 connormcdonald May 11, 2013 at 12:01 am

    Not sure if I’m liking the popularity of SLOB….Popularity + Oracle normally equals acquisition….I can see the future now:

    C:\Users\connor> sqlplus abc/xyz

    SQL*Plus: Release 13.1.0.5.0 Production on Sat May 15 14:57:27 2013

    Copyright (c) 1982, 2015, Oracle. All rights reserved.

    Connected to:
    Oracle13s Enterprise Edition Release 13.1.0.5.0 – 64bit Production
    With the Partitioning and SLOB options

    and probably $50k per core as well !!

    🙂

  4. 4 mbobak December 1, 2013 at 7:05 am

    Hey Kevin,

    The syncplicity links for both the TAR archive and the README are both broken. Can you point me to some valid links?

  5. 7 shjafri786 January 13, 2014 at 11:54 am

    Hi Kevin,

    How do I run SLOB2 for a specified amount of time (say a few hours) for a specified update percentage (say 20%)? I have tried setting 3600 for “RUN_TIME” and 30 for UPDATE_PCT. The run completes in about 1800 seconds instead of specified 3600 seconds. If I kick off a subsequent run keeping RUN_TIME and UPDATE_PCT setting the same in slob.conf file, the test runs randomly end within a few seconds (sometimes 5 seconds, sometimes 8 etc.).

    Thank you.
    – Saad

  6. 14 Pascal Phillip February 19, 2014 at 7:51 am

    Hi Kevin,

    Thanks for a very useful IO testing tool.

    I tested SLOB2 and somehow the values of “bytes per second” were not extracted correctly by the script awr_info.sh – i think the problem is with the chomp command.

    In my server (el6uek.x86_64) the command ‘chomp’ does not seem to work, so ‘bytes per second’ values are zero.

    Example:

    function get_read_mbs() {
    local f=$1

    grep ‘^physical read total bytes’ $f | head -1 | chomp | awk ‘{
    printf(“%6.0lf\n”, ( $2 / 2 ^ 20) )
    }’
    }

    I changed it to:

    grep ‘^physical write total bytes’ $f | head -1 | awk ‘{print $6}’ | awk ‘{ printf(“%6.0lf\n”,$1) }’

    May be you can provide a fix for that in the next release.

    Br,

    Pascal

  7. 15 Dimitre Radoulov December 9, 2014 at 9:32 am

    Hello,
    just for your info: there’s a syntax error in misc/awr_info.sh – missing closing double quote at line 235.

  8. 20 richa0314 November 22, 2016 at 10:42 am

    Hi Kevin,
    I’d like to know how to configure & use SLOB2 to exercise the RAC interconnect [in an AIX environment].

    I know this information might be available in the LinkedIn Group “SLOB Oracle Platform Testing” (Yury Velikanov).

    I asked for permission to be able to join this group last week, however, have not heard back.

    Might you (or anyone) be able to help?

    Thanks,
    Rich

    • 21 richa0314 November 22, 2016 at 3:52 pm

      I think I’m getting somewhere with this – slob against one instance with UPDATE_PCT=0 and another instance of slob against another instance with UPDATE_PCT=100 seems to get a lot of ‘gc cr block busy’ waits from the select heavy instance; what I’d like to do is try to get ‘gc cr grant 2-way’ waits…

      • 22 kevinclosson November 22, 2016 at 5:08 pm

        Let me give this some thought. But first, I need to know if you are using a round-robin connection method (single SQL*Net server) or are you using a named service per instance?

        • 23 richa0314 December 1, 2016 at 11:24 am

          Hi Kevin,
          Sorry for the late reply – holidays.
          At first, I tried with SQLNET_SERVICE_MAX=2 (for round-robin) and UPDATE_PCT=50, however, that only got me a relatively small ‘gc current grant busy’ spike which resolves quickly on a first run (makes sense).
          So, I went to using 2 separate instances of SLOB using different SQL*Net service names – one with UPDATE_PCT=50 to the first instance and the other with UPDATE_PCT=100 to the second instance. This gets me a bigger ‘gc current block 2-way’ spike, however, it resolves quite quickly as well.
          I’ve not tried named service per instance…
          I do see a lot of ‘enq: US – contention’ in both cases – would that cause an issue?


  1. 1 ASM Preferred Read: Collect performance metrics thanks to my amsiostat utility and SLOB 2 | bdt's oracle blog Trackback on May 5, 2013 at 7:24 am
  2. 2 SLOB2: Essential for Every DBA Toolkit | flashdba Trackback on May 18, 2013 at 3:42 am
  3. 3 SLOB: PL/SQL Commit Optimization | flashdba Trackback on May 20, 2013 at 10:10 am
  4. 4 SLOB2: Testing The Effect Of Oracle Blocksize | flashdba Trackback on June 7, 2013 at 3:02 pm
  5. 5 Build your own Flex ASM 12c lab using Virtual Box | bdt's oracle blog Trackback on June 29, 2013 at 10:23 am
  6. 6 Flex ASM 12c (12.1) and Extended Rac: be careful to “unpreferred” read ! | bdt's oracle blog Trackback on July 2, 2013 at 1:40 am
  7. 7 ASM I/O Statistics Utility V2 | bdt's oracle blog Trackback on July 5, 2013 at 5:14 am
  8. 8 RAC aware SLOB2 analyze script (Flash DBA) | Oramoss Blog Trackback on July 15, 2013 at 9:03 am
  9. 9 Flex ASM 12c (12.1): be careful to “invisible” I/O ! | bdt's oracle blog Trackback on July 16, 2013 at 8:34 am
  10. 10 Pure Storage at Oracle Open World | Pure Storage Blog Trackback on October 1, 2013 at 3:36 pm
  11. 11 My new "I/O Test Virtual Machine" | Virtual to the Core Trackback on December 19, 2013 at 2:00 am
  12. 12 La mia nuova "I/O Test Virtual Machine" | Virtual to the Core Trackback on December 19, 2013 at 2:01 am
  13. 13 Benchmarking filesystem performance for Oracle using SLOB | Pardy DBA Trackback on February 27, 2014 at 9:34 am
  14. 14 Benchmarking filesystem performance for Oracle using SLOB (Part 1.5): Improved test scripts | Pardy DBA Trackback on February 27, 2014 at 9:35 am
  15. 15 Benchmarking filesystem performance for Oracle using SLOB (Part 2) – Results! | Pardy DBA Trackback on February 27, 2014 at 9:36 am
  16. 16 Collection of links, tips and tools for running SLOB | Pardy DBA Trackback on February 27, 2014 at 9:36 am
  17. 17 SLOB.R v0.6: An R script for analyzing SLOB results from repeated runs | Pardy DBA Trackback on February 27, 2014 at 9:37 am
  18. 18 » IO Testing and Benchmarking Trackback on March 20, 2014 at 8:32 am
  19. 19 SLOB Logical I/O testing: Check if your benchmark delivers the maximum | bdt's oracle blog Trackback on April 10, 2014 at 6:50 am
  20. 20 Oracle SLOB On Solaris | flashdba Trackback on April 26, 2014 at 9:57 am
  21. 21 db_io*metrics family | bdt's oracle blog Trackback on May 9, 2014 at 4:34 am
  22. 22 Free Oracle event with beer: London 3/7/2014 | jarneil Trackback on June 18, 2014 at 6:34 am
  23. 23 Log buffer space | Oracle Diagnostician Trackback on October 14, 2014 at 8:37 am
  24. 24 Log buffer space | Oracle Diagnostician's scripts and stuff Trackback on February 2, 2015 at 1:09 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




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,987 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: