I am running a Oracle TPC-C test using Quest Benchmark factory software. I am using Oracle 11g R2 RAC database and the database is on an iSCSI storage.
I am monitoring the I/O on my storage and observing the I/O pattern as follows.
Read : 30 to 40%
Write : 70 to 60%
I was of the opinion that TPC-C load means it should simulate something like 70%Read/ 30% write I/O pattern. Can you please clarify ? This is a basic question, but my impression of TPC-C is something similar to OLTP. In OLTP, we have more reads than write. But I am seeing completely opposite to that !!!