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:
Kevin Closson's Blog: Platforms, Databases and Storage 
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 !
What version of SLOB?