Showing posts with label RMAN. Show all posts
Showing posts with label RMAN. Show all posts

Friday, 18 September 2015

How to setup a stress test on Oracle or equivalent databases

In a recent workshop on Oracle12c administration, I noticed that the participants had no idea how to let Oracle create archived redo logfles, i.e. they did not know how to create a relevant workload. In the exercises of the workshops you can find one, which performs some workload on CPU and I/O, but nothing about writing so much to the online redo logs, that the log writer process LGWR needs to copy the contents to the archived redo log files.
In summary, the students - all computer scientists working several years in IT companies - had never seen a stress test before. To solve the issue, I passed an old script of mine to them. To whom it may concern, I will publish it here, because it is really simple.