Oracle Hard Parsing v. Soft Parsing and the impact of SESSION_CACHED_CURSOR parameter
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
Clark Fork Data Systems, Inc. can assist you with any of your Oracle database administration needs.
Call today! 650-275-2989