There Are Two Types of Parses (Well, Actually "Three" There Days) .They Are O Hard Parse - The Query Has Never Been Seen Before, ISN't In The Shared Pool. WE Must Parse IT, Hash IT, Look in The Shared Pool for IT, Don't Find IT, Security Check IT, Optimize It, ETC (LOTS of Work) .o Soft Parse - The Query Has Been Seen Before, IS in The Shared Poo. We Have to Parse IT, Hash IT, LOOK IN The Shared Pool for IT and Find IT (Less Work Ten a Hard Parse But Work None The Less) Oa Kinder, Softer Soft Parse - You Are Using Session_Cached_Cursors (Search this Site for That Word for Info). WE . take your query, look in the sessions cursor cache - find the cursor and reuse it Very very little work.So, after "startup", you go into sqlplus and do this: SQL> alter session set session_cached_cursors = 0; - Just Making Sure This Is Offsql> Select * from Emp; - Hard Parsesql> Select * from Emp; - Soft Parsesql> Select * from Emp; - Soft Parsesql> ALTER Session Set Session_Cached_cursors = 100; Enable this featureSQL> SELECT * from Emp; - Soft Parsesql> Select * from Emp; - Kinder, Gentler, Soft Parse
LINK:
Http://asktom.racle.com/pls/ask/f?p=4950:8::::::f4950_p8_displayid:80162252143