Events

Database systems running on modern hardware are no longer constrained by I/O or memory shortage as both of these historic performance bottlenecks have been addressed by hardware technology advancements. The biggest constraint to system performance can now be found in a little-noticed space: the single thread CPU Speed. CPU speed is often overlooked when considering Cloud infrastructure providers, and it can be the difference between a successful “lift and shift” or a migration that moves the company backward from a user experience with system performance.

We will show a performance comparison of different cloud and on-premises systems, such as OCI, AWS, or Oracle Exadata, and demonstrate the differences running Oracle EBS SQL queries on them.

Objectives:

• Learn about the impact of single thread CPU speed on database query performance.
• Learn how to audit database performance and gather the metrics that pinpoint the problems.
• Introduce attendees to a public domain SQL library that can help to analyze Oracle EBS performance.

Attendees will gain personal and professional growth by learning about performance monitoring, and will get access to a library of SQL scripts that can help their business users work more efficiently with EBS on a day-to-day basis.