Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: When to use bulk binds?
Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3EB1CA44.30E2F660_at_exxesolutions.com>...
> Jusung Yang wrote:
>
> > Would be nice if you can post your codes, easier to understand your
> > situation that way. You use bulk bind to reduce the context switch
> > overhead between SQL and PL/SQL.
> >
> > <snipped>
>
> Your statement brings an interesting question to mind. With Oracle 9i the SQL and PL/SQL engines were
> combined.
>
> Did this elminate the context switching?
>
> Thanks.
They now share the same "SQL parser", Daniel. This according to Tom Kyte. So there will still be a switch between SQL and PL/SQL.
![]() |
![]() |