Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: When to use bulk binds?
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.
-- Daniel Morgan http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Thu May 01 2003 - 20:30:44 CDT