Interesting performace experienced. Have no idea. HELP !

From: Andor Gyula <gy.andor_at_euromacc.hu>
Date: Tue, 05 Dec 2000 17:53:53 +0100
Message-Id: <10701.123683@fatcity.com>

Hi gurus !

I've got an interesting expereince. The procedure below runs faster or slower depending on the user that owns this procedure.

If the procedure belongs to the SYSTEM user it completes in a very short time, but if it belongs to any other user it becomes very slow. Why? The SYSTEM and the other users has the same profile.

What can cause the difference in performace?

Any idea?

Thanks in advance.

Gyula

---

CREATE OR REPLACE PROCEDURE PROC1 IS
tmpVar NUMBER;
BEGIN

SYS.DBMS_SHARED_POOL.KEEP('USER1.paramset');
SYS.DBMS_SHARED_POOL.KEEP('USER1.strutil');
SYS.DBMS_SHARED_POOL.KEEP('sys.standard');
	USER.paramset.test; /*runs a processing 1000 times*/
SYS.DBMS_SHARED_POOL.UNKEEP('USER1.paramset');

SYS.DBMS_SHARED_POOL.UNKEEP('USER1.strutil'); SYS.DBMS_SHARED_POOL.UNKEEP('sys.standard'); Received on Tue Dec 05 2000 - 10:53:53 CST