Re: Bulking up loops

  • From: Martic Zoran <zoran_martic@xxxxxxxxx>
  • To: gogala@xxxxxxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 11 Jan 2005 03:59:53 -0800 (PST)

Hi Mladen,

A some time ago I found that 10g is boosting some
simple PL/SQL code.
I went into and find out this functionality about
prefetching (bulk fetches).
The discussion + some code you can find on


--- Mladen Gogala <gogala@xxxxxxxxxxxxx> wrote:

> In a recent article to
> Connor McDonald
> hinted that Oracle 10g does automatic bulk loads for
> "cursor for =20
> loops", if coded properly. I wasn't able to find
> anything about it.
> Does anybody here know what Connor is talking about?
> A pointer to
> an article or an example, maybe?
> --=20
> Mladen Gogala
> Oracle DBA

Do you Yahoo!? 
Yahoo! Mail - You care about security. So do we.

Other related posts: