Re: ADO connection to Oracle gets a listener error, but only on the first few attempts

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%.
Received on Sat Jun 14 2003 - 16:00:11 CDT