SLOB initialisation parameter file for PIO Testing

This page is found from here – so follow the link if you stumble across it and wonder what it’s all about.

This is the SLOB.CONF I use for PIO testing with the following configuration:

  • Oracle 11.2.0.4 RAC or single-instance
  • A 2 TB IOPS tablespace
  • SLOB configured with 256 users
UPDATE_PCT=30
RUN_TIME=120
WORK_LOOP=0
SCALE=1048576
WORK_UNIT=3
REDO_STRESS=LITE
LOAD_PARALLEL_DEGREE=40

THREADS_PER_SCHEMA=1

# Settings for SQL*Net connectivity:
#ADMIN_SQLNET_SERVICE=orcl
#SQLNET_SERVICE_BASE=orcl
#SQLNET_SERVICE_MAX=2
#SYSDBA_PASSWD=oracle

This is the parameter file I use for single-instance SLOB PIO testing on Oracle 11.2.0.4:

*._db_block_prefetch_limit=0
*._db_block_prefetch_quota=0
*._db_file_noncontig_mblock_read_count=0
*._disk_sector_size_override=TRUE
*.compatible=11.2.0.4
*.control_files='XXXXX'
*.db_block_size=8192
*.db_cache_size=256M
*.db_create_file_dest='+DATA'
*.db_name='orcl'
*.db_files=2000
*.db_writer_processes=16
*.diagnostic_dest='/u01/app/oracle'
*.filesystemio_options='setall'
*.log_buffer=134217728
*.parallel_max_servers=0
*.pga_aggregate_target=10G
*.processes=1024
*.recyclebin=OFF
*.resource_manager_plan=''
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=4G
*.undo_tablespace='UNDOTBS1'

This is the file I use for two-node RAC SLOB PIO testing on Oracle 11.2.0.4:

*._db_block_prefetch_limit=0
*._db_block_prefetch_quota=0
*._db_file_noncontig_mblock_read_count=0
*._disk_sector_size_override=TRUE
*.compatible=11.2.0.4
*.control_files='XXXXX'
*.db_block_size=8192
*.db_cache_size=1G
*.db_create_file_dest='+DATA'
*.db_name='orcl'
*.db_files=2000
*.db_writer_processes=16
*.diagnostic_dest='/u01/app/oracle'
*.filesystemio_options='setall'
orcl1.instance_number=1
orcl2.instance_number=2
*.log_buffer=134217728
*.parallel_max_servers=0
*.pga_aggregate_target=10G
*.processes=1024
*.recyclebin=OFF
*.resource_manager_plan=''
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=4G
orcl2.thread=2
orcl1.thread=1
orcl1.undo_tablespace='UNDOTBS1'
orcl2.undo_tablespace='UNDOTBS2'