Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ADO connection to Oracle gets a listener error, but only on the first few attempts
Great information about bind variables, and many other topics, can be
found in Tom Kyte's Expert One-on-one Oracle from Wrox Press.
HTH,
Brian
Mark Freeman wrote:
>
> Jim,
>
> That sounds like something I should investigate. I must admit to not
> having heard of host/bind variables; I am very must a beginner when it
> comes to Oracle. Do you have a recommendation for a source of good
> information about them?
>
> - Mark
>
> "Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message news:<vDHFa.949754$Zo.216344_at_sccrnsc03>...
> > My guess is that you could improve performance if you used host variables -
> > opened the connection , parsed the query, executed multiple times (with
> > different values). Your high CPU usage on the server and long CPU queue
> > length is indicative of not using bind variables. You are forcing Oracle to
> > do a hard parse each and every time and that is highly CPU intensive.
> >
> > I had a developer who didn't believe in bind variables and on a particular
> > benchmark - importing 1,000 records via his program - it would take 26
> > minutes and peg the CPU. We changed it so he used bind variables, parsed
> > one, and executed many times and the benchmark went to under 6 minutes with
> > CPU usage peaking occasionally at 10%.
-- =================================================================== Brian Peasland oracle_dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Mon Jun 16 2003 - 09:36:16 CDT