Excessive parse calls

From: Vsevolod Afanassiev <vafanassiev_at_aapt.com.au>
Date: 25 Mar 2002 23:01:26 -0800
Message-ID: <4f7d504c.0203252301.226fe380@posting.google.com>

What causes excessive re-parsing of statements with bind variables? I have set in init.ora

cursor_space_for_time = true
open_cursors = 400
session_cached_cursors = 200
shared_pool_size = 100,000,000

Stiil, query

select

   sql_text,
   parse_calls,
   executions
from

v$sqlarea

shows that many statements are parsed every time they are executed. This is very simple application, it does not use outlines, optimize_mode = choose, no statistics has been collected for the tables/indexes. Received on Tue Mar 26 2002 - 01:01:26 CST