来自AskTom的关于Soft Parse的解释

原创 2004年09月16日 03:14:00

There are two types of parses (well, actually "three" these 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 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



 

Hard Parse&Soft Parse

Hard Parse&Soft Parse解释

fast parse,soft parse,hard parse的区别

[http://hi.baidu.com/edeed/blog/item/5c99e711011d3cc3a6ef3f58.html] fast parse,soft parse,hard pars...

asktom2.rar

  • 2008年03月16日 13:44
  • 3.3MB
  • 下载

SQL 2002年度总结 asktom-2002.chm

  • 2007年08月27日 14:32
  • 5.48MB
  • 下载

使用MG-SOFT的MIB Builder编写mib文件或者.my文件方法

本文转载自:http://blog.csdn.net/zhulinfeiba/article/details/6184075感谢原作者的奉献! 1.点击菜单File->New...,在弹出的...

ASKTom_oracle.part1.rar

  • 2011年01月24日 17:53
  • 19MB
  • 下载

asktom2008年问题集合

  • 2009年09月12日 15:47
  • 7.61MB
  • 下载

[Java] weak reference 和 soft reference

Other reference: http://www.cnblogs.com/abob/archive/2009/10/27/1590711.htmlhttp://www.ibm.com/deve...
  • Giegie
  • Giegie
  • 2011年04月26日 10:10
  • 425

asktom1.

  • 2008年03月16日 13:32
  • 3.3MB
  • 下载
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:来自AskTom的关于Soft Parse的解释
举报原因:
原因补充:

(最多只允许输入30个字)