Running EBS on Cloud? Beware of this overlooked performance metric
Event: Connect 2021
Stream: Architecture, Cloud Database & Technology
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.