Hi List, Saw this mentioned at OOW, anybody seen it work? The jist is that the new optimizing compiler will take a static sql cursor for loop and 'bulkify' it. Bryn Llewellyn of Oracle gave an example of the benefits. I have a 3rd party app not scaling because the plsql does't use FORALL or BULK COLLECT, but want to assess whether a 10g upgrade would help (without actually upgrading...). My questions are: What limits are in the optimizer bulkification process, and Can you tell if bulkification is performed without running the p/sql. I am considering exporting the user to a 10g test database and compiling, but don't have enough disk to do a real data test...
