You should be using stored procedures if you're after performance ...
see http://www.hpdbe.com/white_papers/index.html for reasons why you
should. There's also a cool write up on optimizing updates too --
well, I think it's cool. :)
--
Pablo Sanchez, High-Performance Database Engineering
mailto:pablo_at_hpdbe.com
http://www.hpdbe.com
Available for short-term and long-term contracts
"Ivan" <igvasquez_at_hotmail.com> wrote in message
news:aakfn6$nu5$1_at_cronkite.cc.uga.edu...
> Hey,
>
> I'm testing a web application performance using Oracle performance
manager
> and a web stress generator. The database calls I wrote in this app.
are
> intended to reuse query execution plans (i.e. for a login screen).
>
> In one side, I query the v$sql system view to check for any
execution plans
> that might be being reused and I get this kind of results:
>
> Select * from SPS.PA_CUST_SEL_CTL where PCC_CUSTOMERID=:V0001
> INSERT INTO SPS.PA_CUST_ADDRESS VALUES (
> b1,:b2,:b3,:b4,:b5,:b6,:b7,:b8,:b9 )
>
> This makes me think query plans are actually being parameterized
(reused) as
> I intend to.
>
> However, looking at TOAD's database monitor, I see that "parses" are
> happening almost as frequently as executions (1:1). Performance
manager's
> "Executes without Parses %" counter gives me lower rates than those
I would
> like to get (< 70%).
>
> Do "parses" mean "compilations"? What could I be doing wrong? Are
v$sql and
> these counters measuring the same thing?
>
> Note: All queries are using indexes and the database server (Oracle
9i on
> Linux) isn't doing anything but testing.
>
> Thanks in advance.
> Ivan.
>
>
Received on Fri May 03 2002 - 10:34:08 CDT
