Category Archives: tuning

Differences between STATSPACK and AWR

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.

Continue reading

Advertisements

Health Check tool: ORAchk

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.

Continue reading

Storage Benchmark with Oracle ORION

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 11.2.0.1 is included in the “$ORACLE_HOME/bin” directory of Grid Infrastructure (GI) and database installations, download is no longer available.

Continue reading

Benchmark Oracle database to the end with HammerDB

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.

Continue reading

StatsPack Fast Guide

We have a performance issue in database, and this database not have AWR license? no problem statspack is free and comes standard. Can create a report for example of 10-15 minutes in peek time for example what is waiting for dataase in this time, heavy querys,etc.

Continue reading