need urgent help! why is parsing=executing in v$sqlarea

From: Tobias Hitzfeld <Hitzfeld_at_Schoepflin.de>
Date: 1997/10/04
Message-ID: <34367449.28ECD362@Schoepflin.de>#1/1

<HTML>

Hi profs!

We've got a problem in our production database.
 We 're using sql-statements (insert,update) and the parse_calls is
almost exactly the amount of executions of the statement.
 We're using bind variables and have got an amount of free memory 1116572bytes
(v$sgastat).
 The statements are written as embedded sql (ProCobol).

Here's an example, how it works:

SQL*Plus>create table x (y number);

SQL*Plus> var a number;
 SQL*Plus>begin
        2> :a:=5;
        3> insert into x values(:a);
        4> end;
        5> /
 ...successfully completed.
 SQL*Plus>/
 SQL*Plus>/
 SQL*Plus>/
 -> 5 rows created !!!

ORA 7.1.4:
 select executions,parse_calls from v$sqlarea
 where upper(sql_text) like 'INSERT INTO X%'
 /

EXECUTIONS PARSE_CALLS
 ----------------  -----------------
                     
10                         5
 ...
 ORA 7.3.2.3.0:
 select executions,parse_calls from
v$sqlarea
 where upper(sql_text) like 'INSERT
INTO X%'
 /

=> each execution is one parsing.    =>=>=>=>
WHY ???

Please help !!!!!

Yours Tobias Hitzfeld.
 Oracle DBA</HTML>
Received on Sat Oct 04 1997 - 00:00:00 CDT