Start looking at the wait statistics for the session that's doing the
export.
either
A:it's slow to read from Oracle or
b: it's slow to write to the export dump.
checking b is fairly simple - write a 10 line C program to dump 700MB of
random data to the same place and check the run time. if it's slow then
Oracle isn't the problem
- solve by looking at waitstats - why is it waiting - IO ? cpu ? and so
on
<Ton.van.Veenendaal_at_hccnet.nl> wrote in message
news:3d2896cf.3082702_at_news.hccnet.nl...
> 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
> >
>
Received on Mon Jul 08 2002 - 10:00:26 CDT
