getting different results between Oracle ORION and BMF
BMF is a load generation tool which tests the entire database system by submitting SQL to the database server using multiple simulated users to stress the database system.
Orion is a tool for predicting the performance of an Oracle database without having to install Oracle or create a database. Unlike other I/O calibration tools, Oracle Orion is expressly designed for simulating Oracle database I/O workloads using the same I/O software stack as Oracle. Oracle ORION tool, but from what we are seeing on the internet it simulates IO on the storage system without having an Oracle database installed; http://www.oracle-base.com/articles/misc/MeasuringStoragePerformanceForOracleSystems.php
Where as BMF tests the entire database system (databaser server including hardware and software, network, storage system, etc.) So you can't really compare the two results. Also the AS3AP is a VERY generic benchmark which, by default, has a very lightweight mix test (single record read). Not a typical workload to measure performance. If you are trying to put a load on your I/O system you need to use the appropriate workload. I would recommend the TPC-H since it is a data warehouse workload.
Please verify if during the sample schema creation BMF created indexes. In the "Run Job" screen you might see error: "Create Views failed" and you can recreate view manually. After indexes are created it should produce results that are logically comparable to Oracle Orion, but no garantee since they work different way.
