Creating Realistic Environments
Oracle DBAs not only have to manage production database environments, but also ensure proper development, testing, and data mining (reporting) environments. This is not a very simple task; the DBA has to consider several issues:
The data set used for development and testing should reflect what will be in the real world (production) environment so that performance, accuracy, and other factors can be properly tested.
Most e-business applications are still relatively new, and predicting application usage is not easy. This makes it difficult to create a realistic application-usage scenario for developers and testers.
It's important to perform load testing by generating a large volume of concurrent connections through the web. This simulation should not only include large volumes but should also have some realistic degree of randomness in application usage, as this will ensure that a more realistic workload pattern is tested.