How to Tune and Benchmark Oracle Database with AWR Reports and HammerDB

REGISTER FOR THIS WEBINAR

How to Tune and Benchmark Oracle with AWR Reports and HammerDB

Simulate TPC-C Workloads with HammerDB

How should one use AWR reports to tune a database? How can you stress test your database configuration? Two frequently asked questions faced by many DBAs. This webinar will demonstrate one technique: using the HammerDB benchmarking and load testing tool to generate a TPC-C type workloads, and information from AWR reports to improve transaction throughput and query performance.

The HammerDB TPROC-C tool simulates typical OLTP type activity: a combination of small queries and transactions against a standard schema. Running it repeatedly as one tunes the database and instance lets you determine whether the tuning is improving performance. Running it against different databases helps with benchmarking: how your environment compares to others. By increasing the workload, it is also possible to see how the database will perform under stress.

Learn more about and download HammerDB on their website.

Prerequisite Knowledge

Basic Oracle DBA Skills.

Presenters 

John Watson, Oracle Certified Master DBA, SkillBuilders Director of All Things Oracle Database

Dave Anderson, SkillBuilders’ Founder, Oracle Database Technologist

Recording

Barring any technical glitches, all webinars are recorded and posted as tutorials. See all tutorials HERE

Registration 

By registering for the webinar, you will be placed on SkillBuilders mailing list. You will have the option to opt-out of the mailing list at any time.