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

    Unanswered: Export impacts Windows activity

    Dear group,

    I'd like to know whether somebody has experienced a problem like ours. We run Oracle 10.2.0.3 on Windows, but the problem happened also on 9.2.0.7. 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 10.2.0.3 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
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking

    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
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    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
    Posts
    796
    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
    Location
    Reading, UK
    Posts
    1,137
    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.

    Alan

Posting Permissions

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