Oracle-L: Re:Using User Defined functions or not

From: <dgoulet_at_vicr.com>
Date: Tue, 19 Feb 2002 14:29:00 -0800
Message-ID: <F001.004139FE.20020219142900@fatcity.com>

Harvinder,

I use a fairly large number of user defined functions/procedures. There has been a significant improvement in database performance with them. On top of that there is a lot of improved consistency in the application of business rules to boot. One item I would recommend is enlarging your shared_pool as that's where these little beasties reside & it sure does not help having to constantly reload them. It also helps to bundle these small functions into larger packages that are easier to either pin or keep memory resident as they're always being used.

Dick Goulet

____________________Reply Separator____________________
Author: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date:       2/19/2002 1:59 PM

Hi,

This question is with reference to tuning.....Developers are repeatdely using same code ( for example if they want to add as second to date ther are using like date+1/86400) and they want to use something like following function so that they can write addsecond(date) in their code...

function AddSecond(RefDate date) return date

                                as
                                begin
                                 return RefDate + 1/86400;
                                end;

Issus is now of performance.......it looks like using function is degrading the performance ......Does it advisable to use extensive use of UDF in code????

Thanks
--Harvinder
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Harvinder Singh
INET: Harvinder.Singh_at_MetraTech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------


To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------


To REMOVE yourself from this mailing list, send an E-Mail message