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
asktom.oracle.com.

Regards,
Zoran



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

> In a recent article to comp.databases.oracle.server
> 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. 
http://promotions.yahoo.com/new_mail
--
//www.freelists.org/webpage/oracle-l

Other related posts: