Thanks for the pointer. I'll go find a copy. I'm sure they have it
online somewhere. When in doubt, RTFM! :-)
"Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message news:<KemHa.344$Fa6.298_at_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 - 18:42:07 CDT
