RE: soft parse

[Cary Millsap]

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, Aug 16 Chicago - Miracle Database Forum, Sep 20–22 Middlefart Denmark - 2003 Hotsos Symposium on Oracle® System Performance, Feb 9–12 Dallas -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of BigP Sent: Friday, August 02, 2002 3:13 PM To: Multiple recipients of list ORACLE-L Subject: soft parse   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