Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: When to use bulk binds?

Re: When to use bulk binds?

From: Jusung Yang <JusungYang_at_yahoo.com>
Date: 2 May 2003 02:04:28 -0700
Message-ID: <130ba93a.0305020104.5ed798b3@posting.google.com>


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.

Received on Fri May 02 2003 - 04:04:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US