Re: Ref cursor length limit...
- From: Alexander Gorbachev <gorbyx@xxxxxxxxx>
- To: chrisstephens@xxxxxxx
- Date: Mon, 22 Nov 2004 00:06:52 +0100
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@xxxxxxx> 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@xxxxxxxxxxxxxxxxxx]=20
> Sent: Sunday, November 21, 2004 3:10 PM
> To: Stephens, Chris; oracle-l@xxxxxxxxxxxxx
> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
