Some clients ask me why we need pay money for AWR if with statspack we have performance reports, answer is yes, we can access almost everything we need with statspack with no need pay extra license money.
Want audit Oracle configuration fast, oracle long time ago create a rac database healtcheck called RACchk. The old RACchk, Oracle decided to extend the utility beyond rac, this software is a oracle scanning tool that look for configuration problems, and return a report showing health risk based on oracle best practices.
Finaly we have easy oracle tool to do the job of testing IO performance, very easy to use. ORION (ORcle IO Numbers) mimics the type of I/O performed by Oracle databases, which allows you to measure I/O performance for storage systems without actually installing Oracle. It used to be available to download for a number of platforms from OTN, but since 126.96.36.199 is included in the “$ORACLE_HOME/bin” directory of Grid Infrastructure (GI) and database installations, download is no longer available.
We have new faster machine and need a performance test, we can write our scripts/querys that do the measure job,
and measure performance with a 3rd party monitor tool (nagios,zabbix,etc..), but here comes HammerDB for save our
time and do the benchmark. Want to measure only storage performance with out oracle? better use IOmeter.