This is just a quick blog entry to show the very simple init.ora parameter file I use to stress simple read IOPS testing with SLOB. On 2s16c32t E5-2600 servers attached to very fast storage this init.ora parameter delivers on the order of 275,000 physical IOPS with 64 SLOB sessions.
I’ll post an init.ora that I use for the REDO model and DBWR testing as soon as possible.
Thanks to Yury for the recommended hidden init.ora parameters to boost the ratio of db file sequential reads.
Additional information can be found here: README file.
Here is the init.ora:
db_create_file_dest = '/mnt/dsk/slob' control_files=('/mnt/dsk/slob/cntlSLOB.dbf') db_name = SLOB compatible = 126.96.36.199 UNDO_MANAGEMENT=AUTO db_block_size = 8192 db_files = 20000 processes = 500 shared_pool_size = 5000M db_cache_size=10M filesystemio_options=setall parallel_max_servers=0 _db_block_prefetch_limit=0 _db_block_prefetch_quota=0 _db_file_noncontig_mblock_read_count=0 log_buffer=134217728 cpu_count=1 pga_aggregate_target=8G
Filed under: oracle