Re: oracle db performance issue

Tim wrote:
> 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

However useful your product, advertising here is span, plainly and simply put. Apologise to the group and place such posts in c.d.o.marketplace, where such items belong.

David Fitzjarrell Received on Sun Feb 06 2005 - 15:12:13 CST