Online Mind Mapping and Brainstorming

Create your own awesome maps

Online Mind Mapping and Brainstorming

Even on the go

with our free apps for iPhone, iPad and Android

Get Started

Already have an account? Log In

SLOB by Mind Map: SLOB
0.0 stars - reviews range from 0 to 5

SLOB

Test Models

Physical Read Performance

Use a small db_cache_size

In 11.2.0.3 use specific parameters, alter system set "_db_block_prefetch_limit"=0, alter system set "_db_block_prefetch_quota"=0, alter system set "_db_file_noncontig_mblock_read_count"=0, alter system set compatible="11.2.0.2"

Should see db file sequential read as top wait event

Redo Generation Performance

Use large redo logs

Use a large db_cache_size

alter system set log_checkpoint_timeout=99999999

Physical Write Performance

Use small redo logs

Use a small db_cache_size, With small db_cache_size, don't need to include readers, will have physical reads

Logical I/O Performance

use a big db_cache_size (bigger than tables used)

avoid any auto memory management

Analysis Tools

awr_info.sh

Included in SLOB distribution

Summarizes multiple AWR reports

SLOB.R, Download, http://wp.me/p2Jp2m-4i, Interrogates awr_info.sh output in R, Requires R Statistical Environment, Download, http://cran.r-project.org/

Download

http://oaktable.net/articles/slob-silly-little-oracle-benchmark

General Setup

Eliminate other activity on database server

Disable automatic AWR snapshots

alter system set resource_manager_plan=''

Disable parallel unless testing parallel performance

alter system set parallel_max_servers=0

alter system set cpu_count=1

Switch logfiles (N*2+1) times before each run

N = number of redo logs

Do a throwaway SLOB run after a bounce to prime the database

Save awr.txt output after each run for further analysis

Scripts to automate multiple SLOB runs and save awr.txt

http://wp.me/p2Jp2m-29

Try misc/create_database_kit/ in SLOB to build a testing DB

Isolate UNDO blocks from table/index (chains) for write/REDO model by setting db_recycle_cache_size=N

Resources

Introducing SLOB: http://kevinclosson.wordpress.com/2012/02/06/introducing-slob-the-silly-little-oracle-benchmark/

Collected links/tips/tools: http://wp.me/p2Jp2m-3n

Yury Velikanov's SLOB index: http://www.pythian.com/blog/my-slob-io-testing-index/

SLOB LinkedIn Group: http://t.co/6O4ynhjB

Karl Arao's TiddlyWiki: http://karlarao.tiddlyspot.com/#[[cpu%20-%20SillyLittleBenchmark%20-%20SLOB]]

Uses

Benchmark one storage unit vs another

Compare performance of various filesystems

Don't mix LUNs; use same LUN for each FS

Identify max throughput possible from your setup

Non-SLOB tools

hammerora

ORION

swingbench

Other Considerations

Distributing your SLOB results/AWRs may be a legal issue with Oracle Corp

Scale data against a baseline?