Message-Id: <10703.123940@fatcity.com> From: "Gogala, Mladen" Date: Thu, 7 Dec 2000 11:18:12 -0500 Subject: RE: How to make a PL/SQL faster? Map the packages to the external C routines (not Java, we are talking performance here), optimize the C routines and do it there. -----Original Message----- From: Andor Gyula [mailto:gy.andor@euromacc.hu] Sent: Thursday, December 07, 2000 2:40 AM To: Multiple recipients of list ORACLE-L Subject: How to make a PL/SQL faster? Hi Gurus ! How could I make a PL/SQL faster. I've got two packages. In both packages there are procedures that perform string and PL/SQL table operations only. Beside these there is a TEST procedure that permorms 1000x an operation using the packeges mentioned above. This is for performace testing. The problem is the following: If the package owner executes the TEST procedure, then it completes very slow, but if any other user performs the TEST procedure it completes vert fast. I don't know what can be the cause of such a behavior. In both cases I use the SYS.DBMS_SHARED_POOL.KEEP to pin the packages and the standard packege into the memory. Any idea? Thanks in advance. Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor Gyula INET: gy.andor@euromacc.hu 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@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).