Trouble with package execution after Oracle upgrade

pts.
Tags:
Database
Hardware
IBM DB2
Oracle
Software
Our database was recently upgraded from Oracle 8.0.6 to 9.2.0.7 just before I started to work here. They have a package with a maximum of 32 input report parameters that was working very well under the 8.0.6 version that now is extremely SLOW [and in some cases never returns at all] under 9.2.0.7 - is there anything we should be aware of or investiagte regarding the 9.2.0.7 setup? Incidentally, know several avenues we can pursue, but hate to waste the time if we can be pointed properly. Thank You!

Answer Wiki

Thanks. We'll let you know when a new response is added.

I don’t have a simple answer to your question.
In order to tune the package to the new version the method I used (rather cumbersom and probably there is a better one)was to run the package statements under the SQL prompt and see which statement was causing the slow down.
I would then use EXPLAIN to tune the DB. But like I said this was an empiric method and I’ll be waiting for someone to give us a better one.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • DonMonroe
    I agree with the above reply to find out what is causing the slow down. It could possibly be an index that has not been recreated when you went from 8.0.6 to 9.2.
    0 pointsBadges:
    report
  • Phantomf8
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/trouble-with-package-execution-after-oracle-upgr... (0) Comments Read [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following