Re: Performance degradation using packages?

From original note >>
An Oracle 7.1 batchjob (pl/sql) loops through a table with some 250000 records. The job uses a number of custom packages to mimic an object oriented approach. The custom packages mainly fetch data from a number of tables to do some calculation. Will the 'packaged object oriented' approach introduce a severe performance
degradation?? <<

It is very hard to say based on the information given. SQL executed from packages runs just fine. Our shop makes heavy use of packaged procedures.  The answer depends on just how object oriented did you get? If the process added a lot of hoops to act object oriented then you may have hurt performance.

Is most of the SQL in the packages straight SQL or pl/sql cursors? If you tuned the SQL and if you are not updating the same table that you are reading in multiple user sessions then you are probably OK.

You should consider pinning the packages into the shared pool if you have not already done so. Received on Sat Feb 08 1997 - 00:00:00 CET