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 -- //www.freelists.org/webpage/oracle-l