Re: Bulking up loops

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 8 Jan 2005 18:58:17 -0000

The 10g pl/sql compiler does "loop optimization" of
IMPLICIT cursor for loops by turning them into 
array fetches of size 100 in an outer loop.

There's a one-slide summary in my OW presentation


Jonathan Lewis
The Co-operative Oracle Users' FAQ
Public Appearances - schedule updated Dec 23rd 2004

----- Original Message ----- 
From: "Mladen Gogala" <gogala@xxxxxxxxxxxxx>
To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Sent: Saturday, January 08, 2005 6:48 PM
Subject: Bulking up loops

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?

Mladen Gogala
Oracle DBA



Other related posts: