Path: news.easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!skynet.be!skynet.be!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mail From: "Van Helleputte LUDO" Newsgroups: comp.databases.oracle.server References: <3d2723b9.10031294@news.hccnet.nl> Subject: Re: 8.1.7 unpredictable extreme slow exports on NT Lines: 37 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1050 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1050 Message-ID: Date: Sun, 07 Jul 2002 15:58:19 GMT NNTP-Posting-Host: 213.118.39.252 X-Complaints-To: abuse@telenet.be X-Trace: afrodite.telenet-ops.be 1026057499 213.118.39.252 (Sun, 07 Jul 2002 17:58:19 MET DST) NNTP-Posting-Date: Sun, 07 Jul 2002 17:58:19 MET DST Organization: Telenet Internet Xref: easynews comp.databases.oracle.server:153309 X-Received-Date: Sun, 07 Jul 2002 08:55:34 MST (news.easynews.com) 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@compuserve.com> wrote in message news:3d2723b9.10031294@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 >