How to make a PL/SQL faster?

From: Andor Gyula <gy.andor_at_euromacc.hu>
Date: Thu, 07 Dec 2000 08:41:05 +0100
Message-Id: <10702.123903@fatcity.com>

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. Received on Thu Dec 07 2000 - 01:41:05 CST