Re: oracle db performance issue

nigist wrote:

> We are having issue with the oracle db. we have production db and is
> used by about 700 site and also we do a lot of reporting out of the
> same db, and I was wondering what will be the best way to handle this
> so that we will not be hitting the same db at the same time which makes
> the performance very slow. Is it possible to have a duplicate or copy
> of production db where we can use it only for reporting purpose and
> update the copy on a nightly bases or is there a better way of handling
> this situation?
>
> Thank you for your help

Explore various forms of replication from Advanced Replication, not my favorite to DataGuard, the one I prefer.

But how much work has actually been done tuning the production db. It might be more than capable of handling the load if properly tuned.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)