Re: Ref cursor length limit...

From: Alexander Gorbachev <gorbyx_at_gmail.com>
Date: Mon, 22 Nov 2004 00:06:52 +0100
Message-ID: <c2213f680411211506ea5e2f5@mail.gmail.com>

Even better - consider using PL/SQL tables. We used global temporary tables approach and we hit another problem - using temporary tables generates lots of redo (Oracle confirmed that). So we reduced amount of generate redo considerably moving to PL/SQL tables for filering criteria.

HTH,
Alex

On Sun, 21 Nov 2004 15:12:13 -0500, Stephens, Chris <chrisstephens_at_pqa.com> wrote:
> That's actually the proposed solution to the problem. ...but I need a
> good reason to change the app this late in the game.
>
> chris=20
>
>
>
> -----Original Message-----
> From: Reidy, Ron [mailto:Ron.Reidy_at_arraybiopharma.com]=20
> Sent: Sunday, November 21, 2004 3:10 PM
> To: Stephens, Chris; oracle-l_at_freelists.org
> Subject: RE: Ref cursor length limit...
>
> Why not use global temporary tables in place of the list of id's? This
> may help lower the potential hard parse count you are likely to
> encounter.

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Nov 21 2004 - 17:03:22 CST