RE: soft parse

The way to avoid it is to write your application so that it doesn't ever issue the parse call. The ability to share open cursors across end users is one of the motives for 3-tier architectures.  

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- NCOAUG Training Day <http://www.darc.com/ncoaug/> , Aug 16 Chicago

• Miracle Database Forum <http://www.miracleas.dk> , Sep 20-22 Middlefart Denmark
• 2003 Hotsos Symposium <http://www.hotsos.com> on OracleR System Performance, Feb 9-12 Dallas

-----Original Message-----
Sent: Friday, August 02, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L  

How is it possible to avoid soft parse ? When I open a cursor it is hard parsed and soft parsed first time . If I reuse the same cursor it still needs to go soft parsing ( which is privilage checking ) ..cuz what if privilages change during the first time and second time . I was thinking no way one can avoid soft parse . am I wrong ?  

TIA Bp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Cary Millsap
  INET: cary.millsap_at_hotsos.com

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).