Path: news.easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer00.lnd.ops.eu.uu.net!bnewspeer01.bru.ops.eu.uu.net!emea.uu.net!news.hccnet.nl!not-for-mail
From: Ton.van.Veenendaal@hccnet.nl
Newsgroups: comp.databases.oracle.server
Subject: Re: 8.1.7 unpredictable extreme slow exports on NT
Date: Sun, 07 Jul 2002 19:37:46 GMT
Organization: Hobby Computer Club News Network
Lines: 18
Message-ID: <3d2896cf.3082702@news.hccnet.nl>
References: <3d2723b9.10031294@news.hccnet.nl>
NNTP-Posting-Host: fia99-10.dsl.hccnet.nl
X-Trace: news.hccnet.nl 1026070515 26174 62.251.10.99 (7 Jul 2002 19:35:15 GMT)
X-Complaints-To: abuse@hccnet.nl
NNTP-Posting-Date: Sun, 7 Jul 2002 19:35:15 +0000 (UTC)
X-Newsreader: Forte Free Agent 1.21/32.243
Xref: easynews comp.databases.oracle.server:153320
X-Received-Date: Sun, 07 Jul 2002 12:41:29 MST (news.easynews.com)

Ludo & Svend thanks for u response.

Ludo, the exports are slow for days. We do exports two times a day
12.30 pm when the users are connected and 9.00 pm no users are
connected. Besides that every night the database will shutdown. As i
said a reboot also does not make a difference. But after a few days
suddenly as nothing has happened the exports are fast again. 
fast = 4 minutes, slow = 1.5 hour for the same data 

Svend, the analyze is done every day in the morning. But it does not
make any diffirence. Even if I do an export short after  shutdown -
reboot - startup the exports are still slow. It makes no diffrence if
the tables have many records or none they are both slow. 
friendly regards,

	Ton 
>

