Use the Consolidated Database Replay function of Oracle Real Application Testing in Oracle Database 12c to gauge the impact of consolidating workloads.
In the course of database consolidation, one of the big challenges for Acme Bank and its IT management was to predict the impact of workloads from several databases running simultaneously on one database. Using the Consolidated Database Replay feature of Oracle Real Application Testing, the DBA Lead showed how the application manager can accurately measure that impact. The consolidated replay testing techniques demonstrated can be used for all types of consolidation scenarios: relocating various databases into a single database as different schemas, creating various databases as pluggable databases in a multitenant container database under Oracle Database 12c’s multitenant architecture, creating separate databases in different virtual machines, or any combination of these techniques. The goal in any case is the same: accurate prediction of the impact of consolidation. And the Consolidated Database Replay feature of Oracle Real Application Testing enables exactly that. (Consolidated replay is also available in the Oracle Enterprise Manager Cloud Control 12c interface.)
Read full article here. By Arup Nanda, Oracle ACE Director