Message-Id: <10702.123903@fatcity.com> From: "Andor Gyula" Date: Thu, 07 Dec 2000 08:41:05 +0100 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.