Re: CURSOR_SHARING=FORCE

Harvinder,

Cursor_sharing does not reduce soft parsing, only hard parsing, and hard parsing is only reduced if there are statements that only differ in literals.  When you say query performance degrades, where do you actually loose? Parsing or executing?

I suggest you read my white paper on bind variables and cursor sharing, available from http://otn.oracle.com/deploy/performance.

Thanks, Bjørn.

On Thursday 14 March 2002 16:13, Harvinder Singh wrote:
> Hi,
>
> We are experiencing very high value of Soft Parse and Hard Parse and we try
> to
> put CURSOR_SHARING=FORCE but that degrade the performance of queries.
> We are having 9.0.1.2.1 on Win 2k.
> What can be the other options along with Cursor_sharing to redunce soft and
> hard parse.
>
> Thanks
> --Harvinder

-- 
Bjørn Engsig, Miracle A/S
http://MiracleAS.dk
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?=
  INET: bjorn_at_MiracleAS.dk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).