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: ADO connection to Oracle gets a listener error, but only on the first few attempts

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

From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Mon, 16 Jun 2003 16:28:26 GMT
Message-ID: <KemHa.344$Fa6.298@sccrnsc02>


In addition to Brian's recommendation you can read the Oracle documentation for Application developers.
Jim

-- 
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Brian Peasland" <oracle_dba_at_remove_spam.peasland.com> wrote in message
news:3EEDD5E0.1EE5D544_at_remove_spam.peasland.com...

> 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 - 11:28:26 CDT

Original text of this message

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