-
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
-
Would an analyze help this one?
Is it required after converting.
That is my lame guess.
MH
I remember when this place was cool.
-
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
I remember when this place was cool.
-
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,12c
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|