| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_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_at_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_at_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). Received on Thu Dec 07 2000 - 10:18:12 CST
 |
 |