Database Tuning (MOSC)

MOSC Banner

undo tuning in a multi-purpose database

edited Feb 10, 2010 3:01AM in Database Tuning (MOSC) 4 commentsAnswered ✓
 I have inherited the administration of a 10.2.0.4 database that has 2 different purposes.  One set of applications/tables run about 90,000 small transactions per hour into the database, which are then purged back out on a 3 hour rolling window.  The other set of applications/tables operate as a data warehouse, where large files are loaded in via batch processing, and reports/data analysis are run on daily/weekly/monthly/yearly periodic basis.

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center