RE: PL/SQL Automatic BULK

Hi Bruce

>Saw this mentioned at OOW, anybody seen it work?

If you enable SQL trace you will "see" it.

>The jist is that the new optimizing compiler will
>take a static sql cursor for loop and 'bulkify' it.

It's a prefetching. Basically instead of fetching one single row at a = time, now 100 rows are prefetched.

>What limits are in the optimizer bulkification process

The prefetching feature is only enabled for queries, i.e. there's no = automatic FORALL...

>Can you tell if bulkification is performed without running the p/sql.

If PLSQL_OPTIMIZE_LEVEL is set to 2 the feature is activated.

HTH
Chris

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