Oracle and linux I/O schedulers (part 1)

Jul
07
Oracle and linux I/O Scheduler
Part 1

Following the paper on the block size I decided to write something more on the Linux I/O schedulers and their interaction with oracle.

This paper involves a series of tests stressing oracle with a TPC-C workload while the oracle DB rely on different linux schedulers.

Posted By Fabrizio Magni read more

Heretical: Oracle blocksize on Linux

Jul
07
Heretical: Oracle Blocksize on Linux

I know that by posting this I'm risking public mockery but I believe that one of the common rules about chosing the DB block size is sort of an oracle myth.

In particolar it is common practice to choose a DB block size identical to the filesystem block size when not using direct i/o.

Posted By Fabrizio Magni read more

Pages

Subscribe to RSS - oracle