Tom Kyte wrote an excellent article describing some of the activities that make up a hard parse versus a soft parse. There is also a discussion of the benefits of the SESSION_CACHED_CURSOR parameter. Here is a link to this article

--> Click Here ---> Tom Kyte Explains Parsing for SQL and XML

Need Help?
Clark Fork Data Systems, Inc. can assist you with any of your Oracle database administration needs.

Call today! 650-275-2989
Email gpmilliken@clarkforkdata.com