RE: PL/SQL Automatic BULK
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <bruce.mccartney@xxxxxxxxxxxxxxxxx>
- Date: Thu, 17 Mar 2005 18:57:06 +0100
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
Other related posts:
