关于cursor_sharing=similar

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

本文作者:biti_rainy(biti_rainy@itpub.net)

 

摘要：本文通过简单实验来尝试说明 cursor_ sharing= similar的含义。
1.1.       实验现象
我们先看看在表没有分析无统计数据情况下的表现 

SQL>altersessionset cursor_ sharing= similar;

 

Sessionaltered.

 

SQL>selectname,valuefromv$sysstatwherenamelike'%parse%';

 

NAME                                                                 VALUE

--------------------------------------------------------------------------

parsetimecpu                                                        4948

parsetimeelapsed                                                   4468

parsecount(total)                                                  170148

parsecount(hard)                                                   1619 (硬分析次数)

parsecount(failures)                                               80

 

SQL>selectcount(*)fromtwhereobject_id=1000;

 

  COUNT(*)

----------

         0

 

SQL>selectname,valuefromv$sysstatwherenamelike'%parse%';

 

NAME                                                                 VALUE 1 <script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>