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

High Level README
Base SLOB Kit (tar archive)

2014.03.19:

Patch README

SLOB Patch

2014.09.01:

Please visit the following block post to read about a patched version of awr_info.sh: Click here.

Latest patched awr_info.sh patch README

2014.09.01 awr_info.sh patch. Note md5sum for this script is: a28a38b11040bb94f08a8f817792c75c

SLOB Patch Deployment (2014.03.19)

The following screenshot shows how to deploy the base SLOB kit and apply the patch. Please note the patch extracts into your current working directory:

deploy-slob

 

Helpful Information

Once 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.
  5. SLOB awr_info.sh Script Patch. Click this link.

10 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.


  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

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,147 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-2013. 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,147 other followers

%d bloggers like this: