While Oracle Database 11gR2 provides some excellent tools to drill down to the potential root causes of poor I/O performance, generating a standard, consistent, and repeatable I/O workload is crucial for fair comparisons. This article discusses which Transaction Processing Council (TPC) sample schema(s) are available, and which one(s) are most appropriate for evaluation of a database systemís underlying input/output (I/O) subsystem.


This story continues at
http://www.dbasupport.com/oracle/ora...orkloads.shtml