Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2002
    Madrid, Spain

    Unanswered: Export impacts Windows activity

    Dear group,

    I'd like to know whether somebody has experienced a problem like ours. We run Oracle on Windows, but the problem happened also on When we run an Export FULL, lasting one hour, there is a serious impact on Windows availability. At moments, Windows seems to freeze during some seconds; during these episodes, no one gets any response even for the simplest Windows tasks. Sorry for the poorly elaborated question, but we haven't gathered more info about the case.

    Our environment is:
    Oracle on Windows 2000 SP4
    Export launched with options: full=y direct=y
    Other products running in Windows: McAfee antivirus
    Patrol Agent statistics collector and
    Control-M Agent (job scheduler)

    Thanks in advance,
    Mariano Corral

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL


    Hi Mariano,

    There is nothing wrong with Oracle, your main problem is: WinDoze!

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    If you can afford it, perform Export during non-working hours. You can schedule it using Windows Task Manager.

  4. #4
    Join Date
    Jun 2004
    Provided Answers: 1
    Have you tried running an export with each of the other programs in turn disabled? It may be that one of them is affecting the export.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  5. #5
    Join Date
    Mar 2002
    Reading, UK
    Use Task Manager and the Performance monitor to find the process which is chewing up CPU and or IO. I suspect though that your McAfee antivirus may be the culprit, we have turned it off for our Oracle database files.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts