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
On Tue, 09 Jul 2002 21:03:49 GMT, Ton.van.Veenendaal_at_hccnet.nl
<Ton.van.Veenendaal_at_hccnet.nl> wrote:
>It must be Oracle because NT is hardly using any processor activity or
>disk performance. It sometimes takes a long time to export tables
>which have no records in it. Somewhere in Oracle is a bottle neck
>which slow down the export.
>
Just some wild guesses:
These tables with no records - have they ever had records? If so, try truncating the tables.
Sounds like some transactional thing, though. Have you used OEM to see if there are some bizarro locks outstanding?
Are you using any Java to connect to the db? Have any timeouts set in SQL*Net?
Are you using dblinks of any kind? Standby db? Are you seeing any interesting things regarding archive logging?
jg
-- These opinions are my own. http://www.garry.to Oracle and unix guy. mailto:joel-garry_at_nospam.cox.net Remove nospam to reply.Received on Wed Jul 10 2002 - 00:50:22 CDT