PL/SQL stored procedure performance questions

From: bob sullivan <bsullivn_at_comcast.net>
Date: Sat, 22 Jun 2002 02:30:44 GMT
Message-ID: <3D13E168.7E5E5F7E_at_comcast.net>

Hi, everyone,

[Quoted] [Quoted] A couple of questions...

I've inherited a bunch of PL/SQL code that's written in the form of anonymous block script files that are called from SQL*Plus. Would I get any performance benefit by rewriting them as stored procedures?
Is there a byte limit for stored packages that I should not exceed for performance reasons? I have a couple of packages that could be logically rewritten as one package, but I don't want to do that if their size together exceeds an optimal size threshold that I don't know about...

Thanks!
bob
bsullivn_at_comcast.net Received on Sat Jun 22 2002 - 04:30:44 CEST

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]