Large oracle redo logs generated by performance warehouse
We have hooked our production jboss JVMs to the dynatrace collector and we are receiving data fine. The issue is that the server is writing changes so frequently to our Oracle database we are generating very large redo logs. Is there a way to reduce the frequency of the writes to bring the redo log size down?
Thanks
Hello David,
there is no way to reduce/configure the frequency of the writes. The write load is basically defined by the number of measures, measurements etc. You can get a good indication for that via the built-in PWH Write Monitoring Dashboard using pre-selected self-monitoring measures.
A few additional notes:
- It would be interesting to get some rough numbers on the number of measures, measurements written, number of records in the various MEASUREMENT_* tables
- Perhaps you can generate an AWR/AHS report for a time-frame of at least 24 hours to also capture activities of the aging task, by default running once a day at 2am in the night
- Then it would be also interesting to investigate which segments and/or SQLs are generating the most redo log workload. A good resource for fiddling around in that area is: http://damir-vadas.blogspot.co.at/2011/02/how-to-redo-logs-generation.html
Hope this helps.
Thomas
