Re: PL/SQL stored procedure performance questions
From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Fri, 21 Jun 2002 23:45:26 -0700
Message-ID: <3D141D06.5DD89A81_at_exesolutions.com>
Date: Fri, 21 Jun 2002 23:45:26 -0700
Message-ID: <3D141D06.5DD89A81_at_exesolutions.com>
bob sullivan wrote:
> Hi, everyone,
>
> A couple of questions...
>
> 1. 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?
>
> 2. 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
- If they were run by multiple users all of the time yes. If they are run only from time-to-time probably not. I would still be inclined to turn them into stored procedures, performance improvement or not just for security. Scripts have a habit of disappearing or being modified without accountability. [Quoted]
- No. And if there is you are in no danger of approaching it until you've written something far larger than the size of Oracle Financials.
Daniel Morgan Received on Sat Jun 22 2002 - 08:45:26 CEST