PL/SQL Automatic BULK
- From: "Bruce McCartney" <bruce.mccartney@xxxxxxxxxxxxxxxxx>
- To: <Oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 17 Mar 2005 10:03:06 -0700
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-l
Other related posts: