Home > IT Answers > Database > Trouble with package execution after Oracle upgrade
Phantomf8
0 pts.
 Trouble with package execution after Oracle upgrade
Database, DB2, Hardware, 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!

Software/Hardware used:
ASKED: April 11, 2006  6:07 PM
UPDATED: April 12, 2006  8:20 AM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  April 12, 2006  6:35 am  by  Posoriotech   0 pts.
All Answer Wiki Contributors:  Posoriotech   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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.

DonMonroe
 0 pts.