How to configure OLTP with reporting queries
Posted by Alisher Yuldashev on Oct 5, 2009
If you have an extremely busy OLTP system with a physical standby ready for a manual role transition, and you want to run very heavy reporting queries without affecting the system, consider using a separate report database with downstream capture configuration. Yes, it is very easy to configure, and it will have no performance impact on the OLTP system whatsoever.
In this blog, I will show how to do this, and how to maintain the archivelog transportation during a manual switchover.
Below is the configuration of the three databases I have for testing:
Read the rest of this entry . . .
