Slow Export After Upgrading To 9.2.0.3
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Slow Export After Upgrading To 9.2.0.3

  1. #1
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    150

    Question Slow Export After Upgrading To 9.2.0.3

    Hi,

    I noticed that after we upgrade our db to 9.2.0.3 from 9.2.0.1, the export runs extremely slow. Has anybody seen this issue, please share your inputs.

    Thanks,


    Ed

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    Would an analyze help this one?
    Is it required after converting.
    That is my lame guess.

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I dont think it's statistics problem, export always do full table scan so this doesnt sound like statistcis issue. Look wait events when you are exporting

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    That's a good point, it does not have to be the new release. Are their any other jobs (either Oracle or OS) running on the box that could be affecting this?

    MH
    I remember when this place was cool.

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Slow Export After Upgrading To 9.2.0.3

    Originally posted by edsperez
    Hi,

    I noticed that after we upgrade our db to 9.2.0.3 from 9.2.0.1, the export runs extremely slow. Has anybody seen this issue, please share your inputs.

    Thanks,


    Ed
    Did you get errors after running the patch? Did you startup migrate and then run catpatch?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

Posting Permissions

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



Click Here to Expand Forum to Full Width