Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!nx02.iad01.newshosting.com!newshosting.com!216.196.98.140.MISMATCH!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!h76g2000cwa.googlegroups.com!not-for-mail
From: "Tzanko" <tzanko.tzanev@strategicthought.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: How to avoid soft parses with ADO
Date: 6 Jun 2006 04:02:36 -0700
Organization: http://groups.google.com
Lines: 12
Message-ID: <1149591756.508974.35040@h76g2000cwa.googlegroups.com>
References: <1149526294.947034.47200@h76g2000cwa.googlegroups.com>
   <1149580473.082810.120580@g10g2000cwb.googlegroups.com>
NNTP-Posting-Host: 217.196.251.97
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1149591761 1852 127.0.0.1 (6 Jun 2006 11:02:41 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 6 Jun 2006 11:02:41 +0000 (UTC)
In-Reply-To: <1149580473.082810.120580@g10g2000cwb.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: h76g2000cwa.googlegroups.com; posting-host=217.196.251.97;
   posting-account=CRKB0A0AAADCkHMO_GpHwRtX6SO1Nyi9
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:268605


Thanks for the reply.
My session_ casched_cursor is set to 0, which I understand is default
and is actually 50. I can monitor that each session caches up to 50
cursors. I will try raising this a bit.
I use the same user to connect to the database and it is my
understanding that synonyms will not help.
Can you please send me a link to 1012049. I have Metalink access, but
could not find it.

many thanks, Tzanko