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 <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
