oracle ask tom,来自AskTom的关于Soft Parse的解释-数据库专栏,SQL Server

there are two types of parses (well, actually “three” these days).

they are

o hard parse — the query has never been seen before, isnt in the shared pool.

we must parse it, hash it, look in the shared pool for it, dont 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 then

a hard parse but work none the less)

o a 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 off

sql> select * from emp;  — hard parse

sql> select * from emp; — soft parse

sql> select * from emp; — soft parse

sql> alter session set session_cached_cursors=100; — enable this feature

sql> select * from emp;  — soft parse

sql> select * from emp; — kinder, gentler, soft parse

link：

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::f4950_p8_displayid:801662252143