Enterprise Manager and Real Application Testing help CSX Corporation upgrade databases twice as fast

With more than 400 databases supporting critical, packaged and proprietary business applications, including payroll, dispatch and a customer-facing order entry system, international transportation company CSX wanted to take advantage of the enhanced functionality of Oracle Database while minimizing business impact. and downtime during migration. To ensure the process went smoothly, CSX used Oracle Real Application Testing and Enterprise Manager.

Using Oracle Real Application Testing helped CSX streamline the upgrade process and enabled it to complete the database upgrade in less than half the time required for the previous upgrade. the enterprise database which meant a 30% smaller database footprint. Providing critical insights, Oracle Real Application Testing allowed CSX to fully assess the impact of infrastructure changes and refine queries in a test environment before deploying the change to production.

CSX also used Oracle Enterprise Manager to analyze performance data from Oracle Real Application Testing’s SQL Performance Analyzer to assess the impact of prepackaged and custom SQL workloads during upgrades of the Oracle database in its Oracle E-Business Suite environment. By capturing SQL workloads for different peak periods into SQL tuning sets, CSX was able to create a comprehensive library of SQL queries that can be used for change validation.

“Oracle Enterprise Manager and Oracle Real Application Testing provided us with the necessary testing environment that allowed us to mitigate post-upgrade performance issues and ensure a successful upgrade of 400 databases. The fact that the upgrade was completed with no downtime and in half the time of our last upgrade was a critical win for our organization,” said Maritza Gonzalez, Technical Director, Data Management, CSX Corporation.

Additionally, CSX implemented Oracle Enterprise Manager 12c to monitor and manage a combination of over 500 Oracle databases and Oracle Real Application Cluster instances. Oracle Enterprise Manager provides centralized, standardized, and reliable monitoring, which has enabled CSX to manage the growth in the number of servers and databases.