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
Printable View
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
Would an analyze help this one?
Is it required after converting.
That is my lame guess.
MH
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
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
Did you get errors after running the patch? Did you startup migrate and then run catpatch?Quote:
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