Application Performance

From: Ivan <igvasquez_at_hotmail.com>
Date: Mon, 29 Apr 2002 17:59:01 -0400
Message-ID: <aakfn6$nu5$1@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 Mon Apr 29 2002 - 16:59:01 CDT