- Use bind variables in your statements and avoid too much of dynamic
SQL
- Migth look at setting CURSOR_SHARING=FORCE, but it has its own bugs
with certain releases and patchsets. Although, might make it better.

Best regards,

Paul Tabashov
http://www.pontis.biz


-----Original Message-----
From: Rana rana [mailto:[Email Address Removed]
Sent: Friday, October 31, 2003 8:59 AM
To: LazyDBA.com Discussion
Subject: Urgent Parse to execute


Friends
I have a high parse to execute ratio as shown by Toad.Can
anyone tell me how to ratify the said problem

Thanx

Yahoo! India Matrimony: Find your partner online.Post your profile.
Oracle LazyDBA home page