undo tuning in a multi-purpose database
I think one of our main tuning issues is that undo wants to tune a large space because of the many small transactions that occur while the larger reports/queries are run. My question is - are there reasonable things to do with tuning to get these 2 applications to live together? Or should i just spin the small transaction based application into it's own instance, and then tune each instance separately to optimize based on its activity?