Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> PL/SQL Automatic BULK
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...
TIA
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 17 2005 - 12:06:42 CST