Kevin Closson's Blog: Platforms, Databases and Storage

Home | Pages | Archives

SLOB 2.2 Not Generating AWR reports? Testing Large User Counts With Think Time? Think Processes and SLOB_DEBUG.

December 16, 2014 4:30 pm

I’ve gotten a lot of reports of folks branching out into SLOB 2.2 large user count testing with the SLOB 2.2 Think Time feature. I’m also getting reports that some of the same folks are not getting the resultant AWR reports one expects from a SLOB test.

If you are not getting your AWR reports there is the old issue I blogged about here (click here). That old issue was related to a Redhat bug.  However, if you have addressed that problem, and still are not getting your AWR reports from large user count testing, it might be something as simple as the processes initialization parameter. After all, most folks have been accustomed to generating massive amounts of physical I/O with SLOB at low session counts.

I’ve made a few changes to runit.sh that will help future folks should they fall prey to the simple processes initialization parameter folly. The fixes will go into SLOB 2.2.1.3. The following is a screen shot of these fixes and what one should expect to see in such situation in the future. In the meantime, do take note of SLOB_DEBUG as mentioned in the screenshot:

 

slob2.2-processes-folly

Share this:

Posted by kevinclosson

Categories: oracle

Tags:

2 Responses to “SLOB 2.2 Not Generating AWR reports? Testing Large User Counts With Think Time? Think Processes and SLOB_DEBUG.”

  1. Hello, i am trying to do IO benchmarking for a database for though i have set the DATABASE_STATISTICS_TYPE=awr
    the AWR report is not been generated the script is looking for a snap_id 26 but snap_id 26 is not been generated by the database yet

    Listing the last day’s Completed Snapshots

    Instance     DB Name   Snap Id Snap Started Snap Level

    ———— ———— ———- —————— ———-

    db5     DB5   1  20 May 2025 13:45   1

      2  20 May 2025 15:00   1

      3  20 May 2025 16:00   1

      4  20 May 2025 17:00   1

      5  20 May 2025 17:44   1

      6  20 May 2025 17:49   1

      7  20 May 2025 17:56   1

      8  20 May 2025 18:01   1

      9  20 May 2025 18:12   1

    10  20 May 2025 18:17   1

    11  20 May 2025 18:19   1

    12  20 May 2025 18:24   1

    13  20 May 2025 18:55   1

    14  20 May 2025 19:00   1

    15  20 May 2025 19:09   1

    16  20 May 2025 19:09   1

    Specify the Begin and End Snapshot Ids

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    Begin Snapshot Id specified: 26

    End   Snapshot Id specified: 26

    declare

    *

    ERROR at line 1:

    ORA-20200: Begin Snapshot Id 26 does not exist for this database/instance

    ORA-06512: at line 23

    Disconnected from Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 – Production

    Version 19.27.0.0.0

    NOTIFY  : 2025.05.20-19:09:08 : Cannot compress file “awr.html”.

    NOTIFY  : 2025.05.20-19:09:08 : Cannot compress file “awr_rac.html”.

    NOTIFY  : 2025.05.20-19:09:08 : No such file.

    NOTIFY  : 2025.05.20-19:09:08 : No such file.

    [oracle@db5 SLOB]$ 

    Can you guys please help here this is urgent !

    By Amey Bobade on May 20, 2025 at 12:23 pm

  2. What version of SLOB?

    By kevinclosson on May 20, 2025 at 12:27 pm

Leave a Reply

You must be logged in to post a comment.

Mobile Site | Full Site

Get a free blog at WordPress.com Theme: WordPress Mobile Edition by Alex King.