Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance degradation using packages?
Hugo B. Baake wrote:
>
> I would like to have some input on the following question:
>
> 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??
>
> Thanks for any input,
>
> Hugo
Not as long as your shared pool is sufficiently large to allow all of
these packages to remain resident and valid for the life of the job.
-- Rich Woods Technical Field Support Specialist, Oracle Corporation, USA The above statements and opinions are my own and do not necessarily represent those of Oracle Corporation.Received on Sun Feb 09 1997 - 00:00:00 CST