So there is one parse for every two executes. I think that there is a problem 
in the application. It could be a describe that precedes every other execute 
or so or a soft parse happens for each. Or ......

Could it that 40 different sessions run in the same trace file ? Each session 
will do a soft parse no matter what.

Anjo.

On Thursday 13 February 2003 10:59, you wrote:
> Tim,
>
> By "JDBC Thin program", are you referring to the JDBC Thin driver
> or the program that uses the JDBC Thin driver, i.e. the application.
> I assume you are talking about the later.
>
> Our application is written in Java and uses JDBC Thin and I don't
> see any of the hard parse problem.
>
> Thanks
>
> Richard
>
> -----Original Message-----
> Sent: Thursday, February 13, 2003 11:14 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Not an RDBMS bug -- it is the behavior of both your JDBC thin program as
> well as SQL*Plus.  Every execute is preceded by a parse in SQL*Plus -- they
> didn't write that utility with parsing efficiency as a primary goal.
>
> Apparently, neither was the JDBC thin code...
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Thursday, February 13, 2003 7:49 AM
>
> > Dear friends,
> >
> > I traced one of our test cases and found something weird.
> >
> > Did anybody else observe this?
> >
> > Env:
> > server - 9.0.1.4, Solaris.
> > client - weblogic 7, uses original oracle thin 9.0.1 jdbc driver to
>
> connect.
>
> >          In fact, I can reproduce all this from SQLPlus
> >
> > Here is an excerpt from tkprof below - why every parse is a hard parse?
> > Looks like the problem doesn't appear when 10046 is not set, and it
> > appers ONLY on pl/sql blocks returning data to client, normal selects OK.
> > Looks like bug again. Any workaround?
> >
> > And what are these "Misses in library cache during execute"?
> >
> > 9.2.0.2 on Linux works fine, i.e. no misses once it has been parsed.
> >
> >    BEGIN :1 := FN_GET_STATUS_ID(:2,:3); END;
> >
> >
> >    call     count       cpu    elapsed       disk      query    current
> > rows
> >    ------- ------  -------- ---------- ---------- ---------- ----------
> > ----------
> >    Parse       40      0.07       0.08          0          0          0
> > 0
> >    Execute     80      0.62       1.55         64       1492          0
> > 80
> >    Fetch        0      0.00       0.00          0          0          0
> > 0
> >    ------- ------  -------- ---------- ---------- ---------- ----------
> > ----------
> >    total      120      0.69       1.63         64       1492          0
> > 80
> >
> >    Misses in library cache during parse: 40
> >    Misses in library cache during execute: 40
> >    Optimizer goal: CHOOSE
> >    Parsing user id: 40
> >
> > This select
> >
> >    select LOADED_VERSIONS, EXECUTIONS, LOADS,PARSE_CALLS, parsing_user_id
> >    from v$sql
> >    where sql_text like 'BEGIN :1 := FN_GET_STATUS_ID(:2,:3); END;';
> >
> > gives out whole bunch of these record groups
> >
> >    LOADED_VERSIONS EXECUTIONS      LOADS PARSE_CALLS PARSING_USER_ID
> >    --------------- ---------- ---------- ----------- ---------------
> >               1          1          1           1              40
> >               1          1          1           0              40
> >    .... repeated N times
> >
> > Thank you for you time
> >
> > Vadim G
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Gorbounov,Vadim
> >   INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> > San Diego, California        -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).  You may
> > also send the HELP command for other information (like subscribing).

-- 
----------------------------------------------------------------
Anjo Kolk
http://www.oraperf.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Anjo Kolk
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Reply via email to