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

Redo Generation Performance

Physical Write Performance

Logical I/O Performance

Analysis Tools

awr_info.sh

Download

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

General Setup

Eliminate other activity on database server

Disable parallel unless testing parallel performance

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

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

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

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