- This event has passed.
How to Tune and Benchmark Oracle Database with AWR Reports and HammerDB
September 15, 2021 @ 1:00 pm - 2:00 pm EDT
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.
Basic Oracle DBA Skills.
John Watson, Oracle Certified Master DBA, SkillBuilders Director of All Things Oracle Database
Dave Anderson, SkillBuilders’ Founder, Oracle Database Technologist
Barring any technical glitches, all webinars are recorded and posted as tutorials. See all tutorials HERE
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.
All dates are in Eastern Time (ET).