Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 8.1.7 unpredictable extreme slow exports on NT
Your export needs a read-consistent view on the data, try to find active
session with uncommitted transactions (these can be ghost connections) ...
or running batch jobs (maybe these run longer on some days - causing an
overlap with your export ?)
Can you do this export right after you bounce the database (fe. for backup) ?? Then there should be no other sessions/transactions disturbing you ...
Success !!
Ludo.
<76434.1353_at_compuserve.com> wrote in message
news:3d2723b9.10031294_at_news.hccnet.nl...
> The situation is like this:
>
> We have installed several Oracle databases on different location and
> and hardware. IBM / Compaq
> I read a lot about export problems performance problems on the net but
> not mine.
> What is the case: Normally the exports performed well dumps of 700 MB
> in 4 minutes but sometimes the exports slow down and the same quantity
> of data takes 1.5 hours. After a few days the export performes
> suddenly normal again (4 minutes)
> We do have this on every location and it is totally inpredictable when
> it happens. It has nothing to do with daily operations because
> everyday is the same and there are no end of months issues.
> A shutdown and reboot does not make any diffrence.
> Does anyone has an idea what the problem is?
>
> The problem is the unpredictable slow exports and the reason why?
> Friendly regards,
>
> Ton
>
Received on Sun Jul 07 2002 - 10:58:19 CDT