Re: oracle db performance issue

Yes, you might want to separate reporting with your transactional activity.

Try start in simple way if data latency in reports of 1 day is not a problem for you: extract your data into flat files and load it to reporting database with sqlldr.

You can use third party tool fastreader for this: www.wisdomforce.com

Fastreader very quickly export data from large production Oracle tables with no system overhead. At same time it creates loaders for sqlldr. The process of unload / load can be automatic on nightly basis.

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
Received on Sun Feb 06 2005 - 00:36:43 CST