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.
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.